Lead Data Engineer

Optomi, in partnership with a leading transportation/logistics company, is seeking a Lead Data Engineer to serve as a foundational member of a large-scale data modernization initiative centered around Snowflake. This individual will act as the primary internal engineering resource supporting the design, development, and long-term ownership of the organization's modern data platform. Qualifications: • 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. 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.