Semantic Model Developers

We are

At Synechron we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechrons progressive technologies and optimization strategies span end-to-end Artificial Intelligence Consulting Digital Cloud & DevOps Data and Software Engineering servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization from Artificial Intelligence and Blockchain to Data Science models Digital Underwriting mobile-first applications and more. Over the last 20 years our company has been honored with multiple employer awards recognizing our commitment to our talented teams. With top clients to boast about Synechron has a global workforce of 17000 and has 58 offices in 22 countries within key global markets.

Our challenge

Semantic Model Developer will design develop optimize and maintain enterprise-grade semantic models analytical cubes reports and dashboards. The successful candidate will have deep expertise in Power BI SSAS Tabular DAX SQL dimensional modelling and data warehousing along with demonstrated experience delivering solutions in banking or financial services. This role will involve translating complex business and financial-reporting requirements into scalable governed and high-performing analytical solutions.

Additional Information*

The base salary for this position will vary based on geography and other accordance with law the base salary for this role if filled within Mississauga ON is CAD $120k CAD $130k/year & benefits (see below).

The Role

Responsibilities:

• Semantic Model and Cube Development
• Design develop enhance and maintain enterprise-grade Power BI semantic models.
• Develop and support SSAS tabular models and where applicable multidimensional OLAP cubes.
• Translate banking and financial-reporting requirements into scalable analytical models.
• Design reusable model components including tables relationships measures calculation logic hierarchies perspectives and business-friendly metadata.
• Develop complex DAX measures calculated columns calculation groups and time-intelligence solutions.
• Develop and maintain MDX calculations and cube components where multidimensional SSAS is used.
• Create governed and reusable semantic layers that support multiple reports dashboards analytical products and business functions.
• Assess existing cube and semantic-model designs and recommend improvements to scalability maintainability usability and performance.
• Data Modelling and Architecture
• Design logical and physical data models using dimensional modelling principles.
• Develop star and snowflake schemas including fact tables dimension tables hierarchies keys and relationships.
• Work with enterprise data warehouses data marts operational data stores and cloud-based data platforms.
• Define appropriate model granularity aggregation strategies relationship behaviour and data-access patterns.
• Assist with modernizing legacy cubes and reporting models into Power BI or modern tabular semantic models.
• Ensure semantic models maintain consistent business definitions across reports and consuming applications.
• Maintain clear data lineage between source systems data-transformation layers semantic models and reports.
• Power BI Development
• Develop Power BI reports and dashboards based on governed semantic models.
• Build complex and reusable DAX measures to support financial operational risk regulatory and management reporting.
• Use Power Query and M to clean transform and integrate data from multiple sources.
• Configure import DirectQuery composite or live-connection solutions based on business and technical requirements.
• Implement drill-down drill-through hierarchies bookmarks tooltips and other analytical capabilities where required.
• Publish and manage semantic models and reports within Power BI Service.
• Configure and troubleshoot scheduled refreshes gateways connections permissions and deployment activities.
• Support controlled promotion of models and reports across development testing UAT and production environments.
• Performance Optimization
• Optimize semantic models DAX calculations SQL queries relationships and data-refresh processes.
• Analyze slow-running reports and queries and identify model DAX storage or source-system bottlenecks.
• Improve model performance through appropriate schema design cardinality management aggregations partitioning incremental refresh and efficient calculation logic.
• Optimize SQL queries stored procedures views indexes and data-extraction processes supporting semantic models.
• Monitor model size refresh duration query response time capacity usage and report performance.
• Resolve production issues related to model processing refresh failures data latency security and report performance.

Requirements:

• Minimum 10 years of overall experience in business intelligence data warehousing analytics data modelling or reporting development.
• Demonstrated professional experience within the banking or financial-services industry.
• Strong hands-on experience designing and developing enterprise Power BI semantic models.
• Strong experience with SSAS Tabular Azure Analysis Services or a comparable enterprise tabular modelling platform.
• Experience with SSAS Multidimensional or OLAP cube development is strongly preferred and may be mandatory if the existing environment uses multidimensional cubes.
• Advanced expertise in DAX including complex measures filter context row context time intelligence and performance optimization.
• Strong working knowledge of MDX particularly where legacy or multidimensional cubes are involved.
• Advanced SQL and T-SQL development skills.
• Strong experience in dimensional modelling including star and snowflake schemas.
• Experience developing fact tables dimensions hierarchies measures relationships and calculation logic.
• Strong Power BI Desktop and Power BI Service experience.
• Experience with Power Query and M-based data transformation.
• Experience with enterprise data warehouses and data marts.
• Experience with ETL or ELT technologies such as SSIS Azure Data Factory or equivalent platforms.
• Experience implementing data security including row-level security and role-based access.
• Experience optimizing models DAX SQL refresh processes and report performance.
• Strong data-validation reconciliation testing and troubleshooting capabilities.
• Ability to translate business requirements into robust technical and data-model designs.
• Strong stakeholder-management communication and documentation skills.
• Must be located in Canada or authorized and available to work in Canada subject to the clients engagement requirements.

Preferred but not required:

• Microsoft Power BI certification such as PL-300 or a comparable current certification.
• Microsoft SQL Server data-management Azure or Microsoft Fabric certification.
• Experience with Azure SQL Azure Data Factory Azure Data Lake Synapse Analytics or Microsoft Fabric.
• Experience with XMLA endpoints tabular model metadata or model-management tools.
• Familiarity with Tabular Editor DAX Studio Performance Analyzer SQL Profiler or equivalent diagnostic tools.
• Experience with calculation groups incremental refresh composite models aggregations and large enterprise datasets.
• Experience migrating SSAS cubes or legacy reporting platforms to Power BI semantic models.
• Experience working with CI/CD practices deployment pipelines source control and environment promotion.
• Experience with Python Alteryx Apache Spark or similar data-engineering and analytics technologies.
• Experience leading technical design sessions or mentoring BI and Power BI developers.
• Experience working within a highly governed regulated or audit-controlled reporting environment.

We offer:

• A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
• 15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave(floating days and sick days).
• A comprehensive insurance plan including medical dental vision life insurance and long-term disability.
• Flexible hybrid policy.
• RRSP with employers contribution up to 4%.
• A higher education certification policy.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
• Cutting edge projects at the worlds leading tier-one banks financial institutions and insurance firms.
• A truly diverse fun-loving and global work culture.

SYNECHRONS DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity Equity and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger successful businesses as a global company. We encourage applicants from across diverse backgrounds race ethnicities religion age marital status gender sexual orientations or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements mentoring internal mobility learning and development programs and more.

All employment decisions at Synechron are based on business needs job requirements and individual qualifications without regard to the applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice