Director, Analytics Engineering & BI Architecture / Reporting

The businesses of Merck KGaA, Darmstadt, Germany•Boston, MA

2d•$207,600 - $311,400

About The Position

The Director, Analytics Engineering & BI Architecture / Reporting is a pivotal strategic leader who will define and execute the enterprise BI and reporting architecture, enabling data-driven decision-making across the organization. This role encompasses both strategic oversight and hands-on leadership, guiding a team of BI Architects and Analytics Engineers in the design of scalable analytical data models, development of modern cloud-based data layers, and delivery of impactful Tableau dashboards. The Director will collaborate closely with business stakeholders, data engineering, analytics teams, and IT to ensure that reporting solutions are accurate, scalable, and aligned with the evolving needs of the business. In addition to possessing strong technical expertise in cloud data platforms and Tableau, this role requires exemplary leadership skills, including the ability to manage priorities, influence, coach the team, and represent the reporting function across cross-functional initiatives. Success in this role necessitates exceptional architectural judgment, robust stakeholder engagement, and the capability to balance immediate delivery with long-term platform strategy.

Requirements

Bachelor’s degree in Computer Science, Engineering, Analytics, or a related field.
10+ years of experience in data warehousing, analytics engineering, or BI architecture.
5+ years of experience with cloud data platforms such as Redshift, Snowflake, or similar.
5+ years of advanced Tableau development experience.
Strong SQL expertise and proven experience in building scalable analytics solutions.
Experience in leading or mentoring BI or analytics teams.
Ability to communicate openly and share information to foster trust while encouraging constructive debate, making informed decisions, and ensuring shared commitment to outcomes.
Demonstrated willingness to take risks and advocate for ethical practices while prioritizing the needs and experiences of customers and patients in all decisions.
Commitment to setting and achieving ambitious goals while upholding high standards and acting in the best interest of the company.
Uphold ethical standards and demonstrate honesty in all interactions.
Ability to streamline processes to focus on impactful outcomes, adapting quickly to changes.
Proven ability to embrace new ideas, challenge the status quo, and seek innovative solutions while valuing diverse perspectives and treating others with respect and dignity.

Nice To Haves

Experience with GenAI applications in analytics or BI environments.
Proficiency in Python for analytics automation and data workflows.
Familiarity with AWS services and modern data platforms.
Experience in the pharmaceutical, life sciences, or regulated industries.
Tableau certifications and exceptional communication skills.

Responsibilities

Lead, develop, inspire, and manage a high-performing team of BI Architects and Analytics Engineers responsible for enterprise reporting and analytics solutions.
Provide coaching, mentorship, and technical guidance to uphold superior engineering and visualization standards.
Strategically manage team priorities, performance, reporting requests, and resource allocation across diverse business initiatives.
Define and communicate a clear vision and strategy for the team, aligning team goals with organizational objectives to drive innovation and excellence.
Foster a culture of collaboration, continuous learning, and professional growth by identifying training needs, facilitating skill development, and mentoring team members.
Implement performance management processes, including regular feedback, performance reviews, and development plans, to ensure team members meet their potential and contribute effectively
Guide the team through change initiatives, ensuring smooth transitions and maintaining morale during periods of transformation or adaptation.
Promote a culture of innovation by encouraging team members to explore new technologies, methodologies, and processes that enhance productivity and quality
Build strong relationships with internal and external stakeholders to understand their needs and ensure the technical team delivers effective solutions that meet business requirements.
Provide technical direction and support to the team, ensuring alignment with industry best practices and organizational standards.
Define and maintain scalable analytical data models within cloud data platforms such as Redshift and Snowflake.
Design business transformation logic, semantic layers, and data structures optimized for BI and Tableau performance.
Collaborate with data engineering teams to ensure data quality, governance, and consistency across the organization.
Oversee the development of high-quality Tableau dashboards and data products that support critical business and executive decision-making.
Establish development standards, performance optimization protocols, and visualization best practices.
Lead requirements discussions, translating business needs into scalable reporting solutions.
Serve as the reporting team representative in cross-functional meetings and strategic initiatives.
Manage stakeholder expectations effectively while communicating delivery timelines and priorities.
Own the BI architecture across Redshift, Snowflake, and Tableau platforms.
Drive the modernization of reporting capabilities and the adoption of emerging technologies, including AI/ML and GenAI, where appropriate.