Description of role:Partners with the EDM Data Engineering team to develop, troubleshoot, and implement a centralized data warehouse solution including data pipelines and database development. Leads other engineers and individual work steams where needed.
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.
• dvanced knowledge of Data Architecture
• Excellent ability to document and present information pertaining to engineering workstreams.
• bility to lead other team members to achieve team goals in an effective and efficient manner
• bility to review and evaluate acceptable work products of other data engineers
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.
- Advanced experience with Azure data environment, tools, products as noted for a Data Engineer.
• Exceptional data analysis skills.
Experience:• Minimum 7-10 years of data warehouse development experience
• Minimum 3-5 years working in MS Azure environments and SQL databases
• Minimum 5 years of leading teams to develop and implement data warehousing and analytics solutions
