Senior Data Developer - GCP (100% Remote)
Posted
Summary
Contractor role (two openings) to migrate legacy wealth management reporting to a modern GCP stack: designing and optimizing BigQuery data models, ingestion/transformation pipelines (DataFusion, DataPrep), and Tableau analytics, plus data governance and model risk support. Requires ~10 years' data engineering/modeling and wealth-management domain experience.
- The expected base salary range for this position is $80/Hr - $90/Hr, depending on experience, skills, and internal equity.
- The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements.
- Benefit eligibility and offerings vary based on role, employment status, and work location.
- For contractor positions, benefits are limited to those entitlements and protections required by applicable law, which may include (as applicable) vacation pay, public holidays, leaves of absence, and other legally mandated benefits or payments.
- We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications.
- These tools are used to enhance consistency and efficiency.
- All hiring decisions involve human review and are not based solely on automated processing.
Position Overview:
- We are seeking two experienced Senior Data Developers to support a strategic data transformation initiative within the Wealth Management and Investment domain.
- The project involves migrating existing data and reporting solutions from a legacy Wealth Management Reports platform to a modern cloud-based environment using GCP, BigQuery, and Tableau.
- The ideal candidates will bring strong hands-on experience in GCP, BigQuery, data ingestion, and data modeling, along with a solid understanding of investment and wealth management data.
- They will be responsible for designing, developing, validating, and optimizing analytical data models while ensuring data quality, governance, and production readiness.
- This role requires someone who can work closely with product managers, business stakeholders, data governance teams, and model risk management teams in a collaborative environment.
Key Responsibilities:
1. Data Modeling & Analytics Development (50%)
- Develop data strategies and design data products for investment and wealth management platforms leveraging G C P technologies.
- Design and implement conceptual, logical, and physical data models.
- Perform hands-on data modeling, configuration, performance tuning, and proof of concepts (POCs).
- Develop and optimize data models using BigQuery, DataFusion, and DataPrep.
- Support data ingestion and transformation pipelines across multiple systems.
- Collaborate with product managers and business stakeholders to understand data availability, pipeline requirements, and future roadmap needs.
- Design data models that support analytics, reporting, and visualization requirements, particularly using Tableau.
- Apply dimensional modeling principles to build scalable and efficient analytical data structures.
2. Data Governance & Quality (25%)
- Provide input into data governance strategies, security requirements, and data quality standards.
- Identify, report, and resolve data quality issues while performing output testing and validation.
- Ensure data lineage, column-level descriptions, and metadata documentation are maintained.
- Coordinate with Data Governance teams to ensure appropriate data classification and masking requirements.
- Follow established data modeling standards, naming conventions, and development practices.
- Facilitate business owner engagement for model testing, validation, and ethical assessments.
3. Model Implementation & Risk Management (25%)
- Ensure developed data models are validated and production-ready.
- Collaborate with Model Risk Management teams to support model validation and risk assessments.
- Monitor deployed analytical models, identify potential risks, and implement mitigation strategies.
- Provide ongoing issue resolution and performance optimization support.
- Improve data processing efficiency, reduce data redundancy, and optimize data movement across systems.
Required Qualifications & Experience:
- Approximately 10 years of experience in data development, data engineering, or data modeling.
- Strong hands-on experience with GCP and BigQuery.
- Proven experience in data ingestion, data transformation, and pipeline development.
- Strong expertise in data modeling, including conceptual, logical, physical, and dimensional data modeling.
- Previous experience working with Wealth Management, Investment Management, or Financial Services data.
- Understanding of investment portfolios, wealth management data structures, and associated reporting requirements.
- Experience developing analytical data models to support reporting and business intelligence solutions.
- Hands-on experience with Tableau and reporting/analytics environments.
- Familiarity with GCP DataFusion and DataPrep.
- Strong understanding of data governance, data quality, data lineage, metadata management, and data security.
- Excellent communication and stakeholder management skills
- Ability to work independently while contributing effectively within a small, collaborative team.
Technical Skills:
- Cloud Platform: GCP
- Data Warehouse: BigQuery
- Data Integration: DataFusion, DataPrep, Data Ingestion Pipelines
- Data Modeling: Dimensional Modeling, Conceptual, Logical & Physical Data Modeling
- Reporting & Visualization: Tableau
- Data Management: Data Governance, Data Quality, Data Lineage, Metadata Management
- Domain Knowledge: Wealth Management, Investment Management, Portfolio Data
Skills
Sign in to read and join the discussion.