What are the responsibilities and job description for the Senior Data Modeler Erwin & Azure Focus position at 1872 Consulting?
Senior Data Modeler – Erwin & Azure Focus
Hybrid Onsite – 3-4 days work from home, 1-2 days onsite .
Summary
This role is responsible for data modeling using Erwin in an Azure environment, working with Azure Data Factory (ADF) on a regular basis. You will be working with large enterprise data sets, and working closely with business analysts, data engineers, and other stakeholders to design/optimize data structures and flows that facilitate efficient data analysis and reporting.
What you'll be doing
Work with business resources to identify business needs then design and develop conceptual, logical, and physical data models for the needs and support data analysis and reporting.
Define and create ETL processes for data extraction, transformation, and loading into the data warehouse or BI platform.
Implement data quality checks and validation rules to ensure data accuracy and consistency.
Continuously monitor and optimize data models with Erwin and database performance for efficient data retrieval and reporting.
Maintain comprehensive documentation of data models, schemas, and related processes.
Apply knowledge of the data in our ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.
Implement data security measures and access controls to protect sensitive data.
Ensure compliance with data governance and data management best practices.
Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, trouble shooting and analysis.
Identify and execute on new process improvement opportunities.
Work in a highly agile development environment.
Develop a strong understanding of the business and its systems to support the company's strategic objectives.
Maintain up-to-date awareness of current and future directions of business industry and associated technologies.
Skills we're seeking
5 years of experience with Data Modeling
Must have strong Erwin experience to create and manage Logical/physical data models
Also experience modeling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row / object level security designs
Experience working in Azure environments, and must have experience with Azure Data Factory (more the better)
Must have strong SQL experience
Nice to haves
Experience with Azure Synapse Data Marts
T-SQL experience
ETL experience, ideally using Talend or ADF
Power BI experience (but not looking for a Power BI Developer)
Hybrid Onsite – 3-4 days work from home, 1-2 days onsite .
Summary
This role is responsible for data modeling using Erwin in an Azure environment, working with Azure Data Factory (ADF) on a regular basis. You will be working with large enterprise data sets, and working closely with business analysts, data engineers, and other stakeholders to design/optimize data structures and flows that facilitate efficient data analysis and reporting.
What you'll be doing
Work with business resources to identify business needs then design and develop conceptual, logical, and physical data models for the needs and support data analysis and reporting.
Define and create ETL processes for data extraction, transformation, and loading into the data warehouse or BI platform.
Implement data quality checks and validation rules to ensure data accuracy and consistency.
Continuously monitor and optimize data models with Erwin and database performance for efficient data retrieval and reporting.
Maintain comprehensive documentation of data models, schemas, and related processes.
Apply knowledge of the data in our ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.
Implement data security measures and access controls to protect sensitive data.
Ensure compliance with data governance and data management best practices.
Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, trouble shooting and analysis.
Identify and execute on new process improvement opportunities.
Work in a highly agile development environment.
Develop a strong understanding of the business and its systems to support the company's strategic objectives.
Maintain up-to-date awareness of current and future directions of business industry and associated technologies.
Skills we're seeking
5 years of experience with Data Modeling
Must have strong Erwin experience to create and manage Logical/physical data models
Also experience modeling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row / object level security designs
Experience working in Azure environments, and must have experience with Azure Data Factory (more the better)
Must have strong SQL experience
Nice to haves
Experience with Azure Synapse Data Marts
T-SQL experience
ETL experience, ideally using Talend or ADF
Power BI experience (but not looking for a Power BI Developer)
Data Modeler/ Data Architect
Trident Consulting -
Chicago, IL
Healthcare Data Modeler - REMOTE
Perficient -
Chicago, IL
Data Modeler_only on W2
Chelsoft Solutions Co. -
Chicago, IL
