Role Description

Lead Business Intelligence Developer

Lead II - Data Engineering

Who We Are

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world.

Visit us at UST.com.

You Are

Leads team and independently designs, develops, tests, implements, documents, and supports business intelligence systems, including semantic layers, cubes/ extracts, scheduling, as well as analytic, visualization, and reporting technologies and processes.

The Opportunity

- Leads small projects with manageable risks and resource requirements, and develops detailed work plans
- Works closely with business and IT stakeholders to optimize reporting information by defining business requirements and populating the business intelligence structures
- Designs, develops, and maintains the business intelligence technologies and architectures
- Performs business intelligence design and testing, including data design, business intelligence architecture, metadata, and repository creation
- Creates and supports the process to pull the information from source data warehouse or data store and place it into the cubes/ extracts
- May supervise or manage four or fewer employees, and responsible for team's performance; coaches and mentors team members
- Creates business intelligence schematics and layouts, and develops capacity planning
- Seeks continuous business intelligence performance improvement and ensures security of information
- Creates and implements effective metrics and monitoring processes
- Recommends improvements and applies standards, processes, and procedures for business intelligence systems

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What You Need

- Master’s degree and/or LOMA certification
- Experience Required:
- 8+ years business intelligence or relevant experience
- Experience in Kimball dimensional modeling
- 8+ years experience with semantic layers, cubes/ extracts, and scheduling technologies, as well as analytic, visualization, and reporting technologies
- Demonstrated ability to quickly learn new technologies
- 4+ years of Data Analysis experience
- Demonstrated ability to lead small teams
- Advanced ability to solve complex problems, drawing upon creativity, experience, and multiple sources of information
- Advanced interpersonal skills, including the ability to build consensus
- Advanced communication skills, including the ability to communicate complex or difficult information
- Regular and predictable attendance
- Preferred:
- Insurance and/or reinsurance industry knowledge
- Technical Requirements:
- Power BI semantic model design, dimensional modeling, and star schema architecture




- Strong DAX, Power Query (M), and Power BI development experience
- Snowflake SQL, query tuning, and performance optimization
- Experience with enterprise Power BI deployments, gateways, CI/CD, and governance
- Row-level security, security modeling, and Power BI governance best practices
- Experience gathering requirements and translating business needs into scalable reporting solutions
- Ability to mentor developers, establish standards, and provide architectural guidance
- Experience migrating SSRS reports to Power BI, including report rationalization, redesign, and semantic model development
- Experience migrating SSAS Tabular models to Power BI semantic models
- Experience converting Excel Pivot reports connected to SSAS/Tabular models into Power BI solutions
- Experience designing abstraction layers, reporting views, data products, and semantic layer strategies
- Experience leading large-scale reporting modernization and migration initiatives similar to EFD
- Ability to define migration patterns, governance processes, deployment strategies, automation opportunities, and target-state reporting architecture
- Ability to work with business stakeholders and technical teams to drive reporting transformation efforts end-to-end
- Nice-to-have skills:
- Microsoft Fabric experience
- Python and automation
- Power BI administration and capacity management
- Experience with metadata-driven reporting frameworks and report migration tooling

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below. Role Location: Remote - Canada

Compensation Range: $104,000-$130,000

Advantages

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), paid holidays, and are eligible for paid bereavement leave and jury duty. They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year). They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Part-time regular and temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All Canadian employees who work in a province, territory or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.

What We Believe





We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.

Humility

We will listen, learn, be empathetic and help selflessly in our interactions with everyone.

Humanity

Through business, we will better the lives of those less fortunate than ourselves.

Integrity

We honor our commitments and act with responsibility in all our relationships.

An Equal Opportunity Workplace, Free of Discrimination and Harassment

At UST, we strive to provide a work environment free of discrimination and harassment. We are an equal opportunity employer and employment decisions are based on merit and business needs.

Our Human Rights

Policy further illustrates our stand on this. We are committed to following fair employment practices that provide equal opportunities to all employees. We do not discriminate or allow harassment on the basis of race, color, religion, disability, gender, national origin, sexual orientation, gender identity, gender expression, age, genetic information, military status, or any other legally protected status.

At UST, we value diversity and believe that a diverse workplace builds a competitive advantage.

Un lieu de travail à égalité des chances, sans Discrimination et harcèlement

Chez UST, nous nous efforçons de fournir un environnement de travail exempt de discrimination et harcèlement. Nous sommes un employeur garantissant l'égalité des chances et des décisions en matière d'emploi sont basés sur le mérite et les besoins de l'entreprise. Notre politique en matière de droits de l'homme illustre notre position à ce sujet.

Nous nous engageons à respecter un emploi équitable des pratiques qui offrent des chances égales à tous les employés. Nous ne faisons pas discriminer ou permettre le harcèlement sur la base de la race, de la couleur, de la religion, du handicap, genre, origine nationale, orientation sexuelle, identité de genre, expression de genre, âge, informations génétiques, statut militaire ou tout autre statut légalement protégé. Chez UST, nous valorisons la diversité et pensons qu'un lieu de travail diversifié crée un avantage compétitif.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

At UST, we use AI technology in our hiring process to verify candidate identity and ensure assessment integrity. This includes confirming that candidates complete interviews and assessments independently, without unauthorized assistance. By applying, you consent to this process. If you require accommodations, please contact [email protected] .

Accommodation

Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process. If you require accommodations at any point during the recruitment process, please let a member of our recruiting team know.

#UST

Skills

Data Analysis, Power BI, Power Query, Snowflake

📌 Lead Business Intelligence Developer (Ontario)
🏢 UST
📍 Ontario