Data Operations Engineer

Job Description

Summary/objective The Data Operations (Data Ops) 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, Dev Ops, 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 Lake houses)
• Familiarity with ETL/ELT methodologies and tools (e.g., Azure Data Factory and Altova Map Force/Flow Force).
• 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 Power Query.
• Working knowledge of Microsoft’s Dataverse and Power Platform.