Data Architect

International Dairy Queen, Inc.•Bloomington, MN

3h•$115,037 - $143,796•Hybrid

About The Position

We have an exciting opportunity available for a Data Architect working out of our corporate offices in Bloomington, MN. The Data Architect focuses on the development and support of the Analytics & Reporting Enterprise Data Warehouse (EDW) and PowerBI reporting environments at Dairy Queen. This position works on projects providing assistance and expertise to the business and IT representatives on how best to organize and provide information to meet the measurement and analytics needs of the organization. The incumbent provides support in the development, analysis, design, and management of a variety of complex data sources and visualization methods to support clinical and operational process improvement. Additionally, the data architect will guide a team of data engineers to ensure consistent, reliable, and sustainable data solutions are delivered. The data architect will work with a team to influence data management processes that result in highly accurate and trusted data assets for use across the organization. Finally, the data architect influences stakeholders to ensure investments in data-driven solutions are centered on optimizing clearly defined and quantified business outcomes. 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.

Requirements

B.S. or M.S. in computer science, computer engineering, or a related technical field or equivalent experience in lieu of degree
5+ years of experience in architecting data-driven solutions
Minimum 5 years of experience in cloud-based ETL architecture/development, implementation, and support
Minimum 5 years of experience with Python, Bash, and other scripting languages
2+ years of experience architecting cloud-native data solutions on Microsoft Azure, ADF, AWS, Fabric, or Google Cloud platform. Familiarity with large-scale analytics systems (Microsoft Stack preferred)
Excellent analytical and problem-solving skills
Strong written and oral communication skills

Responsibilities

Design, architect, and document the database schema and data pipelines
Capable of using agile methodology and implementing Continuous Integration/Continuous Delivery (CI/CD) pipelines
Perform key thought leadership in areas of data engineering: modeling, integration, big data and cloud solution design, data warehousing, and data discovery
Designs and develops appropriate Extraction, Transformation, and Loading (ETL) applications. Deploy and maintain system and database monitoring tools
Perform other related duties as assigned
Partner with the BI team to define and establish architectures to support centralized metadata, reference data, business rules, and data sourcing and sharing controls
Define service commitment standards for cloud data warehousing via the publication and ownership of service-level objectives
Maintain knowledge of emerging technology
Define and meet SLA requirements for analytics components
Embrace agile methodology for iterative development
Ability to function as a technical lead, including hands-on implementation, as well as working closely with developers and data analysts
Communicate effectively, verbally and in writing with people at all organizational levels
Lead in a team environment, making positive contributions to the organization
Establish and maintain effective relationships with staff members, customers, and vendors
Other duties as assigned or required
Contribute to the creation of processes for improving data quality across the enterprise
Provide leadership for developing and operating a data governance framework.