Discover your dream Career
For Recruiters

Senior Data Engineer -Coalesce

Cognizant Sydney, Australia
Posted 9 days ago Permanent Competitive

Senior Data Engineer -Coalesce

Cognizant Sydney, Australia
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.
Job ID  00069633281
More Jobs From Cognizant
Cognizant
Snowflake Lead Data Engineer
Cognizant
Sydney, Australia
12 days ago Full time Competitive
Cognizant
Senior GCP Data Engineer
Cognizant
Sydney, Australia
2 days ago Full time Competitive
Cognizant
Ui Path Senior Automation Engineer/Architect
Cognizant
Sydney, Australia
14 days ago Full time Competitive
Cognizant
Senior Full Stack Engineer
Cognizant
Sydney, Australia
14 days ago Full time Competitive
Cognizant
Data Test Engineer
Cognizant
Melbourne, Australia
13 days ago Full time Competitive
Cognizant
Snowflake Data Engineer
Cognizant
Melbourne, Australia
13 days ago Full time Competitive
Cognizant
Senior Data Technical Lead
Cognizant
Melbourne, Australia
1 day ago Full time Competitive
Cognizant
Senior Data Scientist
Cognizant
Melbourne, Australia
13 days ago Full time Competitive
Cognizant
RPA, AI and Web Test Specialist
Cognizant
Sydney, Australia
8 hours ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
Recommended Jobs
Allianz
Data Engineer / Analyst (m/f/d)
Allianz
Munich, Germany
Booking.com
Senior Data Engineer I - Marketplace
Booking.com
Bangalore, India
The Travelers Indemnity Company
Senior Data Engineer (AWS, Databricks)
The Travelers Indemnity Company
Hartford, United States