Plan and execute multiple, simultaneous, large or long duration projects
Elicit data related business requirements from stakeholders and develop or approve associated technical specifications
Design, implement, and maintain ETL processes to facilitate warehousing and systems integration needs
Develop and enhance data models to deliver value to the organization
Maintain, monitor, optimize, and troubleshoot/resolve issues with existing processes
Contribute to the development of standard methods and best practices for the transformation and preparation of data
Participate in discipline related internal and external project communication and coordination
Implement data quality checks and validation processes
Research and adopt new technologies and methodologies
Mentor junior data engineers and contribute to their professional growth

Requirements

Bachelor’s Degree or equivalent experience
7+ years of experience working with Microsoft SQL databases and warehousing tools
7+ years of experience developing ETL processes using Microsoft technologies
7+ years’ experience developing Microsoft Analysis Services Tabular, Power BI, or Fabric semantic data models
Experience leveraging medallion architecture design patterns
Proficiency using Azure Gen2 Storage, Synapse, Fabric, Spark Notebooks, REST API’s, Databricks and related technologies
Expert proficiency in Data Warehousing methodologies and concepts
Expert proficiency authoring SQL queries, tables, views, stored procedures, and functions
Experience using software development management tools
Experience using Python and PowerShell required
Experience with provisioning data related resources and components in Azure preferred
Experience with Redgate Monitoring or Azure Log Analytics is a plus
Familiarity with D365 ERP modules preferred
Extreme attention to detail and accuracy a must
Excellent verbal/written communication skills required
Microsoft DP-700 Certification is a plus.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL processesdata modelingSQLMicrosoft SQL databasesMicrosoft Analysis Services TabularPower BIAzure Gen2 StorageSynapsePythonPowerShell

Soft Skills

attention to detailverbal communicationwritten communicationmentoringstakeholder engagement

Certifications

Microsoft DP-700 Certification