DevOps Engineer - Database and ETL Platforms

AdvancedPCB; Aurora (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

AdvancedPCB is seeking a data engineering professional to design, implement, and maintain robust data infrastructure supporting enterprise applications, analytics, reporting and operations. The role blends DevOps with data technologies, cloud platforms, CI/CD, and data integration.

You will build scalable pipelines, dashboards, and data marts while ensuring SLA-driven operations. The ideal candidate will have a Bachelor's in a science/engineering field plus software/data experience, strong

Qualifications

• Bachelor’s Degree in a field of science or engineering plus three years of experience in software development, data analysis and ET, or equivalent experience.
• Proficiency in Python and Python 3.x.
• Experience with Microsoft SQL, Progress, Oracle, MySQL.
• Containers: Docker, Kubernetes (preferably on Azure).
• Experience with UNIX/Linux (RedHat/CentOS/Oracle).
• Version control using Git/GitHub.
• PowerBI
• SSIS

Responsibilities

• Automate and optimize processes by building infrastructure as code and monitoring pipelines.
• Develop ETL pipelines to extract, transform, and load data into a warehouse or analytical model.
• Configure operational/analytical databases and build data marts.
• Optimize ETL pipelines and integrate data interfaces and APIs.
• Create visualizations using PowerBI and other tools.
• Follow SDLC and maintain high quality software.
• Learn quickly and automate deployment of solutions.
• Continuously evaluate new approaches and tools for improvement.
• Maintain SLAs, SLIs, SLOs and monitor system performance.
• Document work and prepare technical specifications.
• Maintain revision control of developed software.

Skills

Python programming

Data analysis

DevOps practices

Education

Bachelor’s Degree in a field of science or engineering

Tools

PowerBI

Docker

Kubernetes

Git

SSIS

Azure

Unix/Linux

Job description

Scope

This position is responsible for meeting the goals and operational activities related to corporate data aggregation and analysis. This role is responsible for designing, implementing, monitoring, and maintaining robust data infrastructure that supports enterprise applications, analytics, reporting and operational workloads. Solutions will be based around both proprietary and open-source tools, while working collaboratively with the production team, developers, and IT personnel to build, evolve, and scale high performance and maintainable solutions to meet growing business.

The ideal candidate combines DevOps best practices with expertise in database technologies, cloud platforms, CI/CD pipelines, and data integration processes.

This position reports to the Exec. Dir Software Development and Operational tech.

Essential Job Function

• 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

Requirements

• Bachelor’s Degree in a field of science or engineering plus three years of experience in software development, data analysis and ET, or equivalent experience.
• Demonstrated understanding of Computer Science fundamentals and proficiency in one or more programming languages (Primary language is Python)
• Python Development using Python 3.x
• Microsoft SQL (2+ years), Progress, Oracle, MySQL
• Containers; Docker, Kubernetes (preferably on Azure), etc.
• Experience with UNIX/Linux (RedHat/CentOS/Oracle preferred)
• Version control using Git/GitHub
• PowerBI
• SSIS

Physical Requirements

• Sit for long periods of time.
• Repeat the same movements.
• Ability to lift 25 pounds from time to time