Strong SQL (top priority)
Hands-on experience with BigQuery (required)
Experience building and optimizing data pipelines (ETL/ELT)
Experience with Airflow / Composer
Background in Google Cloud Platform (Google Cloud Platform)
Ability to work with business stakeholders and technical teams
Important Notes:
This is a hybrid role (4 days onsite) – please only submit candidates who are open to this
Candidates must be open and able to convert to full-time
BigQuery experience is mandatory – candidates without it will not be considered
Strong communication skills are critical
Responsibilities
Work closely with various business, IT, Analyst and Data Science groups to collect business requirements.
Design, develop, deploy and support high performance data pipelines both inbound and outbound.
Model data platform by applying the business logic and building objects in the semantic layer of the data platform.
Optimize data pipelines for performance, scalability, and reliability.
Implement CI/CD pipelines to ensure continuous deployment and delivery of our data products.
Ensure quality of critical data elements, prepare data quality remediation plans and collaborate with business and system owners to fix the quality issues at its root.
Document the design and support strategy of the data pipelines
Capture, store and socialize data lineage and operational metadata
Troubleshoot and resolve data engineering issues as they arise.
Develop REST APIs to expose data to other teams within the company.
Mentor and guide junior data engineers.
Education Level
Bachelor''s degree in Computer Science, Computer Engineering, Software Engineering, or other related technical field
Required
Master’s Degree in Computer Science, Computer Engineering, Software Engineering, or other related technical field
Nice to Have
Minimum Experience 6 years
Experience in data engineering solutions such as data platforms, ingestion, data management, or publication/analytics
and
2 years
experience in Google cloud with services like BigQuery, Composer, GCS, DataStream, Dataflows
Required Knowledge, Skills and Abilities
Expert knowledge on SQL and Python programming
Experience working with Airflow as workflow management tools and build operators to connect, extract and ingest data as needed.
Experience in tuning queries for performance and scalability
Experience in Real Time Data ingestion using Google Cloud Platform PubSub, Kafka, Spark or similar.
Excellent organizational, prioritization and analytical abilities
Have proven experience working in incremental execution through successful launches.
Excellent problem-solving and critical-thinking skills to recognize and comprehend complex data issues affecting the business environment.
Experience working in agile environment.
Onsite, Lisle, IL
Rate: $50/hr on W2 Contract