Sr. Data Engineer

About the 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.
• Advanced knowledge of Data Architecture
• Excellent ability to document and present information pertaining to engineering workstreams.
• Ability to lead other team members to achieve team goals in an effective and efficient manner
• Ability 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