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 cutting-edge 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

📌 Data and Modelling Engineer (Markham)
🏢 Amphenol
📍 Markham