Sr. HRIS Data Engineer

Company Description

Domino’s Pizza, which began in 1960 as a single store location in Ypsilanti, MI, has had a lot to celebrate lately: we’re a reshaped, reenergized brand of honesty, transparency and accountability – not to mention, great food! In the rise to becoming a true technology leader, the brand is now consistently one of the top five companies in online transactions and 65% of our sales in the U.S. are taken through digital channels. The brand continues to ‘deliver the dream’ to local business owners, 90% of which started as delivery drivers and pizza makers in our stores. That’s just the tip of the iceberg…or as we might say, one “slice” of the pie! If this sounds like a brand you’d like to be a part of, consider joining our team!

Job Description

Senior HRIS Data Engineer 
 

Location: Domino’s World Resource Center; 30 Frank Lloyd Wright Dr, Ann Arbor, MI 48105 (Monday-Thursday onsite with Friday being remote/flex). Candidates should be local to the Ann Arbor area or willing to relocate. 

The Domino’s Pizza HR Tech Team in Ann Arbor, MI is seeking a Sr. HRIS Data Engineer that has experience supporting multiple HR functions of a business.

RESPONSIBILITIES AND DUTIES 

Data Engineering & Database Engineering

• Data Pipelines:  Design, develop, and maintain scalable data pipelines from various internal and external data sources to support data processing and analytics needs within the reporting platform, utilizing tools and processes such as ELTs, SSIS, Power BI Workloads, Power Query M.  Develop and execute data transformation workflows to convert raw data into meaningful and actionable formats, as well as to enhance data usability.  Monitor and troubleshoot data pipeline issues to maintain system reliability.  
• Reporting Database:  Design, develop, and maintain the database architecture for the reporting database within the reporting platform.  Implement data models and schemas to support efficient data retrieval and reporting. Create dynamic and efficient database objects using advanced SQL techniques and functions.  Maintain code versioning using tools such as BitBucket or Visual Studio Code.  Optimize database performance and ensure data integrity and security.
• Data Maintenance: Implement and maintain robust data cleansing processes to ensure data quality and accuracy. Identify and rectify data inconsistencies, duplicates, and errors. Create systematic alerts and monitoring to detect and remedy data issues.  Work with cross functional teams to correct data at the source when necessary and help create and foster long term data improvement initiatives. Ensure the accuracy and integrity of data in reporting systems by conducting regular quality assurance checks, identifying data discrepancies, and implementing solutions.
• Other:  Serve as the subject matter expert in PeopleSoft HCM data and develop to become the subject matter expert in all data interfaced with PeopleSoft.  Lead in the development and maintenance of standardization and quality control efforts. Stay up to date with emerging trends and technologies in data and database engineering, cloud computing, and big data.

BI Reporting and Analytics

•  Tell stories leveraging data, tools, and insights to fuel functional effectiveness and improve efficiencies.
• Develop prescriptive insight tools to support internal stakeholders (HR functional areas, Operations, Supply Chain, Finance, etc.) enabling them to make better, faster, data-driven decisions.
• Root out business questions, translate to available data streams, and develop tools that will answer and provide insight to those questions. Develop, visualize and evangelize important metrics and analytics.
• Collaborate with stakeholders to understand business requirements and translate them into data models, reports, and dashboards.
• Collect business requirements using a variety of methods such as data mining and analysis, interviews, meetings, workshops, and workflow analysis to develop the requirements in terms of target user roles and goals.
• Design, develop, and maintain reports, dashboards, and apps in business intelligence and analytics tools, such as Power BI.
•  Migrate legacy reporting, including PS Queries, to Power BI and evaluate new data requests to determine best reporting solution on a case-by-case basis.
• Optimize Power BI dashboards and reports for performance and user experience.
• Troubleshoot data and reporting issues and implement solutions.
• Ensure reports adhere to reporting standards and documentation requirements.
• Ensure the accuracy, integrity, and security of reports by applying critical reporting alerts and conducting regular quality assurance checks.
• Create report user documentation and train end-users on Power BI features and best practices.
• Stay up to date with new Power BI features and functionalities and evaluate their impact on our BI solutions.
   

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, or equivalent combination of relevant education, training and experience
•  Strong advanced SQL required, minimum 5 yrs experience, Microsoft SQL Server preferred
•  Experience with complex relational databases, multidimensional data models and schemas
•  Knowledge in cloud data and data lakehouses a plus, Azure and Databricks preferred
•  Experienced in all steps of data wrangling, preferably using SQL 
• Proficient in data engineering for performance and agility. 
•  Experience with version control tools (ex: Visual Studio, BitBucket, GitHub etc.)
• Familiarity with scripting languages (python, R, shell scripting) for automation a plus
• Experience with data integration and reporting tools, such as SSIS, SSRS, SSMS
• Experience with Power Query M and DAX 
• HCM data expertise, PeopleSoft preferred
•  Proficient with at least one data visualization platform for Business Intelligence, minimum 3 yrs experience, Microsoft Power BI preferred
• Experience developing metrics, KPI analysis, and other advanced analytics required.  Familiarity with applied statistics and predictive analytics a plus
• Experience with a 3rd party analytics platform, including data integration, cleansing and transformation, preferably Visier
• Advanced Microsoft Excel skills
•  Excellent written and oral communication skills
   

Additional Information

Benefits:
•    Paid Holidays and Vacation   
•    Medical, Dental & Vision benefits that start on the first day of employment
•    No-cost mental health support for employee and dependents
•    Childcare tuition discounts
•    No-cost fitness, nutrition, and wellness programs 
•    Fertility benefits
•    Adoption assistance
•    401k matching contributions   
•    15% off the purchase price of stock   
•    Company bonus