Data Modeler - Python/SQL

Job Title : Data Modeler Job Summary : We are seeking an experienced Data Modeler to join our dynamic team. The ideal candidate will be responsible for developing and maintaining robust data models that meet our business requirements and enhance our data infrastructure. You will work closely with stakeholders to ensure that data models are scalable, efficient, and aligned with our strategic objectives. If you have a strong background in data modeling concepts, cloud environments, and data governance, we invite you to apply and help shape the future of our data ecosystem. Key Responsibilities : - Data Modeling : Develop comprehensive conceptual, logical, and physical data models that meet diverse business requirements, ensuring they are scalable and maintainable. - Enterprise Data Models : Create, maintain, and optimize enterprise data models within cloud environments, such as Google Cloud Platform (GCP) or Amazon Web Services (AWS), to ensure high performance and reliability. - Stakeholder Collaboration : Work closely with business stakeholders to translate business requirements into effective and scalable data models, facilitating communication between technical and non-technical teams. - Performance Optimization : Design and implement partitioning and clustering strategies in BigQuery to optimize query performance and data accessibility. - Data Integrity and Security : Collaborate with Data Architects and Engineers to ensure the integrity and security of data throughout the data pipeline, adhering to best practices in data management. - Data Relationships and Practices : Define data relationships, indexing strategies, and normalization practices to enhance data retrieval and storage efficiency. - Data Consistency and Lineage : Provide guidelines to ensure data consistency, accuracy, and effective data lineage tracking across systems, supporting data governance initiatives. - Quality Standards : Establish standards for data quality and collaborate with Data Quality Engineers to define validation rules and metrics. - Modeling Tools : Utilize data modeling tools (e.g., Erwin, DBT, or equivalent) to create and maintain data models that align with best practices and business needs. - Performance Tuning : Conduct performance tuning of data models and review their impact on overall system performance, making recommendations for improvements. - Versioning and Schema Evolution : Define best practices for data versioning and schema evolution to accommodate changing business requirements and data structure. - Documentation : Ensure thorough documentation of data models and maintain data dictionaries for organizational transparency, aiding in onboarding and knowledge transfer. Required Skillset : - Strong expertise in data modeling concepts and database design, particularly in platforms like BigQuery and Snowflake. - Proficiency in SQL and Python for data manipulation and analysis. - Knowledge of cloud data warehousing solutions and ETL/ELT processes. - Solid understanding of business rules, data governance, and data quality processes. - Excellent communication and collaboration skills, with the ability to work effectively across teams. Why Join Us : We value innovation, collaboration, and the pursuit of excellence. You will have the opportunity to work with cutting-edge technologies and be part of a team that is committed to leveraging data to drive business success. We offer a competitive salary, comprehensive benefits, and a supportive work environment that fosters professional growth. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/20/2024