Lead Data Engineer Job at VDart Inc, Chicago, IL

MGxwS3lwNG1kU2o3ZjBrdWROdXc0MVU1Smc9PQ==
  • VDart Inc
  • Chicago, IL

Job Description

Job Title: Lead Data Engineer

Location: Chicago, IL -Remote

Duration: 6+ months Contract

Job Description:

  • 6-8 years+ experience on Snowflake SQL advanced SQL expertise.
  • 6-8 years+ experience on data warehouse experiences hands on knowledge with the methods to identify, collect, manipulate, transform, normalize, clean, and validate data, star schema, normalization / denormalization, dimensions, aggregations etc.
  • 6-8 years+ experience working in reporting and analytics environments development, data profiling, metric development, CICD, production deployment, troubleshooting, query tuning, Atlassian Bitbucket and Bamboo, etc.
  • 6 years+ on Python advanced Python expertise
  • 6 years+ on any cloud platform AWS preferred
  • Hands on experience on AWS on Lambda, S3, SNS / SQS, EC2 is a bare minimum
  • 6 years+ on any ETL / ELT tool Informatica, Fivetran, DBT, Airflow etc. Must
  • 6 years+ with developing functional metrics in any specific business.

Key Responsibilities:

  • Lead data warehouse development activities for a team, leading more than one project in parallel.
  • Assign data warehouse development tasks to team of 1-6 developers (Onsite/Offshore).
  • Be a subject-matter expert (SME) in Data Warehouse domain and relevant business function.
  • Work with minimal supervision and provide status updates and escalation to leadership as appropriate.
  • Provides application support as part of an on-call rotation to work on resolving outages and user questions.
  • Review project objectives and determine best technology to apply.
  • Design and build large scale datasets for a wide range of consumer needs.
  • Build, test and implement highly efficient data pipelines using a variety of technologies.
  • Develop best practice standards for solution design and data structures.
  • Analyze new data sources to understand quality, availability, and content.
  • Write technical design documentation.
  • Conducts peer code reviews.
  • Create and executes unit tests.
  • Supports QA team during testing.
  • Mentor less experienced members of the development team.

Key Skills:

Data Engineering, Snowflake SQL, AWS, Lambda, ETL, Python, Data Warehouse.

Job Tags

Contract work, Remote job, Offshore,

Similar Jobs

University System of New Hampshire Portal

Academic Advisor Job at University System of New Hampshire Portal

 ...Summary Of Position Under the administrative supervision of designated supervisor advise and counsel students in relation to academic programs; Design and administer appropriate programs services and activities that assist students with academic planning. Other... 

NYC Careers

Public Records Officers Job at NYC Careers

Public Records Officers Location New York, NY (Ridgewood area) : OAG - Child Support | Child Support Technician II | 24-0186 | Revised...  ...paternity tests; processes and distributes test results May serve as a Notary Public Enters, retrieves, and updates child support case... 

Tarpon Specialty Services

RMD Pipe / Combo Welders + Per Diem Pay | Baton Rouge, LA Job at Tarpon Specialty Services

 ...Were hiring experienced RMD Pipe Welders for ongoing industrial and fabrication work in Baton Rouge . Tarpon Specialty Services...  ...Industrial Construction / Turnaround Long-Term Projects Local & Travel / Per Diem Why Tarpon: Work with a professional crew,... 

Ziggi's Coffee

Barista Job at Ziggi's Coffee

 ...Ziggi's Coffee is Hiring a Talented Barista Are you seeking to become part of a vibrant culture where delivering exceptional customer service is paramount...  ...with us! Ziggis Coffee is a leading specialty coffee shop and drive-thru franchise dedicated to serving only the... 

Boeing

Senior Healthcare and Insurance Data Analyst Job at Boeing

 ...Senior Healthcare and Insurance Data Analyst Company: The Boeing Company We are seeking a detail-oriented Senior Healthcare and Insurance Data Analyst to join the Health & Insurance Operations team supporting Boeings US employee health insurance and ancillary...