Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process expertise, and a global, collaborative workforce that embodies the future of work. Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 2000, and the Fortune 500 and is ranked among the top performing and fastest growing companies in the world.
Our Culture
Your passion, integrity and experience are integral to Cognizant's success. You will join a dynamic and expanding global leader in IT and Business consultancy where you will be valued for who you are. We take pride in our partnership with our clients, so your ability to add value and provide exceptional service to our clients is fundamental to your success. In return, you will be presented with opportunities to develop your career and collaborate with talented colleagues in a supportive, diverse environment.
At Cognizant we recognize that companies that are open and welcoming to a multi-culturally diverse workforce will thrive with fresh perspectives and collaborative knowledge. Cognizant focuses on promoting & increasing gender diversity and providing a workplace which encourages great participation and an equal playing field, where merit and accomplishment are the only criteria for success.
Job Summary:
We are seeking a Data Engineer specializing in Coalesce to own and deliver the data transformation layer as part of a large-scale data platform modernization for an Australian payments company. This role focuses on building and maintaining SQL-based transformation pipelines in Coalesce, implementing Bronze-to-Silver cleansing rules and Silver-to-Gold business logic within a medallion architecture on Snowflake. The ideal candidate has strong Coalesce expertise and can create reusable node templates that accelerate data product delivery.
Key Responsibilities
- Design and build transformation pipelines in Coalesce, covering Bronze-to-Silver data cleansing, deduplication, and standardization.
- Implement Silver-to-Gold transformation logic including star schema construction, business rule application, and aggregation layers.
- Create and maintain reusable Coalesce node templates for common transformation patterns across the platform.
- Configure Coalesce environments, workspace management, and environment promotion (Dev → Test → Prod).
- Optimize transformation performance through efficient SQL patterns and Snowflake compute management.
- Collaborate with Data Architects to translate data models and data product specifications into Coalesce transformation graphs.
- Implement data quality checks and validation logic within the transformation pipeline.
- Integrate Coalesce deployments into CI/CD pipelines using GitHub Actions.
- Document transformation logic, node configurations, and data lineage within the pipeline.
Required Skills & Experience:
- Deep hands-on expertise with Coalesce for SQL-based transformations, node templates, graph design, and environment management.
- Strong proficiency in Snowflake DDL/DML, Dynamic Tables, and query optimization for transformation workloads.
- Expert-level SQL for complex transformations, CTEs, window functions, pivoting, merge statements, and analytical queries.
- Understanding of Bronze / Silver / Gold patterns and how Coalesce maps to each layer.
- Working knowledge of dimensional modeling (star/snowflake schemas) and Data Vault 2.0 concepts.
- Experience with version control and deployment automation for transformation code. Preferred Skills (Nice-to-Have):
- Experience building data products following spec-driven development methodologies.
- Familiarity with Fivetran and how ingestion feeds into the Coalesce transformation layer.
- Knowledge of dbt as an alternative transformation tool.
- Experience in the payments, fintech, or banking domain.
- Familiarity with data quality and data observability tools.
- Snowflake SnowPro or Coalesce certification.
Benefits:
Joining Cognizant will give you the opportunity to learn and collaborate with some of the most talented people in the industry, while having your finger on the pulse of emerging industry trends and working on the cutting edge of technology in your field of expertise.
We recognize that our people perform at their best when they feel valued as significant contributors and that is why at Cognizant, taking care of our employees is a priority:
- You can pursue innovative career tracks and opportunities here
- You can enhance your professional development through education and dedicated training
- We’ll give you the skills you need to keep pace with the changing workplace while our compensation, benefits and wellness packages help you stay healthy and plan for the future.
Next Steps:
Please reach out to our friendly and welcoming team today to apply and register your interest for this full-time role. We'd love to help you get your next role and enable you to fulfil your professional ambitions.
