Key skills
SQLETLELTData EngineeringAnalyticsSnowflakedbtFivetranAzureAzure DevOpsGitHubVersion ControlAgileMentoringCommunicationCollaboration
About this role
Cognizant is seeking a Principal Data and Analytics Engineer who will serve as an engineering lead within the Technology & Data organization. This role involves providing technical direction, mentoring engineers, and ensuring high standards for technical quality in data engineering and analytics.
Responsibilities:
- Mentors and supports analytics and data engineers
- Conducts code reviews
- Sets high standards for technical quality
- Design, test, and maintain both conceptual and analytical data models
- Design, build, and optimize scalable, maintainable, and resilient end-to-end ETL/ELT data pipelines
- Utilize platforms like dbt to ensure robust data flow, conduct UAT, and manage code releases
- Skilled in version control systems for collaborative development and code management
- Implementing logging, metrics, and alerting for data pipelines
- Collaborate with analysts, analytics and data engineers, and solution architects to align data solutions with strategic goals
- Actively participate in agile ceremonies and contribute to sprint goals
Requirements:
- Deep expertise in analytics engineering and data engineering
- Experience with Data Build Tool (dbt)
- Experience with Snowflake
- Advanced Data Modelling expertise
- Experience with Fivetran
- Excellent communication skills
- Technical expertise in conceptual and analytical modeling
- Ability to design, test, and maintain conceptual and analytical data models
- Experience with logical, physical, and dimensional (star/snowflake) schemas
- Ability to optimize performance through partitioning and indexing
- Knowledge of SQL best practices and peer code reviews
- Experience in designing, building, and optimizing scalable ETL/ELT data pipelines
- Experience with orchestration tools for scheduling, dependency management, and error handling
- Mastery of SQL skills
- Skilled in version control systems for collaborative development and code management (i.e Azure DevOps, GitHub)
- Experience implementing logging, metrics, and alerting for data pipelines
- Strong communication and collaboration skills
- Ability to collaborate with analysts, analytics and data engineers, and solution architects
- Agile mindset and experience participating in agile ceremonies
- Ability to apply agile principles to respond to change and improve team processes