EMD Serono is hiring a Manager, Analytics Engineering & BI Architecture. In this hands-on technical leadership role, you will architect analytical data models, design scalable cloud-based data layers, and deliver high-impact Tableau dashboards that directly support business decision-making. You will be responsible for the semantic and extract layers powering Tableau and for translating complex stakeholder needs into intuitive, performance-optimized analytics products.
What You'll Do
- Design, build, and maintain analytical data models in Amazon Redshift and Snowflake to support enterprise-grade BI and advanced analytics use cases.
- Define and implement business transformation logic, conformed dimensions, fact tables, and semantic layers optimized for Tableau performance and scalability.
- Partner with data engineering and upstream teams to ensure data quality, consistency, and governance across sources.
- Architect and develop high-quality Tableau dashboards and data products, incorporating best practices in UX, performance optimization, and storytelling.
- Build and maintain Tableau extracts and live connections, ensuring reliability, refresh efficiency, and security compliance.
- Act as the technical authority for Tableau on-prem and cloud development standards, data source design, and visualization best practices.
- Lead requirements discovery sessions with stakeholders to translate business questions into scalable analytical solutions.
- Serve as the primary point of contact for complex analytical questions, ad-hoc requests, and data interpretation.
- Balance short-term business needs with long-term architectural integrity and platform strategy.
- Manage and evolve the Redshift and Snowflake BI data layers, ensuring best practices around performance, security, and cost efficiency.
- Continuously evaluate and adopt new BI, analytics, and data-warehouse tools as the platform modernizes.
- Mentor and guide other BI resources by modeling strong engineering discipline and analytical thinking.
What We're Looking For
- A Bachelor’s degree in Computer Science, Engineering, Analytics, or a related technical discipline (or equivalent practical experience).
- 5+ years of experience in data warehousing, BI, or analytics engineering roles.
- 5+ years of hands-on experience designing and implementing data models in cloud-based data warehouses like Redshift or Snowflake for analytics and BI use cases.
- 5+ years of advanced Tableau (Tableau Cloud) development experience, including dashboard architecture, performance tuning, and complex data sources.
- Strong SQL expertise, including writing and optimizing complex queries for analytical workloads.
Nice to Have
- Experience applying GenAI techniques within BI and Tableau ecosystems to augment reporting, enable natural-language exploration, and enhance user experience.
- Basic Python skills for data manipulation, analytics automation, and integration with Tableau workflows.
- Experience with Tableau Prep or similar data preparation tools.
- Working knowledge of AWS services (e.g., Glue, Redshift, IAM) and modern data platforms.
- Exposure to pharmaceutical, life sciences, or regulated data environments.
- Experience collaborating with cross-functional and geographically distributed teams, including external vendors.
- Tableau Desktop and/or Server certifications (Developer or Administrator).
- Strong communication skills with the ability to explain complex technical concepts to non-technical audiences.
Technical Stack
- Amazon Redshift, Snowflake, Tableau, Tableau Cloud, SQL
- AWS, GenAI, Python, Tableau Prep
Team & Environment
You will partner closely with business stakeholders, data engineering, analytics teams, and the IT team.
EMD Serono is dedicated to innovating with science and technology to enrich people’s lives. We dream big and are passionate about caring for our rich mix of people, customers, patients, and planet. We offer a diverse, inclusive, and flexible working culture.
