Lead Data Engineer (Onsite)

About the role

The Lead Data Engineer is a senior individual contributor within the Technology & Data organization. This role combines deep expertise in analytics and data engineering, providing technical direction and thought leadership across teams.

Responsibilities

• Conceptual and Analytical Modeling: Design, develop, and maintain both conceptual and analytical data models, including logical, physical, and dimensional (star/snowflake) schemas, to support business analytics and reporting. Optimize performance through partitioning and indexing, and ensure quality and consistency via SQL best practices and peer code reviews.

• Data Pipeline Orchestration and Development: Design, build, and optimize scalable, maintainable, and resilient end-to-end ETL/ELT data pipelines. Leverage orchestration tools for scheduling, dependency management, and error handling, while extracting and transforming data from source systems. Utilize platforms like dbt to ensure robust data flow, conduct UAT, and manage code releases for reliable system performance.

• Mastery of SQL skills: DevOps & Code Management: Skilled in version control systems for collaborative development and code management (i.e. Azure DevOps, GitHub)

• Mastery of SQL skills: Monitoring & Observability: Implementing logging, metrics, and alerting for data pipelines

• Strong Communication and Collaboration Skills: Collaborate with analysts, analytics and data engineers, and solution architects to align data solutions with strategic goals. Communicate effectively across technical and non-technical teams.

• Agile Mindset: Actively participate in agile ceremonies and contribute to sprint goals. Apply agile principles to respond to change, iterate quickly, and continuously improve team processes and product outcomes.

Requirements

This is a hybrid position requiring 3 days a week in a client or Cognizant office in Oak park Heights, MN. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements.

Qualifications

• Data Build Tool, Snowflake, Advanced Data Modelling experts

• Excellent communication skills

Benefits

Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance

• Paid holidays plus Paid Time Off

• 401(k) plan and contributions

• Long-term/Short-term Disability

• Paid Parental Leave

• Employee Stock Purchase Plan

Pay

The annual salary for this position is between $81,000 - $140,000 depending on experience and other qualifications of the successful candidate.

Schedule

This is a hybrid position requiring 3 days a week in a client or Cognizant office in Oak park Heights, MN.