Sr. Manager, Analytics Engineering & BI Architecture
EMD Serono, Inc. · Boston, MA · 3 wk ago
Analyst$138k–$207k/yrFull-time
Key Responsibilities
- Data Architecture & Modeling
- Design, build, and maintain analytical data models in Amazon Redshift and Snowflake
- 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
- Advanced Tableau Development & Visualization
- Architect and develop high-quality Tableau dashboards and data products that go beyond standard reporting
- Incorporate 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
- Stakeholder Partnership & Delivery
- 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 interpretation of data
- Balance short-term business needs with long-term architectural integrity and platform strategy
- Platform Ownership & Modernization
- 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
- Minimum Qualifications
- 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 warehouse (such as Redshift, Snowflake, Databrick, etc.) 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
- Preferred Qualifications
- 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
- Health insurance
- Paid time off (PTO)
- Retail contributions
- Other prequisites
Who You Are
Pay Range
Pay Range for this position: $137,800 - 206,600
The actual compensation offered will be determined by factors such as location, level of experience, education, skills, and other job-related factors.
Benefits
For more information click here.