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 [email protected]. Must specify job code SSDA
