Lead Data Engineer Job at Inherent Technologies, Remote

a1BLdDJsTndEdVh1UHJCS2dTYUJ6TkNuMXc9PQ==
  • Inherent Technologies
  • Remote

Job Description

Position: Lead Data Engineer

Location: Chicago, IL/Remote



Must have skill: Snowflake SQL, Data warehouse, Python, AWS-Lambda, ETL/ELT



Job Description:

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.



Required Skills:
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

Job Tags

Offshore,

Similar Jobs

Kontra Leadership Group

Remote Travel Agent Opportunity Job at Kontra Leadership Group

 ...seeking outgoing individuals for a business opportunity as a Remote Travel Agent. The ideal candidate is passionate about travel and helping others plan their dream vacations. As a Travel Agent, you will work directly with clients, handling inquiries, questions, travel... 

Northeast Grocery

#1236 Accepting Applications Marshalls Creek Job at Northeast Grocery

Pay Range: $15.50- $19.95 SUMMARY Price Chopper/Market 32 Supermarkets is accepting applications for future part-time openings. There are a number of departments withinthe store. A brief description of each department is listed below. Most hiring activity occurs...

YMCA of the Pines

Seasonal Director - Marksmen Job at YMCA of the Pines

 ...characteristics of campers. Training will be provided during Administration Staff Training and All Staff Training. Benefits ~ YMCA Membership ~ Discounted Programs ~12% Employer Retirement Contribution ~ Paid Sick Time Posted Salary Range USD $2... 

Amazon.com Services LLC

Intern - Economics (STRUC) Job at Amazon.com Services LLC

 ...DESCRIPTION Amazon Economics is seeking Structural Economist (STRUC) Interns who are passionate about applying structural econometric methods to solve real-world business challenges. STRUC economists specialize in the econometric analysis of models that involve the... 

Landmark College

Custodian - Night Shift Job at Landmark College

PRIMARY FUNCTIONS: Reporting to the Director of Maintenance and Custodial Services, the Custodian is primarily responsible for the day-to-day general cleaning duties in assigned building and associated tasks. SPECIFIC RESPONSIBILITIES: Performs housekeeping ...