Note: The job is a remote job and is open to candidates in USA. Optomi is partnering with a leading transportation/logistics company, seeking a Lead Data Engineer to be a foundational member of a large-scale data modernization initiative centered around Snowflake. This role involves designing, developing, and owning the organization's modern data platform while collaborating with various stakeholders to ensure alignment with business objectives.
Responsibilities
- Partner with internal stakeholders and external consulting teams to design and implement a scalable Snowflake-based data platform
- Help establish and maintain a modern data architecture utilizing medallion principles (Bronze, Silver, Gold)
- Develop, optimize, and maintain data pipelines, ingestion frameworks, and transformation workflows
- Evaluate and contribute to tooling decisions across the modern data stack, including Snowflake-native capabilities and technologies such as dbt, Fivetran, Airbyte, Matillion, or similar platforms
- Support data modeling, pipeline orchestration, performance tuning, and platform optimization initiatives
- Participate in requirements gathering and solution design workshops to ensure technical solutions align with business objectives
- Collaborate with analytics teams to deliver trusted, governed datasets that support self-service reporting and advanced analytics
- Establish best practices around documentation, data governance, security, data quality, and platform maintainability
- Assist in evaluating and implementing data quality monitoring and governance frameworks
Skills
- 7+ years of experience in Data Engineering, Analytics Engineering, Data Platform Engineering, or related disciplines
- Strong hands-on expertise & core competence with Snowflake
- Experience designing and implementing modern cloud data architectures
- Strong SQL, Python, and data modeling skills
- Experience building and maintaining enterprise-scale ETL/ELT pipelines
- Familiarity with modern data stack technologies including dbt and at least one major ingestion/orchestration platform (fivetran, stitch, matillion, etc)
- Experience working across the full lifecycle of data ingestion, transformation, modeling, governance, and consumption
- Ability to independently evaluate architectural tradeoffs and contribute to solution design discussions
- Strong communication skills with the ability to engage both technical and business stakeholders
Company Overview
Company H1B Sponsorship