Data Engineer-JP00002609/JP00002610

Job Description: Finance Systems - Data Engineer Associate

Location: Markham, ON

Work Mode: Hybrid (3 days onsite)

Job Type: Contract

Eligibility: Canadian Citizen, PR Holder, or Valid Canadian Work Permit

Overview

We are seeking a skilled Finance Systems - Data Engineer Associate to design, develop, and optimize ETL processes for our finance systems. The ideal candidate will have strong expertise in PostgreSQL, ETL development (Informatica), and experience in the insurance industry, particularly with Guidewire systems. The role requires a collaborative mindset and an ability to ensure data accuracy and integrity across finance and insurance operations.

Top Required Skills:

1. Strong expertise in PostgreSQL and database design, particularly for finance systems.
2. Proven ETL development experience with Informatica PowerCenter and BDM.
3. Experience with Guidewire Policy, Billing, and Claims Centers.

Key Responsibilities

1. ETL Development & Optimization:
   • Design, develop, and maintain ETL processes to extract, transform, and load data into finance systems.
   • Optimize complex SQL queries and stored procedures in PostgreSQL.
   • Monitor daily/monthly ETL jobs and resolve failures.
2. Collaboration:
   • Work with finance and insurance teams to gather data requirements and ensure data accuracy.
   • Collaborate with teams using Guidewire applications to meet data requirements and maintain system integrity.
3. Financial Reporting & Analysis:
   • Build Qlik reports and implement financial calculations using PostgreSQL stored procedures or ETL tools.
   • Perform data analysis and troubleshooting for data-related issues.
   • Create financial reports and execute calculations in Corporate Reporting Engine (CRE) and Accounting Engine (AE).
4. Data Management & Quality Assurance:
   • Implement data quality checks and validation processes.
   • Monitor and improve the performance of ETL processes and database systems.
   • Maintain comprehensive documentation for technical specifications, ETL processes, and database schemas.
5. Guidewire Data Integration:
   • Extract and integrate data from Guidewire BillingCenter, PolicyCenter, and ClaimsCenter for financial reporting and analysis.
   • Utilize Guidewire data for tracking receivables, revenue recognition, and claims reserves.
6. Technology Leadership:
   • Stay updated with industry trends and best practices in ETL, data warehousing, and database management.
   • Leverage automation tools like Control-M and ASG Zena to streamline processes.

Requirements

1. Technical Skills:
   • Expertise in PostgreSQL development and database design.
   • Proficiency in ETL tools, particularly Informatica PowerCenter and Informatica BDM.
   • Knowledge of Oracle Fusion applications, including Accounts Payable, Cash Management, and Fixed Assets.
   • Experience with Guidewire PolicyCenter, BillingCenter, and ClaimsCenter.
   • Familiarity with automation tools (e.g., Control-M, ASG Zena) and Unix scripting.
   • Experience in data visualization tools like Qlik and Python reporting.
   • Familiarity with Snowflake and cloud-based data solutions.
2. Industry Experience:
   • Background in the insurance industry with knowledge of underwriting data terminology.
   • Experience supporting finance systems and understanding accounting principles (e.g., Balance Sheet, P&L).
3. Methodologies & Tools:
   • Agile methodology and JIRA experience.
   • Solid understanding of data warehousing concepts and best practices.
4. Soft Skills:
   • Excellent problem-solving skills and attention to detail.
   • Strong communication and collaboration abilities.
   • Capability to work independently and in team environments.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Certifications in Informatica (ICP, IDMC, CDCG, MDM) and SQL (Associate level).
• Guidewire professional certifications.
• Familiarity with Power BI for data visualization.

We encourage you to apply if you meet the requirements and want to contribute to a dynamic finance and insurance environment.