Sr. Business Intelligence Architect

Fenner Precision Polymers•Lititz, PA

About The Position

The Senior Business Intelligence Architect is a hands-on technical leader who shapes Fenner’s data and analytics strategy and supports the three pillars of its digital transformation: Tools, Data, and People. The role turns complex business challenges into scalable solutions using Azure, Databricks, Power BI, automation, and AI, while setting technical direction, strengthening data governance, and coaching the BI team. The position leads the design and evolution of enterprise BI, data warehouse, and analytics architecture; provides technical oversight of the data warehouse and analytics ecosystem; and guides the development of data pipelines, models, reports, dashboards, data products, and self-service analytics. It also establishes standards for data quality, security, governance, testing, deployment, and development practices. Working across business functions and technology teams, the Senior Business Intelligence Architect identifies opportunities for process improvement and digital solutions, translates business needs into practical analytics work, and promotes data-driven decision-making and adoption of new technologies. The role also mentors BI and data professionals and supports continuous improvement.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Data Engineering, Business Intelligence, Analytics, or a related field, or an equivalent combination of education and directly relevant experience.
Seven or more years of progressive experience in business intelligence, data architecture, data engineering, analytics, or enterprise data warehousing.
At least three 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, and problem-solving skills.
Excellent communication, facilitation, and presentation skills, including the ability to explain complex technical concepts to business stakeholders.
Demonstrated ability to influence decisions without direct authority.
Strong organizational skills and ability to manage competing priorities.
Collaborative, customer-focused approach and 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 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.
Align analytics architecture with broader IT, cybersecurity, and business strategies.
Provide technical oversight for 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 that provide consistent definitions and high-performance analytics.
Translate business needs into technical requirements, solution designs, and actionable implementation plans.
Lead development of advanced reports, dashboards, data products, and self-service analytics capabilities.
Establish Power BI development standards covering data models, DAX, security, performance, usability, and deployment.
Ensure analytics solutions provide clear, meaningful, and actionable business insights.
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.
Serve as a senior technical resource for BI analysts, data professionals, application teams, and business users.
Mentor team members in data modeling, pipeline development, visualization, testing, documentation, 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 to build trust in data and analytics.
Drive the data elements of Fenner’s digital transformation initiative.
Partner with business leaders to understand, challenge, and redesign business processes rather than simply automating existing processes.
Identify opportunities to use data, analytics, automation, AI, and digital technologies to improve business performance.
Turn business problems into digital solutions from idea and architecture through implementation and adoption.
Bridge business and technology by helping users understand possibilities and translating opportunities into actionable solutions.
Champion self-service analytics and data-driven decisions while maintaining appropriate architecture, governance, and standards.
Drive 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 ways 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.
Immediately vested 401(k) match.
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 and greater responsibility, strategic influence, and leadership within the IT team.