Senior Data Modeler and Data Architect

Role Overview: As a Staff Engineer, Data Modeler at NextGen Healthcare, you will play a crucial role in shaping and managing data models and architecture to enable the organization to efficiently store, analyze, and leverage large-scale healthcare data. Your responsibilities will include developing and implementing reliable, scalable, and effective data models for various data warehouse solutions using cutting-edge tools such as Fivetran, DBT, Snowflake, AWS, Atlan, Erwin ER Diagrams, and Sigma Computing. You will collaborate with a diverse set of stakeholders to develop a comprehensive data architecture that supports decision-making, reporting, analytics, and data governance. Your significant experience with dimensional models, RDBMS, cloud platforms, and ETL processes will be essential in defining and designing data models that support data governance, data quality, and master data management (MDM), while also working with stakeholders to implement data-driven solutions that enhance business outcomes in the healthcare sector. Key Responsibilities: - Design and implement conceptual, logical, and physical data models, including Entity-Relationship (ER) models, Star Schema, Snowflake Schema, Data Vault Modeling, and Dimensional Modeling. - Lead the design of normalized and denormalized structures to meet business requirements and ensure optimal performance of the Data Warehouse and Data Marts. - Collaborate with business and technical teams to map business requirements to data models, ensuring that Master Data Management (MDM) processes and Golden Record concepts are well-defined. - Build and maintain a comprehensive Business Glossary and Data Dictionary to standardize definitions and ensure consistency across the organization. - Ensure that data lineage is accurately defined, visualized, and documented across the Data Warehouse environment. - Oversee the data mapping process to track the flow of data from source to destination, ensuring consistency, integrity, and transparency of data throughout its lifecycle. - Implement Data Governance processes to manage data access, quality, security, and compliance. - Define and enforce Data Quality standards and practices, including Data Cleansing, to ensure data integrity and accuracy within the data warehouse environment. - Design and implement real-time data ingestion pipelines using Kafka, AWS Kinesis, or Snowpipe to enable streaming data integration into the data warehouse. - Implement Change Data Capture (CDC) mechanisms to efficiently capture and propagate data changes from operational systems using tools such as Fivetran or AWS Lambda. - Ensure high standards for data quality through rigorous testing, data validation, and performance optimization. - Work with Data Engineers and development teams to improve data platform automation and enhance the data modeling lifecycle. - Maintain clear and up-to-date documentation for data models, data lineage, data mappings, and architectural decisions. - Develop data architecture for the analytics platform on Snowflake and integrate with other AWS tools for robust data management. - Partner with Product Manager and other technical teams to define requirements and deliver optimal data architecture solutions. - Document all design decisions and data models, adhering to existing guidelines and ensuring clear communication across teams. Qualifications Required: - Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Masters degree is a plus. - 12+ years of hands-on experience in data modeling, data architecture, or information architecture with a focus on large-scale data warehouses. - 10+ years of experience with dimensional models and relational database management systems (SQL Server, Oracle, DB2, etc.). - 5+ years of proven experience with modern data architectures and cloud technologies, especially AWS services and tools. - Experience with ETL tools and automation (e.g., Fivetran, DBT). - Experience with data governance, data quality frameworks, and metadata management. - Certifications in Data Architecture, Cloud Technologies, or related areas is a plus. (Note: Additional details of the company were not included in the provided job description.) Role Overview: As a Staff Engineer, Data Modeler at NextGen Healthcare, you will play a crucial role in shaping and managing data models and architecture to enable the organization to efficiently store, analyze, and leverage large-scale healthcare data. Your responsibilities will include developing and implementing reliable, scalable, and effective data models for various data warehouse solutions using cutting-edge tools such as Fivetran, DBT, Snowflake, AWS, Atlan, Erwin ER Diagrams, and Sigma Computing. You will collaborate with a diverse set of stakeholders to develop a comprehensive data architecture that supports decision-making, reporting, analytics, and data governance. Your significant experience with dimensional models, RDBM