Insight Global is seeking an experienced Data Integration Specialist to join a Canadian banking client to lead the design, modeling, and implementation of scalable high performing curated wealth investment data layer that integrates investment data from multiple platforms. This role will be instrumental in enabling consistent, high-quality investment data views across both legacy and new platforms during a multi-phase migration program. This work will ensure accurate client/account mapping across platforms, high data quality, and readiness for consumption by reporting, analytics, and downstream applications. You will work with MS SQL Server, Netezza, and parallelly design and implement an AWS-based data layer using S3, Glue Studio, Redshift, and AWS DataOps tools. This role will be a 12 month contract with potential extensions and it will be hybrid in Downtown Toronto.
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
Human Resources Request Form. The EEOC "Know Your Rights" Poster is available
here.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
- 10+ years experience in data modeling, data architecture, and data integration.
- Experience with wealth/investment data client, account, holdings, transactions, performance.
- Proven ability to design and implement curated datasets that integrate data from multiple systems/platforms for parallel platform migration scenarios.
- Strong understanding of data governance, data quality, and data lineage.
- Strong expertise in SQL-based relational databases like MS SQL Server, Netezza.
- Solid experience in AWS data services like S3, Glue Studio, Redshift.
- Hands-on experience with DataOps platforms/toolsets and agile data delivery.
- Experience working in Agile Scrum/kanban delivery environments with strong stakeholder communication and technical documentation skills.
- Familiarity with AWS Lake Formation, AWS Glue Catalog, and data mesh principles is a plus.
- Knowledge of investment platform data models (e.g., CRDs, Wealth360, Broadridge, SEI, or similar) is a strong asset.
- Familiarity with DevOps for data and CI/CD for data pipelines.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.