Devops Engineer - Database and ETL Job at AdvancedPCB, Aurora, CO

  • AdvancedPCB
  • Aurora, CO

Job Description

Job Description

Job Description

AdvancedPCB

Aurora, CO 80011

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

Essential Qualifications, Education and Experience :

· 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

\nCompany Description

About AdvancedPCB
AdvancedPCB, with over 40 years of experience, is a leading manufacturer of high-reliability printed circuit boards. The company features six manufacturing sites: Aurora, Colorado, our headquarters, Santa Clara, two in Southern California, Maple Grove, Minnesota, and Chandler Arizona. Currently, the company is viewed as over $100 Million; 180,000 sq. ft. of manufacturing space with over 480 employees, making APCT one of the largest privately held printed circuit board manufacturers in North America. Advanced PCB offers Medical, Dental, Vision Insurance as well as 401K.

ITAR Compliance Requirement:
This position requires access to controlled technical data and/or participation in activities subject to the International Traffic in Arms Regulations (ITAR). As such, all applicants must be U.S. persons, as defined by ITAR (U.S. citizens, U.S. lawful permanent residents, or individuals with refugee/asylee status). Candidates who do not meet ITAR eligibility requirements will not be eligible for employment in this position.

AdvancedPCB is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, status as a protected veteran, marital status, genetic information, medical condition, or any other characteristic protected by law (EEOC).

Visit us!
-us/

Company Description

About AdvancedPCB\nAdvancedPCB, with over 40 years of experience, is a leading manufacturer of high-reliability printed circuit boards. The company features six manufacturing sites: Aurora, Colorado, our headquarters, Santa Clara, two in Southern California, Maple Grove, Minnesota, and Chandler Arizona. Currently, the company is viewed as over $100 Million; 180,000 sq. ft. of manufacturing space with over 480 employees, making APCT one of the largest privately held printed circuit board manufacturers in North America. Advanced PCB offers Medical, Dental, Vision Insurance as well as 401K.\n\nITAR Compliance Requirement:\nThis position requires access to controlled technical data and/or participation in activities subject to the International Traffic in Arms Regulations (ITAR). As such, all applicants must be U.S. persons, as defined by ITAR (U.S. citizens, U.S. lawful permanent residents, or individuals with refugee/asylee status). Candidates who do not meet ITAR eligibility requirements will not be eligible for employment in this position.\n\nAdvancedPCB is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, status as a protected veteran, marital status, genetic information, medical condition, or any other characteristic protected by law (EEOC).\n\nVisit us!\n

Job Tags

Permanent employment, Full time

Similar Jobs

Golden Bank, N.A.

Senior Loan Closer Job at Golden Bank, N.A.

Senior Loan Closer Job Description JOB SUMMARY : The Senior Loan Closer is primarily responsible for coordinating, assigning, reviewing and verifying loan documentation and closing needs for diverse and complex consumer, commercial and industrial loans, including...

Oglethorpe Power Corporation

Combustion Turbine Technician Job at Oglethorpe Power Corporation

 ...maintenance of simple-cycle combustion turbine technologies and generating assets in a...  ...environmental, and NERC electrical reliability. Technician must understand and apply concepts to...  ...and coordination of contract support services as required. This project/contract management... 

AMR

Emergency Response Paramedic Job at AMR

Job Description: Paramedic IMMEDIATELY HIRING! Paramedic FULL-TIME Opportunity $5,000 Sign-On Bonus for full-time Were hiring Paramedics that are passionate about delivering compassionate, high-quality service and advanced patient care to our... 

Fiserv

Cobol Developer Job at Fiserv

 ...involved. If you want to make an impact on a global scale, come make a difference at Fiserv.Job TitleCobol DeveloperWhat does a successful Cobol Developer at Fiserv do? Analyzes technical and business procedures and assists in the development of detailed specifications from... 

Prime Time Healthcare

Travel Clinical Lab Scientist (CLS) - $1,367 to $1,528 per week in Sterling, CO Job at Prime Time Healthcare

Clinical Lab Scientist Location: Sterling, CO Agency: Prime Time Healthcare Pay: $1,367 to $1,528 per week Shift Information: Rotating - 5 days x 8 hours Contract Duration: 13 Weeks Start Date: ASAP About the Role: Prime Time Healthcare...