Data Engineer

Company Description

Since 1940, Dairy Queen has been one of the world's best known and loved brands. Based in Minneapolis, MN, International Dairy Queen Inc., (IDQ), is the parent company of American Dairy Queen Corporation. As a leading franchisor, there are more than 7,000 independently owned and operated restaurants in the U.S., Canada and more than 20 countries around the world. IDQ is a subsidiary of Berkshire Hathaway Inc. (Berkshire) which is led by Warren Buffett, the legendary investor and CEO of Berkshire.

Here at IDQ, we create extraordinary Fan experiences every day and we do this through our commitment to hiring and retaining only the best in class talent. We firmly believe that our employees are the catalyst to the success of the company where their initiative, strategic thinking, and entrepreneurial spirit are recognized and rewarded. We're looking for motivated, passionate and dedicated individuals with an inherent need and ambition to go after bigger challenges.

Job Description

We have an exciting opportunity available for a Data Engineer located at the corporate office in Bloomington, MN. The 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 Data Analytics 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.

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

• Maintain central repository/code base for production code (e.g. GitHub)

Qualifications

• B.S. or M.S. in computer science, computer engineering, or a related technical field

• 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

• Minimum of 5 years experience working with Microsoft BI Tools including Azure Data Lake, Azure Data Lake Analytics, Azure SQL Database, 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

All your information will be kept confidential according to EEO guidelines. You must be work authorized in the United States without the need for employer sponsorship.

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 2 collaboration days a week. Additional in office time may be required to support team/project needs. Positions will be identified as "remote eligible" when consideration will be given to candidates outside of drivable distance to our Bloomington office.

Our Commitment to Diversity, Equity and Inclusion

We are committed to creating a culture of diversity, equity and inclusion for all who touch DQ. We believe in and commit to fostering a community where employees bring their authentic selves to work; where we recruit, engage and retain employees, franchise owners and suppliers with diverse background and identities; and where everyone feels welcome engaging with our DQ brand.

IDQ is an Equal Opportunity Employer that values the strength diversity brings to the workplace. IDQ participates in the US E-Verify program. You must be work authorized in the United States without the need for employer sponsorship.