Data-Driven DevOps Engineer: ETL, Cloud & CI/CD

Paylocity; Aurora, Northern (CO, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Paylocity is seeking an experienced data engineer to design, implement, and maintain robust data infrastructure supporting enterprise analytics and reporting. You will build ETL pipelines, automate data flows, and create data marts to meet business needs.

The role requires a strong foundation in Python, SQL, and cloud-based data platforms, with hands-on experience in Docker/Kubernetes and PowerBI for data visualization. Collaboration with development and IT teams is essential.

Qualifications

• Bachelor's degree with 3+ years of experience in software development, data analysis and ETL or equivalent.
• Proficiency in CS fundamentals and one or more programming languages (Python preferred).
• Python development using Python 3.x.

Responsibilities

• Evaluates, automates, and optimizes processes, building infrastructure through code and streamlining pipelines, monitoring, and incident response processes, following industry standards and best practices.
• Develop ETL pipelines, and automation to extract source data, transform to map to the target model and/or cleanse the data, and load into a data warehouse or analytical model.
• Configure the operational and analytical database(s) to host data, and develop data marts to meet the business requirements.
• Optimize the ETL data pipelines code and configure data interface tools and APIs as needed.
• Create visualizations via PowerBI and other tools.
• Follows the SDLC process and adheres to company coding standards to produce high quality software.
• Able to learn quickly and automate, integrate, deploy, or release solutions using tools, scripting, or coding as needed.
• Continuously striving for improvement, evaluating new approaches, industry standards, new tooling, etc. and producing recommendations for improvements.
• Maintains established SLAs, SLIs, SLOs, and monitors systems, assessing lead time for changes, change failure rate, deployment frequency, mean time to recover, and availability, striving for continuous operational improvement and improved user satisfaction.
• Proficient at problem management including definition, brainstorming, and determining a resolution through collaboration.
• Establishes and maintains thorough and accurate documentation of all work; communicates technical issues within scope of assignment; Produces and reviews technical specification documentation.
• Maintain revision control of developed software according to company guidelines.

Skills

Python

SQL

PowerBI

Unix/Linux

Git

Docker

Kubernetes

ETL pipelines

Azure

Education

Bachelor’s Degree in Science or Engineering

Tools

Docker

Kubernetes

Git

PowerBI

SSIS

SQL

Job description

Paylocity is seeking an experienced data engineer to design, implement, and maintain robust data infrastructure supporting enterprise analytics and reporting. You will build ETL pipelines, automate data flows, and create data marts to meet business needs.

The role requires a strong foundation in Python, SQL, and cloud-based data platforms, with hands-on experience in Docker/Kubernetes and PowerBI for data visualization. Collaboration with development and IT teams is essential.