Data and Modelling Engineer

Amphenol Corporation; Markham; Hybrid; CAD 125,000 - 135,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Vacation

Sick leave

Paid holidays

Life insurance

Short/Long-term disability

Pension plan

Job summary

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, seeks a Data and Modeling Engineer to translate business requirements into reliable data models and KPI definitions, and to develop Power BI dashboards.

You will collaborate with the Data Architect, Data Engineer, and business stakeholders to build strong connections between enterprise data and decision-making, and participate in governance, security, and platform operations. Markham, hybrid work model.

Qualifications

• BS in Information Systems, Computer Science, Engineering, Business, or related field.
• 5 years of relevant experience in data modeling, business intelligence, analytics engineering, or data engineering.
• Strong SQL skills and practical experience with dimensional modeling, fact and dimension design, and data reconciliation.
• Hands-on Power BI, DAX, and data visualization expertise.
• Ability to translate business requirements into clear data definitions, KPI calculations, and analytical solutions.
• Experience with ETL/ELT, data warehouses, data lakes, and data quality controls.
• Experience implementing reporting security and maintaining technical and business documentation.

Responsibilities

• Work with business stakeholders and the existing data peers to understand business processes, reporting requirements, and analytical priorities.
• Translate business requirements into documented data definitions, calculation rules, reporting specifications, and acceptance criteria.
• Establish and maintain a common business glossary and KPI catalog, including metric definitions, calculation logic, data sources, owners, and reporting frequency.
• Resolve differences in business definitions across functions and locations and obtain agreement from the relevant business owners.
• Design, develop, and maintain analytical data models and Power BI semantic models that support enterprise reporting and self-service analytics.
• Define fact tables, dimensions, relationships, data granularity, and historical tracking requirements.
• Develop reusable DAX measures and consistent calculation logic to support approved business KPIs.
• Work with the Data Architect and Data Engineer to transform source data into reliable, business-ready datasets.
• Optimize model performance, maintainability, and reuse across business functions and global locations.
• Develop and maintain Power BI dashboards and reports for operational monitoring, management reporting, and business analysis.
• Present business information clearly, with appropriate filters, drill-down capabilities, and consistent reporting standards.
• Validate report results against source systems and agreed business definitions.
• Coordinate user acceptance testing, document business sign-off, and support report deployment and user adoption.
• Monitor and improve report performance, refresh reliability, and usability.
• Implement data validation and reconciliation checks to support accurate reporting.
• Investigate data discrepancies and resolve root causes.
• Apply access controls, row-level security, and data classification requirements in line with standards.
• Maintain documentation covering data mappings, model relationships, KPI calculations, source-to-report lineage, and access rules.
• Provide documentation and evidence to support audit readiness and control reviews.

Skills

Power BI

SQL

DAX

Data Modeling

KPI Definition

Data Governance

Education

BS in Information Systems / CS / Engineering

Tools

Power BI Desktop

Power Query

ETL/ELT

Job description

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets. Amphenol Corporation is one of the world’s largest designers and manufacturers of electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive global presence in research and development, manufacturing, and sales. We design and manufacture a wide range of innovative connectors as well as cable assemblies for diverse applications including server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive.

Amphenol is one of the largest manufacturers of interconnect products in the world. The Company designs, manufactures and markets electrical, electronic and fiber optic connectors, coaxial and flat-ribbon cable, and interconnect systems. The primary end markets for the Company's products are communications and information processing markets, including cable television, cellular telephone and data communication and information processing systems; aerospace and military electronics; and automotive, rail and other transportation and industrial applications.

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets. Amphenol Corporation is one of the world’s largest designers and manufacturers of electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive global presence in research and development, manufacturing, and sales. We design and manufacture a wide range of innovative connectors as well as cable assemblies for diverse applications including server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive.

Amphenol High Speed Products Group is the market leader for high-speed IO products. Our products help to enable the electronics revolution and remain a key enabler for all the major Tier 1 OEMs globally.

POSITION SUMMARY
We are seeking a Data and Modeling Engineer to join our IT Applications team. This role will focus on translating business requirements into reliable data models, consistent KPI definitions, reusable semantic models, and effective Power BI dashboards and reports. The engineer will work closely with business stakeholders, the Data Architect, and the existing Data Engineer to build a strong connection between enterprise data and business decision-making.
The role will also participate in structured knowledge transfer and cross-training to strengthen team capabilities and provide data modeling, reporting, and platform operations.

