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. Value of Joining our Team + We offer flexible health and insurance options including medical, dental and vision, employee, spouse, and child life insurance, short-and long-term disability, Healthcare FSA and Dependent care FSA, critical illness, and accident insurance. We also offer an Employee Assistance Program to support the well-being of you and your family. + We provide paid holidays and paid time away to spend with your family and friends. + Plan for the near and long-term with our 401K retirements savings plan with matching company contributions. + Bonus eligibility About Us Alliance Franchise Brands LLC and its subsidiary, KK Printing Canada ULC, are the franchisors of more than 600 locations in North America operating the company’s brands: Allegra Marketing Print Mail, Image360, Signs Now, Signs by Tomorrow, KKP, Insty-Prints, American Speedy Printing Centers, and RSVP. Alliance Franchise Brands is proud that three of our brands were selected for the 2022 Entrepreneur 500 list. Independently owned and operated franchises provide national, regional, and local businesses and organizations with a one-stop resource for technologically advanced and strategically sound solutions for their graphics communications needs. In total, Alliance Franchise Brands serves more than 600 franchise members in the U.S., Canada, and England with system-wide sales of more than $380 million.  Powered by JazzHR