Data Engineering Tech Lead

FULL TIME

No H1B

Conshohocken,PA/Dallas,TX

Job DescriptionRole: Data Engineering Tech Lead

Proven experience as an ETL Engineer or in a similar role, with a minimum of 10 years of experience designing and developing ETL processes.• 7 years of experience in lead or senior roles; demonstrating ability to lead data engineering projects end-to-end.• Strong expertise in ETL tools and technologies, such as ADF, Databricks, SQL, Python, SSIS, and SSRS.• Proficiency in SQL and experience working with relational and cloud databases, preferably Snowflake and SQL Server. • Demonstrated experience building, optimizing, and supporting large-scale data platforms.• Software engineering mindset, leading with the principles of source control, infrastructure as code, testing, modularity, automation, CI/CD, and observability.• Strong knowledge and understanding of the modern data platform and its key components - ingestion, transformation, curation, quality, governance, and delivery.• Experience working with a wide variety of source systems, building data pipelines to ingest both streaming and batch data, and delivering clean data for downstream usage in reporting, analytics, data science, and applications.• Strong knowledge of data modeling techniques (3NF, Dimensional, Vault), data lakes, data warehouses, data marts, design patterns (lambda, kappa, medallion, etc.), and agile development.• Familiarity with cloud-based data platforms (e.g., AWS, Azure) and related services (e.g., S3, Redshift, Big Query) is desirable.• In-depth knowledge of data integration patterns, data modeling, and database concepts.• Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex data issues.• Familiarity with business intelligence visualization tools such as Looker, Tableau, Power BI, etc.• Prior experience working in Enterprise Agile/Scrum teams.• Excellent communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.• Strong attention to detail and commitment to delivering high-quality solutions.• Ability to work independently and manage multiple priorities in a fast-paced environment.

Job Type: Full-time

Pay: $68,656.00 - $112,682.49 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Compensation package:

• Bonus opportunities

Experience level:

• 9 years

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• Please Mention your Work Authorization (USC OR GC OR OPT)?

Experience:

• SQL: 5 years (Preferred)
• Data Modeling: 4 years (Preferred)
• ETL processes: 8 years (Preferred)

Ability to Commute:

• Dallas, TX (Preferred)

Ability to Relocate:

• Dallas, TX: Relocate before starting work (Preferred)

Work Location: On the road