Cube Developer

Description

The company is a global consulting firm that builds digital solutions for financial services and technology clients, combining engineering, data, cloud and AI work.

It has more than 17,000 staff across 58 offices in 22 countries and has operated for over 20 years.

Its FinLabs research unit develops solutions in areas such as AI, blockchain, data science, digital underwriting and mobile applications.

You would work with business stakeholders, data engineers and technology teams to turn business needs into scalable, secure analytics that perform well.

Responsibilities

• Build and run semantic models in Cube Dev, defined in YAML, with dimensions, facts, measures, joins and pre-aggregations.
• Set up Cube Views and access policies, and write analysis logic in DAX, MDX, SQL and GraphQL.
• Implement row-level, column-level and role-based security.
• Tune the semantic layer through caching, query improvements and pre-aggregation.
• Define modeling standards, naming rules and reusable semantic components.
• Diagnose problems in Cube Dev models, queries, access and speed.
• Create and keep up scorecards, dashboards, reports and analytical apps in Power BI.
• Write and tune DAX measures, calculated columns, KPIs and time-intelligence logic.
• Build reusable Power BI datasets, semantic models and report templates.
• Apply row-level and other Power BI security controls.
• Improve the speed of reports, datasets and data models.
• Look after workspaces, deployment pipelines, apps and access in the Power BI Service, and schedule refreshes.
• Investigate issues with reports, gateways, datasets, refreshes and performance.
• Encourage good practice in Power BI development, deployment, governance and lifecycle management.
• Work with Snowflake, SQL Server, Databricks, Dataiku or similar platforms.
• Design star and snowflake schemas for reporting and analytics.
• Build ETL and ELT flows using SQL, Power Query/M and cloud integration tools.
• Bring data from several enterprise sources into governed models, checking quality, consistency, completeness and reconciliation.
• Apply data governance, metadata management and modeling standards.
• Work with data engineering teams to improve source structures and downstream performance.
• Gather, analyze and document business and reporting needs, and turn them into technical designs.
• Collaborate with business users, data engineers, architects and application teams.
• Support production semantic models, reports, dashboards and pipelines, including root cause analysis and fixes.
• Review code, join technical discussions and contribute to best-practice initiatives.
• Take part in Agile or Scrum ceremonies, sprint planning, backlog refinement and delivery.
• Write technical documentation, data dictionaries, solution designs and support procedures.

Requirements

• A bachelor's degree in computer science, information systems, engineering or a related field.
• 5 to 10 years in business intelligence, analytics or data development.
• At least 4 years of hands-on Power BI development.
• Solid Cube Dev semantic modeling and YAML configuration skills.
• Experience building enterprise semantic layers and analytical data models.
• Experience with GraphQL, MDX or similar analytical query and semantic-layer technologies.
• Deep working knowledge of Power BI Desktop and Power BI Service, DAX, Power Query/M, SQL, data modeling, semantic model development and Snowflake or a similar cloud warehouse.
• Experience applying RLS, CLS, role-based access management and other data security controls.
• Good grasp of data governance, data quality and reporting standards.
• Experience with Git and CI/CD deployment processes.
• Strong analytical, troubleshooting, communication and stakeholder management skills.
• Preferred: experience with Azure Data Platform services.
• Preferred: knowledge of Databricks and Snowflake architecture and development practices.
• Preferred: familiarity with Agile or Scrum delivery methods.
• Preferred: Microsoft Power BI certification, ideally PL-300: Power BI Data Analyst Associate.
• Preferred: experience supporting finance, risk, regulatory, compliance or enterprise reporting.
• Preferred: experience with Power BI deployment pipelines, gateways, incremental refresh and large datasets.
• Preferred: knowledge of cloud-based data integration, orchestration and DevOps practices.

Conditions

The base salary for this role in Mississauga, ON is CAD $115k to CAD $125k per year plus benefits, and it varies by geography and other factors.

Flexible hybrid work policy.

All employment decisions are based on business needs, job requirements and individual qualifications, without regard to protected characteristics.

Benefits

• 15 days (3 weeks) of paid annual leave, plus 10 personal days for floating and sick days.
• Medical, dental, vision, life insurance and long-term disability cover.
• RRSP with an employer contribution of up to 4%.
• A higher education certification policy.
• Free access to more than 5000 curated courses on Udemy for Business.
• Coaching from experienced colleagues in FinLabs and the Centers of Excellence.
• Work on projects for leading tier-one banks, financial institutions and insurance firms.
• The possibility to work abroad within a multinational firm with 58 offices in 22 countries.
• A diverse, global work culture.