IT Data Engineer-Level 3

Cintas • Mason, OH

2d

About The Position

The IT Data Engineer-Level 3 is responsible for working on data engineering pipelines, data modelling, analytics and supporting complex issues. Specifically, the data engineer will work to identify data acquisition strategies, design, and develop programs to acquire data into Data Lake/Data Warehouse from transactional systems using various tools and other 3rd party adaptors as applicable. The role involves working with the data team to efficiently use Cloud technology platforms to analyze data, build data models, and generate reports/visualizations. The engineer will design the flow for data scientists to build views for ML use cases and for Data Analysts to build reports and dashboards in visualization tools like Looker or Power BI. Additionally, the role includes identifying, designing, and developing database artifacts such as Tables, Calculation Views, and SQL Script Procedures to stage large amounts of input and output data in the Data Lake. Participation in software development life cycle (SDLC) tasks such as status reporting, design reviews and approvals, detailed functional and technical documentation, and migration of artifacts to production is also required.

Requirements

• Bachelor’s degree in Statistics, Mathematics, Data Science, Engineering or related quantitative field
• Minimum of 5 years of data engineering experience.
• Experience designing and supporting enterprise data pipelines and data integration solutions.
• Experience with cloud-based data platforms (GCP, AWS, or Azure).
• Strong SQL and data modeling skills.
• Experience with Spark/PySpark, Dataflow, Dataproc, Data Fusion, Hadoop, Terraform, or similar technologies.
• Experience with CI/CD practices and source control tools.
• Experience integrating data from enterprise systems into analytical platforms.

Nice To Haves

• Experience with GCP.
• Experience with SAP ECC, BW, CRM, EWM, Hybris, HANA, SLT, SDI, SDA, or related ERP technologies.
• Experience supporting analytics, reporting, ML, and AI use cases.
• Experience with Looker or Power BI.

Responsibilities

• Working on data engineering pipelines, data modelling, analytics and supporting complex issues.
• Identify data acquisition strategies, design, and develop programs to acquire data into Data Lake/Data Warehouse from transactional systems using various tools and other 3rd party adaptors as applicable.
• Work with data team to efficiently use Cloud technology platforms to analyze data, build data models and generate reports/visualizations.
• Design the flow for data scientists to build the views for ML use cases and for Data Analysts to build reports and dashboards in visualization tools Looker or Power BI.
• Identify, design and develop database artifacts like Tables, Calculation Views, SQL Script Procedures to stage large amounts of input and output data in Data Lake.
• Participate in software development life cycle (SDLC) tasks like status reporting, design reviews and approvals, detailed functional and technical documentation, migration of artifacts to production.

Benefits

• Comprehensive and competitive medical, dental and vision benefits, with premiums below the national average.
• Flexibility with four different medical plan options; one plan is offered at zero cost.
• Competitive Pay
• 401(k) with Company Match/Profit Sharing/Employee Stock Ownership Plan (ESOP)
• Disability, Life and AD&D Insurance, 100% Company Paid
• Paid Time Off and Holidays
• Skills Development, Training and Career Advancement Opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level