GCP Data Engineer_Local to IL and MD_Only on W2

GCP Data Engineer Local to IL and MD Needed Only on W2 (first 6 months) Rate- $48/hr- $55/hr on W2 Visa Needed- GC, USC and H4EAD only Role Details: • Title: Senior Data Engineer • Location: Hybrid – 4 days onsite (Lisle, IL or Columbia, MD) • Engagement Type: Contract-to-hire (conversion expected around 6 months) Key Requirements: • Strong SQL (top priority) • Hands-on experience with BigQuery (required) • Experience building and optimizing data pipelines (ETL/ELT) • Experience with Airflow / Composer • Background in GCP (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 Education Level Education Details Required/ Preferred Bachelor's degree Computer Science, Computer Engineering, Software Engineering, or other related technical field Required Master’s Degree Computer Science, Computer Engineering, Software Engineering, or other related technical field Nice to Have   Work Experience Minimum Experience Experience Details Required/ Preferred 6 years experience in data engineering solutions such as data platforms, ingestion, data management, or publication/analytics Required 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 GCP 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. Benefits: Health insurance options, 401(k) retirement savings options, statutory benefits, and other benefits may be available to eligible employees in accordance with applicable law and company policy. Immigration and work authorization support, as well as professional development opportunities, may also be available for eligible roles, subject to business needs, client requirements, and applicable law.