Senior Data Developer (GCP BigQuery) to deliver investment and wealth management data products and
S.i. Systems • Saskatoon
22 hours ago
Job type
- Contractor
- Remote
Job description
Our banking client is seeking aSenior Data Developer (GCP BigQuery) to deliver investment and wealth management data products and migrate legacy reporting to the cloud within the financial services industry.
Overview:
Two senior contract data resources are needed to support multi-year investment and wealth management data initiatives on GCP, including migrating existing data and reports from a legacy reporting platform to BigQuery and Tableau.
Must-Haves:
- 10+ years of experience in data development, data engineering or data modelling
- Strong hands-on experience with GCP and BigQuery, including data ingestion
- Strong knowledge of investment data and wealth management data, including what investment data looks like and how it is structured
- Experience in data modelling, including dimensional modelling, including building conceptual, logical and physical data models
- Strong knowledge of wealth and investment data models, including investment portfolio data
- Experience building reports and dashboards in Tableau
- Strong team player who thrives in a very team-oriented culture
Nice-to-Haves:
- Experience with GCP Data Fusion and Dataprep
- Experience migrating data and reports from legacy reporting platforms to GCP
- Experience with data governance, data lineage and data quality standards
- Experience across the broader data ecosystem, beyond BigQuery
Responsibilities:
- Responsible for developing data strategy and design for investment and wealth management data products on GCP (BigQuery, Data Fusion, Dataprep)
- Responsible for developing conceptual, logical and physical data models, including hands-on modelling, performance tuning and sandbox POCs
- Responsible for building models with Tableau and other analytics and BI tools in mind
- Responsible for migrating existing data and reports from a legacy reporting platform to BigQuery and Tableau
- Responsible for documenting data lineage and column descriptions and supporting data quality and governance standards
- Responsible for production readiness of final models and collaborating with the Model Risk Management team on validation
- Collaborate with product managers, stakeholders and a small team of permanent employees and contractors