Data Solutions Architect

KB Signaling delivers unparalleled end-to-end wayside and onboard conventional signaling platforms and solutions, supporting our Control, Command, and Signaling (CCS) global business unit. A trailblazer, we are driven to provide the best solutions for improved safety, performance, and lower overall operating cost for today’s transit and freight railway systems and operators in North America and beyond. Our team is fueled by innovation and grounded in solid values, like giving back to the communities where we do business and embracing sustainability to help protect our planet. KB Signaling is part of a global, high-tech company that will challenge you and help you grow. Discover your potential.

KB Signaling Inc. is an Equal Employment Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

About Us: KB Signaling, part of the Knorr-Bremse Group, is a leading provider of control, command, and signaling technologies for rail applications. We are building a modern data analytics foundation to enable smarter, faster decisions across our business.

Job Summary: We are seeking a hands-on data leader to design, build, and operate our analytics platform from the ground up. You will integrate SAP S/4HANA and auxiliary systems into a governed data warehouse (Snowflake or Microsoft Fabric), establish data quality and governance standards, and deliver trusted Power BI dashboards for financial and operational insights.

Key Responsibilities:

• Platform Ownership: Select and implement our cloud data warehouse (Snowflake or Microsoft Fabric) and supporting tools for ingestion, transformation, and orchestration.
• SAP Integration: Design and implement repeatable ingestion of SAP S/4HANA FI/CO data (via ODP/CDS/SLT or 3rd-party connectors) and auxiliary sources.
• Data Modeling: Create conformed dimension/reference tables, star schemas, and semantic layers for analytics and reporting.
• Governance & Quality: Implement catalog, lineage, and data quality checks; define SLAs, security (including row-level security), and naming/versioning standards.
• BI Delivery: Develop and maintain Power BI datasets and dashboards, including measures, calculation groups, and refresh strategies.
• Collaboration: Translate business requirements into data products; mentor analysts and engineers; document patterns and best practices.
  
  

Qualifications:

• 7 years building analytics platforms in Azure or AWS; hands-on experience with Snowflake or Microsoft Fabric/Synapse.
• Strong SQL and dimensional modeling (Kimball/star schema); DAX and Power Query/M proficiency for Power BI.
• Experience integrating SAP S/4HANA (FI/CO focus) into a cloud data warehouse; familiarity with SAP tables/domains.
• Knowledge of ELT/CDC tools (e.g., Fivetran, Matillion, Qlik Replicate, or SAP-native tools) and orchestration (ADF/Fabric pipelines or Airflow).
• Exposure to data governance (Purview, Collibra, or equivalent) and data quality frameworks.
• CI/CD for data (Git, automated tests, deployment pipelines).
• Nice to have: dbt or Fabric equivalent, Python for data engineering, experience with Fabric OneLake.
  
  

Why Join Us?

• Greenfield opportunity: Build our analytics foundation from scratch.
• Strategic impact: Enable data-driven decisions across finance and operations.
• Modern stack: Work with SAP S/4HANA, Snowflake or Microsoft Fabric, and Power BI.
  
  

The anticipated salary range for candidates who will work in West Henrietta is $65,100 to $97,700 per year. The final pay offered to a successful candidate will be dependent on several factors that may include but are not limited to the type and years of experience within the job, the type of years and experience within the industry and education. KB Signaling is a multi-state employer, and this pay scale may not reflect positions that work in other states or locations. Provided they meet all eligibility requirements under the applicable plan documents, employees (and their eligible dependents) will be eligible to enroll in group healthcare plans that offer medical, dental, vision, and basic life and disability insurance. Employees also will be able to enroll in our company’s 401k plan. Employees will also receive 120 hours of vacation leave and 40 hours of Personal Paid Absence every year. Employees will also enjoy 12 paid holidays, and 1 floating holiday throughout the calendar year, subject to relevant terms outlined in the employee handbook. 6 weeks of paid parental leave will also be available for use. Requirements for these benefits will be controlled by applicable plan documents and policies. Employees working on federal contracts covered by the Federal Paid Sick Leave requirements will be notified and will receive benefits consistent and compliant with the FPSL requirements. Hired applicant will be able to purchase company stock, subject to the relevant plan documents and annual bonuses based on achievement of certain metrics of up to 4% of annual salary. This is intended to provide a general description of benefits and other compensation and is not a substitute for applicable plan documents or company policies. Applications for this position are accepted on an ongoing basis