Posted on
Description of role:
Works with the EDM Data Engineering team to develop, troubleshoot, and implement a centralized data warehouse solution by developing and testing data pipelines and data repositories.
Business Skills:
• Effective oral and written communication skills; able to build good working relationships with technical team as well as business stakeholders.
• Ability to work independently and as part of a team.
• Advanced knowledge of Data Warehousing and Business Intelligence concepts, solutions, and best practices.
• The ability to develop EDM solutions from technical requirements.
Technical Skills required:
• Intermediate/Advanced Microsoft Office Suite of Tools
• Must demonstrate hands-on Microsoft Azure experience working with the following Microsoft Azure data technologies: Azure Data Lake, Data Factory, and Synapse.
• Experience with, and ability to recommend Azure monitoring solution using Azure Monitor, Azure Log Analytics, and custom monitoring scripts.
• Intermediate working knowledge of Azure Logic Apps, scripting languages like ARM, Bicep DSL, Python, PowerShell or other custom solutions. Experience using one or more of the previous technologies to perform Azure DevOps releases.
• Advanced experience working with relational and non-relational databases, dimensional models, advanced SQL queries, stored procedures and functions, data warehouses, ETL processes, and database management systems.
• Advanced experience with SQL Server development technologies like Integration Services (SSIS), Visual Studio, .Net language, Management Studio (SSMS).
• Good data analysis skills including data cleansing and preparation, data exploration and user story maps.
Experience:
• Minimum 3 years of data warehouse development experience
• Minimum 2 years working in MS Azure environments and SQL databases
Works with the EDM Data Engineering team to develop, troubleshoot, and implement a centralized data warehouse solution by developing and testing data pipelines and data repositories.
Business Skills:
• Effective oral and written communication skills; able to build good working relationships with technical team as well as business stakeholders.
• Ability to work independently and as part of a team.
• Advanced knowledge of Data Warehousing and Business Intelligence concepts, solutions, and best practices.
• The ability to develop EDM solutions from technical requirements.
Technical Skills required:
• Intermediate/Advanced Microsoft Office Suite of Tools
• Must demonstrate hands-on Microsoft Azure experience working with the following Microsoft Azure data technologies: Azure Data Lake, Data Factory, and Synapse.
• Experience with, and ability to recommend Azure monitoring solution using Azure Monitor, Azure Log Analytics, and custom monitoring scripts.
• Intermediate working knowledge of Azure Logic Apps, scripting languages like ARM, Bicep DSL, Python, PowerShell or other custom solutions. Experience using one or more of the previous technologies to perform Azure DevOps releases.
• Advanced experience working with relational and non-relational databases, dimensional models, advanced SQL queries, stored procedures and functions, data warehouses, ETL processes, and database management systems.
• Advanced experience with SQL Server development technologies like Integration Services (SSIS), Visual Studio, .Net language, Management Studio (SSMS).
• Good data analysis skills including data cleansing and preparation, data exploration and user story maps.
Experience:
• Minimum 3 years of data warehouse development experience
• Minimum 2 years working in MS Azure environments and SQL databases