If you are a self-motivated, team player with a passion for data and a desire to continuously improve and optimize ETL processes, we encourage you to apply for this exciting opportunity
Job Title: Senior ETL Engineer
Location: San Francisco, California, United States
Salary: $190000 - $240000
Position Overview: We are seeking a highly experienced and skilled Senior ETL Engineer to join our dynamic team. As a Senior ETL Engineer, you will play a critical role in designing, developing, and maintaining our Extract, Transform, and Load (ETL) processes. You will be responsible for ensuring the smooth and efficient transfer of data between different systems and databases, enabling our organization to make data-driven decisions.
Key Responsibilities:
- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse.
- Collaborate with cross-functional teams to understand data requirements and develop ETL solutions that meet business needs.
- Develop and maintain data mappings, data quality rules, and data transformation logic.
- Identify and resolve data quality issues, ensuring data integrity and accuracy.
- Monitor and troubleshoot ETL processes, proactively identifying and resolving any issues that may arise.
- Optimize ETL performance by tuning SQL queries, data loads, and transformations.
- Develop and maintain ETL documentation, including technical specifications, process flow diagrams, and data mappings.
- Implement and maintain ETL best practices, standards, and guidelines.
- Mentor and provide guidance to junior ETL engineers, ensuring high-quality deliverables.
- Keep up-to-date with industry trends and advancements in ETL technologies and techniques, and make recommendations for their implementation within the organization.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Minimum of 5 years of experience in ETL development, with a focus on data warehousing and business intelligence.
- Strong proficiency in SQL and experience with one or more ETL tools such as Informatica, Talend, or DataStage.
- Experience with relational databases such as Oracle, SQL Server, or MySQL.
- Knowledge of data warehousing concepts and methodologies.
- Experience with data modeling and data architecture.
- Excellent problem-solving and analytical skills.
- Strong attention to detail and ability to work with large datasets.
- Ability to work independently and in a team environment.
- Excellent communication and interpersonal skills.
- Prior experience in a senior or lead ETL engineer role is preferred.
Join our team and be a part of an innovative and growing organization.