Senior Data Modeler Erwin & Azure Focus
Hybrid Onsite - days work from home, - 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
- 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)
Senior Data Modeler – Erwin & Azure Focus
Senior Data Modeler – Erwin & Azure Focus. 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 ot...
Senior Data Modeler
They will create and design data structures, tables, and columns, ensuring efficient and optimized data models. Develop logical and physical data models for Traditional Data Stores and MongoDB, SQL, AWS (Postgres, OracleRDS). Develop, test, and implement scripts, programs, and related processes to c...
Senior Data Modeler
They will create and design data structures, tables, and columns, ensuring efficient and optimized data models. Develop logical and physical data models for Traditional Data Stores and MongoDB, SQL, AWS (Postgres, OracleRDS). Develop, test, and implement scripts, programs, and related processes to c...
Azure Senior Data Engineer
Net, C#, Qlik, Power BI, Machine Learning, Azure Data Factory, RedShift, UiPath, Cloud, RPA, AWS, Redshift, Kinesis, QuickSight, SageMaker, S3, Databricks, AWS Lake Formation, Snowflake, Python, Qlik, Athena, Data Pipeline, Glue, Star Schema, Data Modeling, SQL, SSIS, SSAS, SSRS, PySpark, Microsoft ...
CRM Data Modeler, Senior Manager
As a Senior CRM Data Modeler, you will support Data Management and Salesforce CRM teams by monitoring and analyzing source data, critical data, and master relationship data within the organization. Conducts data interrogation and analysis in system databases to design data patterns, create reporting...
Senior Business Analyst
The Senior Business Analyst, Sales Intelligence & Analytics will join the Data, Tools and Reporting Operations Team - a newly built team that is responsible for developing the revenue intelligence infrastructure for Cision globally by enhancing and maintaining our BI platform, building reports and d...
ETL Developer
ETL Developer with Azure experience. ETL Developer experience (preferably Azure, ADF, DataBricks). Senior Developer who can lead a team – Lead Developer. ETL Developer experience (preferably Azure, ADF, DataBricks). ...
Part-time Business Analyst (w/ Association Management Systems)
Business Analyst, including business requirements gathering, documentation and implementation, and development of use cases, test cases, workflow development, data mapping, etc. Business Analyst (w/ Association Management Systems). Business Analyst for a part-time, remote contract. There are numerou...
Senior Java Software Engineer
This Senior Software Engineer will be working with business analysts, team leads and other developers in contributor to the development of scalable, resilient, hybrid cloud-based solutions. Thoroughly analyzes requirements, develops, tests, and documents software quality to ensure proper implementat...
Business Analyst Consultant
Business Analyst (Consultant). Product Ownership / Product Management, Business Consulting, IT Business Analysis, or another related field. Establish and maintain relationships with business and technology stakeholders to drive Product strategy and prioritization decisions for our BlueYonder portfol...