Synechron

Synechron

Semantic Model Developers

Mississauga, ON · Senior

Sponsorship not specifiedDetected 23 days ago
PythonSQLSnowflakeAzureCI/CDDevOpsSparkData EngineeringData ScienceData VisualizationResearchCommunicationMentoringUnderwriting

Stay score

odds of building a lasting career here

42Risky
Cap-exempt (no lottery)0
Sponsors this role100
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70

Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Employer immigration record

from this employer's Department of Labor filings

Green-card filing pattern in this occupation

Context, not a finding about this posting: of this employer's 43 green-card filings in this occupation, 100% were for a worker who already held the job.

Third-party placement is common here

85% of this employer's visa filings place the worker at a client company rather than at the employer itself, across 48 clients. Your visa, salary band and layoff exposure would follow the employer of record, not the client.Most common: WELLS FARGO · BANK OF AMERICA · PNC Bank, National AssociationFiles as an H-1B dependent employer.

Green-card follow-through: 54%

Of 26 labor certifications old enough to have been used, 12 expired without the employer filing the next step. Median time from filing to decision: 498 days.100% of their filings were for a worker who already held the job.Only certifications past the 180-day window are counted — recent ones cannot have expired yet.

Files H-1B transfers

104 transfer filings in the last year, covering 104 workers. Median labor-condition decision: 7 days. An employer that already files transfers is one that can take over an existing H-1B.

Sourced from Department of Labor LCA, PERM and prevailing-wage disclosure data. Employer matching is by name, so figures may be split across an employer's legal entities. Absence of a filing means none appears in our copy of the data, not that none exists.

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • 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 17,000+, and has 58 offices in 22 countries within key global markets.
  • Additional Information* The base salary for this position will vary based on geography and other factors.

Responsibilities

  • Design, develop, enhance, and maintain enterprise-grade Power BI semantic models.
  • Develop and support SSAS tabular models and, where applicable, multidimensional OLAP cubes.
  • 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.
  • Design logical and physical data models using dimensional modelling principles.
  • Develop star and snowflake schemas, including fact tables, dimension tables, hierarchies, keys, and relationships.
  • Ensure semantic models maintain consistent business definitions across reports and consuming applications.

Requirements

  • Minimum 10 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
  • Strong experience with SSAS Tabular, Azure Analysis Services, or a comparable enterprise tabular modelling platform.
  • 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.
  • Strong experience in dimensional modelling, including star and snowflake schemas.
  • 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.

Nice to have

  • Experience with SSAS Multidimensional or OLAP cube development is strongly preferred and may be mandatory if the existing environment uses multidimensional cubes.

Compensation

  • With top clients to boast about, Synechron has a global workforce of 17,000+, and has 58 offices in 22 countries within key global markets.
  • The base salary for this position will vary based on geography and other factors.
  • In accordance with law, the base salary for this role if filled within Mississauga, ON is CAD $120k - CAD $130k/year & benefits (see below).

Benefits

  • 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.
  • A higher education certification policy.
  • 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 empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
  • Flexible hybrid policy.

Company info

  • We are At Synechron, we believe in the power of digital to transform businesses for the better.
  • S​ YNECHRON'S 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.
  • Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an

Equal opportunity

  • equal opportunity workplace and is an affirmative action employer.
  • We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company.
Apply directly at Synechron →Create a free account for alerts like thisView Synechron immigration profile

This listing is sourced directly from Synechron's careers page and normalized into a canonical job model.