Chelsoft Solutions

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