RESPONSIBILITIES

Business Requirements and KPI Definition

• Work with business stakeholders and the existing data peers to understand business processes, reporting requirements, and analytical priorities.
• Translate business requirements into documented data definitions, calculation rules, reporting specifications, and acceptance criteria.
• Establish and maintain a common business glossary and KPI catalog, including metric definitions, calculation logic, data sources, owners, and reporting frequency.
• Resolve differences in business definitions across functions and locations and obtain agreement from the relevant business owners.

Data and Semantic Modeling

• Design, develop, and maintain analytical data models and Power BI semantic models that support enterprise reporting and self-service analytics.
• Define fact tables, dimensions, relationships, data granularity, and historical tracking requirements.
• Develop reusable DAX measures and consistent calculation logic to support approved business KPIs.
• Work with the Data Architect and Data Engineer to transform source data into reliable, business-ready datasets.
• Optimize model performance, maintainability, and reuse across business functions and global locations.

Power BI Dashboards and Reporting

• Develop and maintain Power BI dashboards and reports for operational monitoring, management reporting, and business analysis.
• Present business information clearly, with appropriate filters, drill-down capabilities, and consistent reporting standards.
• Validate report results against source systems and agreed business definitions.
• Coordinate user acceptance testing, document business sign-off, and support report deployment and user adoption.
• Monitor and improve report performance, refresh reliability, and usability.

Data Quality, Security, and Governance

• Implement data validation and reconciliation checks to support accurate and consistent reporting.
• Investigate data discrepancies and work with the appropriate owners to resolve root causes.
• Apply access controls, row-level security, and data classification requirements in line with standards established by the Data Architect and security team.
• Maintain documentation covering data mappings, model relationships, KPI calculations, source-to-report lineage, and access rules.
• Provide documentation and evidence to support audit readiness and control reviews.

QUALIFICATIONS

• BS in Information Systems, Computer Science, Engineering, Business, or related field.
• 5 years of relevant experience in data modeling, business intelligence, analytics engineering, or data engineering.
• Strong SQL skills and practical experience with dimensional modeling, fact and dimension design, and data reconciliation.
• Hands-on experience developing Power BI semantic models, DAX measures, Power Query transformations, dashboards, and reports.
• Ability to translate business requirements into clear data definitions, KPI calculations, and analytical solutions.
• Understanding of ETL/ELT processes, data warehouses, data lakes, and data quality controls.
• Experience implementing reporting security and maintaining technical and business documentation.
• Strong communication skills and the ability to collaborate with business and technical teams across global locations

ATTRIBUTES

• Strategic thinking and enterprise data modeling
• Strong analytical and problem-solving skills
• Hand-on technical expertise
• Ownership and accountability
• Execution and results orientation
• Priority and time management
• Collaboration and teamwork

Position: Data and Modeling Engineer
Location: Markham/ Hybrid
Reports To: Director of IT Applications

Come join the Amphenol family!

The base salary range for this position is $125,000- $135,000 annually. In determining the rate of pay, Amphenol considers a variety of nondiscriminatory factors, including but not limited to geographic location, relevant industry experience, qualifications, skills, and education. It would be rare for an individual to be hired at or near the top of the range for a given role. Base salary is one facet of Amphenol's total rewards package which includes participation in our comprehensive benefits program with medical, dental, and vision benefits, vacation, sick leave, paid holidays, life insurance, short/long term disability, and membership in our Defined Contribution Pension Plan.

Amphenol Corporation is proud of our reputation as an excellent employer. Our main focus is to provide the highest level of support and responsiveness to both our employees and our customers. Amphenol Corporation offers the opportunity for career growth within a global organization. We believe that Amphenol Corporation is unique in that every employee, regardless of his or her position, has the ability to positively impact the business.

Amphenol Corporation is proud of our reputation as an excellent employer. Our focus is to provide the highest level of support and responsiveness to both our employees and our customers, the world's largest technology companies. Amphenol Corporation offers the opportunity for career growth within a global organization. We believe that Amphenol Corporation is unique in that every employee, regardless of his or her position, has the ability to positively impact the business.

Amphenol is an “Equal Opportunity Employer” - Minority/Female/Disabled/Veteran/Sexual Orientation/Gender Identity/National Origin. For additional company information please visit our website at https://www.amphenol-cs.com/