Job Description: Senior Data Engineer (Snowflake, DBT, Fivetran)
Hybrid in Dallas
Role Overview
We are seeking a Senior Data Engineer who is highly hands-on and experienced in building modern, scalable data pipelines and transformation frameworks using Snowflake and dbt. This role focuses on delivering high-quality, production-grade data solutions with strong engineering discipline, leveraging Python, CI/CD, and Git-based development practices.
The ideal candidate brings deep, practical experience in dbt coding and Snowflake engineering, along with a strong sense of ownership, accountability, and the ability to operate independently. Fivetran experience is beneficial, but the primary focus is on dbtand Snowflake expertise.
Key Responsibilities
- Design, build, and maintain scalable ELT pipelines, leveraging Fivetran (or similar tools) for ingestion and dbt for transformation.
- Develop and maintain robust dbt projects, including:
- Modular models (staging, intermediate, marts)
- Reusable macros and Jinja templating
- Snapshots for SCD Type 2 handling
- Schema and custom data quality tests
- Documentation using dbt docs
- Implement modular and reusable dbt architecture supporting multi-environment deployments (dev, test, prod).
- Design and implement scalable data models using best practices (dimensional modeling, star schema, and data vault where applicable).
- Optimize Snowflake performance and cost efficiency, including:
- Query tuning and execution optimization
- Warehouse sizing and workload management
- Effective use of micro-partitions, clustering, and pruning
- Build and enforce strong data quality and validation frameworks, including:
- Unit testing for transformations (dbt and custom frameworks)
- Data reconciliation and consistency checks
- Develop Python-based solutions for automation, orchestration support, metadata-driven processing, and operational tooling.
- Implement and enforce Git-based development practices:
- Version control, branching strategies, pull requests, and code reviews
- Consistent and collaborative engineering workflows
- Build, maintain, and enhance CI/CD pipelines for dbt deployments:
- Automated build, test, and deployment processes
- Environment promotion (dev → test → prod)
- Integration with enterprise deployment pipelines
- Work with orchestration tools such as Airflow / Astronomer to schedule, monitor, and manage data pipeline execution (preferred).
- Collaborate closely with platform, governance, and business teams to align on data requirements, access control, and delivery expectations.
Required Qualifications
- 10+ years of experience in data engineering / analytics engineering roles.
- Strong hands-on experience with dbt in production, including:
- Model development and dependency management
- Macro development and reusable frameworks
- Testing strategies (schema tests, custom tests)
- Deployment and environment management
- Strong Snowflake expertise, including:
- Data modeling and warehouse design
- Performance tuning and cost optimization
- Deep understanding of virtual warehouses, micro-partitions, clustering, and query pruning
- Role-based access control (RBAC) and secure data access
- Advanced SQL expertise with ability to build and optimize complex transformations.
- Strong Python programming skills for data engineering use cases.
- Proven experience with Git integration, including collaborative development workflows.
- Strong experience implementing CI/CD pipelines for data platforms and dbtdeployments.
- Experience building and maintaining production-grade data pipelines with SLAs, monitoring, and reliability standards.
Preferred Qualifications
- Experience with Fivetran (connector setup, ingestion patterns, schema management, troubleshooting).
- Experience with Airflow / Astronomer or similar orchestration tools.
- Exposure to data governance, lineage, and observability tools.
- Financial services / banking domain experience is strongly preferred and will be prioritized, though not mandatory.
关于高知特 (Cognizant)
高知特(Cognizant)（纳斯达克代码：CTSH）作为一家AI Builder和相关技术服务提供商，致力于通过打造全栈AI解决方案，帮助企业将人工智能投资转化为实际价值。公司凭借深厚的行业经验、流程优化和工程技术专长，将企业独特的业务场景融入科技系统，赋能组织释放人才潜能，推动切实成果，并帮助全球企业在瞬息万变的环境中保持领先。如需了解更多详情，敬请访问 cognizant.ai 或关注@cognizant。
补充雇佣信息
薪酬信息截至本职位发布之日为准。Cognizant 保留在适用法律允许的范围内随时修改该信息的权利。
申请人可能需要通过现场面试或视频会议的方式参加面试。此外，候选人在每次面试时可能需要出示其当前所在州或政府签发的有效身份证件。
Cognizant 是一家提供平等就业机会的雇主。在招聘过程中，您的申请和候选资格不会因种族、肤色、性别、宗教、信仰、性取向、性别认同、国籍、残疾、遗传信息、怀孕、退伍军人身份或任何其他受联邦、州或地方法律保护的特征而受到影响。
