IT Data Engineering Lead

Cintas • Mason, OH

25d

About The Position

The IT Data Engineer Lead is responsible for working and guiding on data engineering pipelines, data modelling, analytics and leading complex issues. Specifically, the data engineer lead will work to design and implement data acquisition strategies to ingest data from SAP ERP Systems (ECC, CRM, EWM, EM BW, Hybris) into Data Lake/Data Warehouse using various tools like HANA SDI & SDA Adaptors, SLT, file, OData and other 3rd party adaptors as applicable. The lead will guide the data team to efficiently use Google Cloud platform to analyze data, build data models and generate reports/visualizations. They 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 Looker or Power BI. The role involves identifying, designing, and developing database artifacts like Tables, Calculation Views, SQL Script Procedures to stage large amounts of input and output data in Data Lake. Additionally, the lead will participate 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.

Requirements

• Bachelor’s degree in Statistics, Mathematics, Data Science, Engineering or related quantitative field
• Minimum 8 years of experience in Information Technology, including experience with SQL, Python, Big Query, Cloud Composer, Cloud Pub/Sub
• Minimum 8 years of experience in building and operationalizing large-scale enterprise data solutions and applications, with the ability to build production data pipelines from data ingestion to consumption within a hybrid big data architecture
• Minimum 6 years of experience in Reporting, Data Analytics and building data pipelines.
• Minimum 5 years of experience working with CI/CD pipelines using Code repositories like Gitlab, GitHub, etc. and deployment tools like Cloud Build or Gitlab Runners
• Minimum 4 years of combined experience in PySpark, Cloud Dataproc, Cloud Dataflow, Terraform, Hadoop, Hive, Apache Spark, Cloud Spanner, Cloud SQL and Data Fusion
• Experience in any cloud platforms such as GCP, Azure, AWS, with preference to GCP
• Advanced understanding of technical environment, including technical area development and architecture of SAP

Nice To Haves

• Master’s degree in Statistics, Mathematics, Data Science, Engineering or related quantitative field with 6 years of experience in Information Technology, including exposure to: SQL, Python, Big Query, Cloud Composer, Cloud Pub/Sub
• Building and operationalizing large-scale enterprise data solutions and applications, with the ability to build production data pipelines from data ingestion to consumption within a hybrid big data architecture
• Reporting and data analytics, such as building and operationalizing large scale enterprise data solutions and applications, building production data pipelines from data ingestion to consumption within a hybrid big data architecture
• Experience in medallion architecture with Google Cortex framework
• Experience with containerization technologies like Docker or Kubernetes

Responsibilities

• Design and implement data acquisition strategies to ingest data from SAP ERP Systems (ECC, CRM, EWM, EM BW, Hybris) into Data Lake/Data Warehouse using various tools like HANA SDI & SDA Adaptors, SLT, file, OData and other 3rd party adaptors as applicable.
• Guide the data team to efficiently use Google Cloud platform to analyze data, build data models and generate reports/visualizations.
• 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 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: Senior