Job Information
Alliance Franchise Brands Data Operations Engineer in Plymouth, Michigan
Summary/objective
The Data Operations (DataOps) Engineer plays a crucial role in designing, building, and maintaining data pipelines, storage and delivery systems to support various data-driven initiatives across our franchise network. They must also be able to contribute to accurate and timely reports and visualizations. This role is part of a dynamic team of information and technology professionals working closely with stakeholders to understand business requirements and translate them into scalable data solutions.
Essential functions
Ensure Data Integrity and Security: Clean and organize data to ensure accuracy and reliability and manage data access permissions to maintain security and compliance.
Transform and Visualize Data: Transform operational data into insightful reporting and analytics data and create compelling visualizations.
Advocate Data Best Practices: Collaborate with various departments to discover and optimize data collection methods, ensure data quality, and support a data-driven culture within AFB.
Proactive Data Correction: Identify and work with others to rectify inaccuracies in data to maintain high data quality.
Develop Compliant Data Sets: Work with teams to develop data sets that comply with internal and external standards.
Assist with Data Projects: Collaborate across business domains to assist with various data projects.
Monitor Data Pipelines: Oversee data pipelines and automations to ensure smooth and efficient operations.
Create Usable Documentation: Diagram and document schema, model, lifecycle, and lineage of various data elements.
Competencies
Excellent multitasking abilities.
Strong collaboration and teamwork skills.
High level of self-driven motivation and accountability.
Creativity in problem-solving and data visualization.
Ability to communicate effectively with both technical and non-technical stakeholders.
Work environment
Professional corporate and team-oriented environment
Hybrid work schedule with at least 2 days each week in office
Physical demands
Prolonged periods sitting at a desk and working on a computer.
Must be able to lift up to 15 pounds at times.
Travel requirements
Minimal travel if any
Required education and experience
Degree in Computer Science, Data Science, Information Systems, or a related field plus 2+ years of experience in Data Engineering, Data Science, DevOps, or a related role, or 5+ years of equivalent work experience.
Proficiency in MS SQL Server (e.g., Indexes, Stored Procedures, and Complex Views).
Skilled at programming in Python, Scala, TSQL, and/or R.
Experience with data storage and management solutions (e.g.: Data Warehouses, Data Lakes, and Data Lakehouses)
Familiarity with ETL/ELT methodologies and tools (e.g., Azure Data Factory and Altova MapForce/FlowForce).
Knowledge of dimensional data modeling principles and techniques.
Understanding of efficient schema design, compatibility and evolution practices
Expertise in Power BI for data visualization.
Ability to deliver data into descriptive, diagnostic, predictive, and prescriptive analytics.
Preferred education and experience
Bachelor's degree preferred.
Preferred experience in franchising or retail environments.
Experience with DAX and PowerQuery.
Working knowledge of Microsoft’s Dataverse and Power Platform.
Powered by JazzHR