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

T-Brothers Logistics

CDL A Owner Operator Truck Drivers Job at T-Brothers Logistics

 ...Job Description Welcome to T-Brothers Logistics, where we are currently seeking Owner Operators to join our team in Sioux Falls, SD. As an Owner Operator with T-Brothers Logistics, you will have the opportunity to run your own business while partnering with a supportive... 

Stanislaus County Department of Workforce Development

Legal Assistant Job at Stanislaus County Department of Workforce Development

 ...How to Apply: Send resumes to ****@*****.*** or drop off at 630 Crane Avenue, Suite C, Turlock. (This is a part time position of 20 hours a week, ideally 1:00 to 5:00 weekdays, but can be flexible. Starting wage depends on qualifications $18.00... 

Boston Children's Hospital

Research Administrator II | Boston Children's Hospital Job at Boston Children's Hospital

 ...may advise PI on financial management of portfolio. Utilizes hospital financial systems to process and monitor financial transactions...  ...and reports. May oversee Laboratory Medicine departmental administration of effort reporting and ensures timely submission of... 

All Staffing Warehousing

Forklift Operator and General Labor Job at All Staffing Warehousing

 ...agencies in Bucks County, come be apart of our team! ASW's client is hiring immediately for experienced sit down and stand up Forklift Operators in Bensalem, PA. The ideal candidate would be someone with a great work ethic and attendance record. Pay: $16 per hour... 

The Eye Group

Optometry Position - Central Minnesota - Strong Full time position Job at The Eye Group

 ...will be patient-centered, compassionate, and willing to embrace a team atmosphere. Nearby Pomme de Terre River is great for fishing, hiking, boating, and other watersports. Notable nature features make this a desirable area for outdoor life and creating memories. You may...