Note: The job is a remote job and is open to candidates in USA. Spring Financial is revolutionizing financial access for Canadians, providing smart credit-building, mortgage, and lending solutions. As an Analytics Engineer II, you will own the data models that power analytics and operational reporting, ensuring data products are accurate, performant, and enable efficient decision-making across the organization.
Responsibilities
- Design and implement scalable dimensional models and curated data marts using snowflake and dbt
- Develop and maintain semantic layer metrics that are accurate, governed, and aligned to business definitions
- Write and optimize complex SQL queries and transformations for performance and reliability
- Partner directly with business stakeholders (e.g., in Finance, Marketing, Operations) to define KPIs and translate requirements into reusable data products
- Validate models through automated tests, data reconciliation, peer reviews, and observability practices
- Troubleshoot and resolve data issues in production models, improving data quality checks and alerts
- Use AI-assisted tools for development, anomaly detection, and documentation – validating all outputs for correctness and context
- Mentor junior analytics engineers and contribute to team design reviews, best practices, and technical planning
Skills
- Strong experience with modern analytics tools (e.g., dbt, Hex, Tableau, Snowflake)
- Advanced proficiency in SQL, including window functions, CTEs, and performance tuning
- Experience designing and implementing data models for BI and operational analytics (e.g., star schemas)
- Hands-on experience developing, testing, and documenting models in dbt
- Ability to translate stakeholder requirements into well-modeled, reusable data products
- Proven ability to validate and troubleshoot data issues using testing frameworks and observability tools
- Effective use of AI-assisted tools in analytical and development workflows
- Comfortable mentoring others and contributing to design reviews and technical standards
Company Overview