Principal ETL Engineer

DigiCert; South Africa; Remote; USD 152,000 - 215,000; Full time

Job summary

A global security authority is looking for a Principal ETL Engineer to support their data warehouse operations. The role is 100% remote and involves designing ETL pipelines, optimizing SQL queries, and ensuring data quality. Candidates should have a Bachelor's degree in IT or equivalent experience, along with at least 5 years in data analysis or software development. Competitive salary range is $152,000 - $215,000 per year.

Qualifications

• 5 years of experience as Data Analyst or Software Developer.
• Experience in data validation and modeling.
• 3 years of post-secondary studies plus 6 years of experience can substitute.

Responsibilities

• Research and integrate data into data warehouse.
• Analyze and optimize ETL requirements and SQL queries.
• Design and implement ETL pipelines.
• Support data warehouse and troubleshoot processes.

Skills

Building and optimizing SQL queries

Utilizing Linux based systems

Utilizing Relational and Non-Relational data systems

Performing data quality and validation

Data modeling and warehouse design

Working with large scale data structures and pipelines

Utilizing GIT for version control

Using API connections and concepts

Education

Bachelor's degree in relevant IT field

Job description

Who we are

We're a leading, global security authority that's disrupting our own category. Our encryption is trusted by the major ecommerce brands, the world's largest companies, the major cloud providers, entire country financial systems, entire internets of things and even down to the little things like surgically embedded pacemakers. We help companies put trust - an abstract idea - to work. That's digital trust for the real world.

Principal ETL Engineer (DigiCert, Inc., Lehi, UT)

Research data sources and compile SQL to integrate data into data warehouse. Review ETL requirements and build data deliverables per business unit requirements. Analyze existing SOL queries for performance improvements working alongside Bl Analysts and developers. Perform data validation, and data modeling to maintain optimal data warehouse. Design and implement ETL pipelines to support and enhance the data warehouse. Convert business requirements to technical specifications and implement them. Identify and resolve performance bottlenecks and work with back-end pipeline developers on implementation. Work with stakeholders to continually improve ETL process and pre-emptively identify potential concerns. Build processes supporting data transformation, metadata, dependency and workload management. Write, execute, and validate DML, DDL, and DCL scripts to meet business and customer needs. Modify ETL feeds to accommodate ever changing business processes. Provide day-to-day support of the data warehouse and troubleshoot existing processes and operations. Share team responsibilities for all aspects involved with maintaining a high level of uptime. Communicate with stakeholders and effectively work on projects while keeping them in the loop on progress. Travel required 12% of the time to company headquarters. Position is 100% remote and reports to HQ in Lehi, UT. Salary: $152,000 - $215,000 per year.

MINIMUM REQUIREMENTS: Bachelor’s degree or U.S. equivalent in Information Technology, Computer Science, Computer Engineering, Computer Information Systems, or related field, plus 5 years of professional experience as a Data Analyst, Software Developer, or any occupation/position/job title involving performing data validation and data modeling to integrate data into data warehouses.

In lieu of aBachelor’s degree plus 5 years of experience, the employer will accept 3 years of post-secondary studies in Information Technology, Computer Science, Computer Engineering, Computer Information Systems, or related field, plus 6 years of professional experience as a Data Analyst, Software Developer, or any occupation/position/job title involving performing data validation and data modeling to integrate data into data warehouses.

Must also have the following special skills: 5 years of professional experience building and optimizing SQL queries and data deliverables per stakeholder requirements; 5 years of professional experience utilizing Linux based systems; 5 years of professional experience utilizing Relational and Non-Relational data systems; 5 years of professional experience performing data quality, quality assurance (QA) and data validation; 5 years of professional experience performing data modeling and data warehouse design; 5 years of professional experience working with large scale data structures and pipelines; 5 years of professional experience utilizing GIT for version control; and 5 years of professional experience utilizing API connections and concepts.

CONTACT: Submit resume online at https://www.digicert.com/careers or via email to [e-mail]. Must specify job code SSDA