Data Engineer - Azure

$166,400 - $180,000/Yr

Denali AI - Redmond, WA

Full-time - Mid Level

Redmond, WA

About the position

The Data Engineer role is focused on optimizing and developing high-performance data warehouse solutions using Microsoft technologies. This position involves working closely with an agile development team to analyze ETL processes, design data infrastructure, and implement scalable data engineering solutions. The Data Engineer will be responsible for requirements gathering, data analysis, and the full development life cycle management, ensuring efficient data movement and quality assurance.

Responsibilities

• Design, implement, test, and deploy data processing infrastructure on premise and in cloud
• Contribute to architecture of highly scalable and reliable data engineering solutions for moving large data efficiently across systems
• Perform work in an Agile team setting
• Break down, estimate, and provide just-in-time design for small increments of work
• Work in a Microsoft Azure data infrastructure environment
• Develop in-depth data pipeline using industry-standard data integration tools
• Full development life cycle management, including gathering, analysis, architecture, design, implementation, testing, deployment, and technical support
• Write test cases and test scripts for data quality assurance
• Responsible for creating stored procedures and functions
• Develop dimensional data model with the industry-standard tool
• Interpret reporting requirements into actionable development tasks
• Analyze and optimize SQL based stored procedures and jobs
• Analyze table indices for performance
• Design and implement Materialized Views and Views
• Develop high-performance programs and procedures for ETL Processes
• Analyze, categorize and document data sources and elements
• Write and optimize queries and provide guidance to other developers accessing data

Requirements

• Bachelors Degree
• 5 + years of Data Engineering Experience or equivalent experience
• Five + (5) years building out highly scalable, scaled-out architectures on large scale database platforms
• Five + (5) years of experience in a senior data engineering role
• Three + (3) years of Microsoft Azure data services experience
• Excellent SQL Skills
• Deep knowledge of systems such as Microsoft SQL Server, Azure Fabric, and Azure data lake, data warehouse, and Power Platform
• Experience with other programming languages such as C# are a plus
• Strong understanding of different data access standards including REST and SOAP data sources
• Advanced competency in SQL with the ability to optimize and mentor others to perform query optimization in large scale database environments
• Experience with any industry-standard tool for Source Control and Project Management
• Experience with data visualization and/or dashboard development
• Strong written and oral communication skills
• Demonstrates critical thinking, analytical and problem-solving skills, and ability to think creatively
• Exhibits a sense of ownership, urgency, accountability, and drive to learn new technologies
• Demonstrated ability to achieve stretch goals in a highly innovative and fast-paced environment

Nice-to-haves

• Familiarity with AGILE and API development
• Familiarity with test-driven development methodology for analytic solutions

Benefits

• Salary Range: $166,400.00 To $180,000.00 Annually