Position: Lead Snowflake Data Engineer
Location: Rosemont, IL (Remote ok)
Position overview: We are looking for a hands-on Lead Data Engineer to join our team! In this role, you will be responsible for leading the team of data engineers (Onsite/Offshore) to build new data pipelines (loading millions of transformed true records into our cloud data warehouse in a timely manner) to support evolving analytical needs for critical business decisions. Manage existing data pipelines keeping data relevant and true, ready for analytical consumption.
Key responsibilities:
Lead data warehouse development activities for a team,
Lead 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.
Create and maintain project specific documentation like architecture diagrams, flow charts
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.
Technical skills:
6 years+ experience on Snowflake SQL advanced SQL expertise
6 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 years+ experience working in reporting and analytics environments development, data profiling, metric development, CICD, production deployment, troubleshooting, query tuning, Atlassian Bitbucket and Bamboo etc,
4 years+ on Python advanced Python expertise
4 years+ on any cloud platform AWS preferred
o Hands on experience on AWS on Lambda, S3, SNS / SQS, EC2 is a bare minimum,
4 years+ on any ETL / ELT tool Informatica, Pentaho, Fivetran, DBT etc.
4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),
Must have soft skills:
Enterprise Experience Understands and follows enterprise guidelines for CICD, security, change management, RCA, on-call rotation etc,
Nice to have:
Technical certifications from AWS, Microsoft, Azure, GCP or any other recognized Software vendor,
4 years+ on any ETL / ELT tool Informatica, Pentaho, Fivetran, DBT etc.
4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),
4 years+ with team lead experience,
3 years+ in a large-scale support organization supporting thousands of users
...Leo Tidwell Excavating Corporation has been a utilities contractor for the past 46+ years. This includes substructure: (Plowing, trenching, excavating, directional boring, rodding, pulling, paving, conduit and cable placing, fiber placing and pulling and manhole placement...
...TEAM IDEAL | SHOW UP AND SPEAK UP| BE A RESOURCE Ideal Building Solutions is a specialty contractor in the fields of commercial roofing and fall protection. Our purpose is to Do Hard Things & Become Better Versions of Ourselves daily! We have created an environment...
...HIRING NOW: Travel PACU RN in Newport, OR Travel rate: Weekly Gross Pay: $3,053 for 40 hours Taxable: $1,240 weekly ($31 x 40) Non-Taxable: $1,813 weekly ($45.33 x 40) Location: Newport, OR Shift: 8-hours Days (Monday-Friday 8-1630) Start: 7/21...
Residential Services, Inc. (RSI) has a part-time Mental Health Practitioner opening with our Adult Rehabilitative Mental Health Services... ...~ Paid training ~$500 refer a friend bonus ~ Employee Assistance Program ~ Long term/Short term disability and life insurance...
...exceed goals, showing a keen interest in their development and professional growth? If so, then a Retail Store Manager position at Spectrum may be right for you. Our Retail Sales team powers more than 700 store locations that serv e our communities and...