Data Engineer

Location: El Segundo, CA(Day One from Onsite role)

Job Description

As a Data Engineer - Contractor on Central Data Platforms team, you will be supporting Data Integrations & Data Analytics Engineer teams, and other shared services. This role requires not only highly technical and analytical skills, but also strong collaboration and communication across internal & external technical teams, and business stakeholders.

The primary responsibility of this role will be delivering a large database migration project by providing technical and analytics solutions in collaboration with multiple technical and non-technical teams.

Day To Day Responsibilities

• Gain an understanding of the scope and timeline of the migration project
• Execution of all migrations assigned by your manager on a daily and weekly basis
• Collaborate with product/business stakeholders, architects, engineering teams and analytics teams to build accurate, timely and actionable information products
• Design, develop, test, and maintain ELT (Extract, Load, Transform) processes to bring data from multiple sources into a single warehouse environment
• Ensure smooth ongoing operations of data warehouse and data pipeline platform with high availability and performance while making continuous improvements and leverage best practice and features of the technical stack offers.
• Provide production support on a rotating basis

Qualifications

• BS or MS degree in Computer Science, Mathematics, Statistics, or related discipline
• 5+ years of experience with SQL
• 2+ years of experience with Python
• Strong understanding of BI best practices, relational structures, data warehousing methodologies, ELT processing and dimensional data modeling
• Excellent data analytics skills the candidate should be able to test and document the accuracy of the data efficiently.
• Experience with source code management and version control (Git/GitHub/GitLab)
• Excellent collaboration and commutation skills, both written and verbal
• Must be self-directed and be able to thrive in a quick turn-around working environment
• Expert SQL skills, particularly in an analytics / reporting capacity. Extensive experience creating and maintaining DW and reporting processes
• Advanced Data modeling skills (hands-on experience + theoretical understanding)
• Implementing star-schemas/snowflake-schemas
• Incremental and Full Load
• Slowly changing dimensions
• Advanced SQL skills required
• Primary/foreign keys, indexes (when to use them)
• Joins and Set Operations
• Tables and Views (How are they different? Pros and cons of using)
• Window functions
• Scalar and aggregate functions

Nice to Have

Experience with Snowflake

Experience working in an Agile environment

Prior experience performing a data warehouse migration