Senior Data Engineer

We have an exciting opportunity available for a Senior Data Engineer located out of our corporate office in Bloomington MN.  The Sr. Data Engineer works with a team of skilled Analysts on the development and support of the Analytics & Reporting Enterprise Data Warehouse (EDW) and PowerBI reporting environments at Dairy Queen. This position will work closely with our Analytics & Insights team to design build and maintain the computational infrastructure to support the business intelligence platform.

This position plans designs and optimizes for data throughput and query performance issues. This requires constantly updating expertise in areas such as platform network and storage technologies bandwidth management data bus implications and design.

Additionally this position plays a key role in the configuration and utilization of backend database technology. Drive optimization of the full data pipeline and infrastructure to support the actual content volume ETL to support the intended kinds of queries and analysis to match expected responsiveness.

The Sr. Data Engineer also includes limited leadership responsibilities including mentoring junior engineering roles and actively participating in project management for the team.  This position requires expertise in Python scripting language and experience in API integration.

Principal Accountabilities

• Design architect and document the database schema and data pipelines
• Design implement and test data collection storage and mapping procedures
• Research design and test computational environments to support analytical modeling (statistics machine learning optimization and simulation)
• Develop statistical models for data quality assurance and data imputation
• Collaboratively troubleshoot technical and performance issues within the data platform
• Write optimize and automate data processing tasks
• Deploy and maintain system and database monitoring tools
• Handle advanced topics like data governance security and compliance
• Define best practices and standards for data engineering
• Mentor junior engineers and review code
• Lead projects or act as a technical lead within the team
• Collaborate closely with architects and product owners to align data strategy

The US national base salary range for this position is $128841 - $161052. This position is also eligible for a bonus. The base salary range displayed reflects the targeted hiring range for positions across all US locations. Individual pay is determined by job-related skills work location and relevant education or experience.

Qualifications :

• B.S. or M.S. in computer science computer engineering or a related technical field or equivalent relevant experience in lieu of degree
• Minimum 7 years of experience in cloud-based ETL architecture/development implementation and support
• Advanced SQL development skills and an in-depth understanding of database technologies
• Strong Python and SQL; Spark (DataFrames/Delta); API integration; version control (Git)
• Practical expertise with Power BI (dataset modeling DAX performance tuning)
• ETL Design automation and cloud ETL as well as monitoring and alerting.
• Minimum of 7 years experience working with Microsoft BI Tools including Azure Data Lake Azure Data Lake Analytics Azure SQL Database Azure Data Bricks and Azure SQL Data warehouse and Azure Data Factory
• Experience with API integration
• Experience with Azure cloud infrastructure and distributed computing
• Familiarity with large-scale analytics systems
• Excellent analytical and problem-solving skills
• Strong written and oral communication skills

Additional Information :

Benefits

Our benefit package supports the well-being of our employees and their families.  Our comprehensive benefit package includes medical dental 401K match paid time off (including volunteer time as well as parental leave) and so much more!  To learn more about our great benefit offerings Click Here.

Work Environment

Most positions located out of our global headquarters in Bloomington MN will work a hybrid work schedule where you will work 3 collaboration days a week.  Additional in office time may be required to support team/project needs.  

Inclusion & Belonging

We are committed to creating a culture of inclusion and belonging for all who touch DQ. We believe in and commit to fostering a community where employees bring their authentic selves to work and where we recruit engage and retain employees franchise owners and suppliers based on qualifications and merit. We strive to maintain an environment where everyone feels welcome.

IDQ is an Equal Opportunity Employer and we use E-Verify to confirm the identity and employment eligibility of all new team members. You must be authorized to work in the United States without the need for employer sponsorship.

Remote Work :

No

Employment Type :

Full-time