Sr. Business Intelligence Architect

Power Transmission and Conveying Solutions•Lititz, PA

About The Position

The Senior Business Intelligence Architect is a hands-on technical leader responsible for shaping Fenner’s data and analytics strategy and supporting the data elements of its Digital Transformation. The role turns complex business challenges into scalable solutions using Azure, Databricks, Power BI, automation, and AI; sets technical direction; strengthens data governance; and coaches the BI team. The architect leads the design and evolution of enterprise BI, data warehouse, and analytics architecture, and provides technical oversight for the daily operation, performance, and reliability of the data warehouse and analytics ecosystem. The role designs data pipelines and models, leads the development of reports, dashboards, and data products, and establishes standards for data quality, security, development, and deployment. Working closely with business and technology leaders and teams across functions, the role identifies opportunities to improve processes and business performance through data, analytics, automation, AI, and digital technologies. The position also champions self-service analytics, supports adoption of new technologies, and promotes a culture of experimentation and continuous improvement.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Data Engineering, Business Intelligence, Analytics, or a related field; an equivalent combination of education and directly relevant experience may be considered.
At least 7 years of progressive experience in business intelligence, data architecture, data engineering, analytics, or enterprise data warehousing.
At least 3 years of experience leading complex BI architecture or data engineering initiatives.
Demonstrated experience designing scalable enterprise data models, data pipelines, and analytics platforms.
Experience mentoring technical professionals and influencing cross-functional stakeholders.
Advanced experience with Microsoft Azure data and analytics services.
Strong experience with Databricks, data lakes, lakehouse architecture, or comparable modern data platforms.
Expert-level SQL development and performance tuning capabilities.
Advanced experience with Power BI, semantic modeling, DAX, data visualization, and enterprise deployment practices.
Experience with Microsoft SQL Server technologies, including SSIS, SSAS, and SSRS.
Strong knowledge of dimensional modeling, data warehouse architecture, ETL/ELT design, and data integration.
Experience implementing data governance, quality, lineage, security, and access-control standards.
Familiarity with DevOps, source control, automated testing, deployment pipelines, and change-management practices.
Ability to establish technical direction and execute against it.
Strong coaching, analytical, conceptual, problem-solving, communication, facilitation, and presentation skills.
Ability to explain complex technical concepts to business stakeholders and influence decisions without direct authority.
Strong organizational skills and ability to manage competing priorities.
Collaborative, customer-focused approach with a commitment to quality and continuous improvement.

Nice To Haves

Master’s degree in a related discipline.
Experience supporting manufacturing, supply chain, finance, or other enterprise business functions.
Experience integrating ERP, manufacturing, financial, and other enterprise systems.

Responsibilities

Lead the design and evolution of Fenner’s enterprise BI, data warehouse, and analytics architecture.
Develop scalable architecture for structured and unstructured data from multiple business systems.
Establish technical roadmaps, architecture standards, and design patterns for data ingestion, transformation, storage, modeling, and visualization.
Evaluate emerging technologies and recommend solutions that improve scalability, reliability, security, and business value.
Ensure analytics architecture aligns with broader IT, cybersecurity, and business strategies.
Provide technical oversight for the daily operation, performance, and reliability of the data warehouse and analytics ecosystem.
Architect and develop data pipelines integrating ERP, manufacturing, financial, commercial, supply chain, and other enterprise data sources.
Design, optimize, and govern ETL and ELT processes across Azure, Databricks, SQL Server, and related platforms.
Lead performance tuning, troubleshooting, root-cause analysis, and platform optimization.
Implement monitoring and controls for accurate, complete, secure, and timely data delivery.
Design dimensional, semantic, and enterprise data models with consistent definitions and high-performance analytics.
Translate business needs into technical requirements, solution designs, and implementation plans.
Lead development of reports, dashboards, data products, and self-service analytics capabilities.
Establish Power BI development standards for data models, DAX, security, performance, usability, and deployment.
Partner with business and technology leaders to establish data ownership, stewardship, governance, and accountability.
Define and enforce standards for data quality, documentation, lineage, access, retention, and security.
Ensure compliance with internal requirements, applicable regulations, and data-protection practices.
Develop testing and validation frameworks for reliable and consistent analytics solutions.
Ensure adherence to configuration management, change control, release management, and development standards.
Mentor BI Analysts, data professionals, application teams, and business users in data and BI best practices.
Lead architecture reviews and guide complex technical and functional decisions.
Promote consistent development practices, reusable solutions, and knowledge sharing.
Communicate technical concepts clearly to technical and nontechnical audiences.
Drive the data elements of Fenner’s Digital Transformation initiative.
Partner with business leaders to understand, challenge, and redesign business processes rather than simply automate existing practices.
Identify opportunities to improve business performance using data, analytics, automation, AI, and digital technologies.
Turn business problems into practical digital solutions from idea and architecture through implementation and adoption.
Bridge business and technology by explaining possibilities and translating opportunities into actionable solutions.
Champion self-service analytics and data-driven decision-making while maintaining appropriate architecture, governance, and standards.
Support adoption of new technologies through education, demonstrations, prototyping, and influence.
Foster curiosity, experimentation, and continuous improvement around data and digital technology.
Collaborate with Finance, Operations, Supply Chain, Commercial, Quality, HR, and other functions to understand processes and analytics needs.
Identify opportunities to improve data capture, automate manual processes, and accelerate access to actionable information.
Lead discovery sessions and translate business challenges into prioritized analytics use cases.
Measure BI solution effectiveness and adoption and recommend improvements.
Support Lean Continuous Improvement through data-driven analysis and scalable digital solutions.
Perform additional responsibilities as assigned and model Fenner Precision Polymers’ Values and Behaviors.

Benefits

Competitive pay with annual bonus potential.
Day-one Medical, Dental, and Vision coverage.
401(k) match immediately vested with the company.
100% Paid Parental Leave.
Michelin Stock Purchase Program.
Michelin Tire Rebate Program.
Career development in a global organization.
Personal development and career progression.
A culture built on trust, respect, and empowerment.
Opportunity for advancement, greater responsibility, strategic influence, and leadership within the IT team.