Description

You will lead data analysis and architecture efforts to establish an enterprise data model that standardizes shared entities and attributes across a multi-platform environment.

Responsibilities

• Design and deliver enterprise data models that meet both business and technical requirements.
• Provide subject matter expertise on Microsoft Dataverse, SQL Server, Azure Data Factory, and SSIS.
• Create and maintain business rules using SQL logic and design data mapping specifications for large reporting platforms.
• Act as a technical data steward to detail data structures across business and technology partners.
• Migrate data from various legacy platforms to Azure-hosted environments.
• Challenge legacy designs to identify opportunities for improved modeling and code.

Required Skills

• 5+ years of experience in data engineering or data analysis roles.
• Proficiency with Azure Data Factory for ETL processes.
• Hands-on experience with Microsoft Dataverse and MS SSIS.
• Strong SQL skills for writing ad-hoc statements and maintaining business logic.
• Deep understanding of database platforms including Oracle, SQL Server, DB2, MySQL, and MS Access.
• Knowledge of data warehousing and data mining techniques.
• Expertise in modeling strategies such as dimensional, snowflake, relational, and unstructured models.
• Experience using ERD/Data Modelling tools like Toad.
• Ability to execute projects within Agile or Hybrid environments.
• Experience with data reporting tools such as Power BI.

Preferred Skills

• Experience conceptualizing and visualizing complex data structures before formal documentation.

Key Skills

Education

Any Graduate