Business Intelligence Analyst

Working at Real Chemistry and in the healthcare industry isn’t just a job for us. We got into this field for different reasons, but we all stay for the same reason – to uncover insights, make meaningful connections, infuse creativity, and improve the patient experience by transforming healthcare through AI and ideas.

Real Chemistry creates the world around modern therapies with over 2,000 talented professionals, and for the last 20+ years has, carved out its space at the intersection between healthcare, marketing and communications, data & AI, and the people at the heart of it all. We work with the top 30 pharma and biotech companies and are built for uncommon collaboration—we believe we are best together, bring together experts from a wide range of disciplines collaborate without barriers under a single, unified mission: to transform what healthcare is to what it should be. This one-of-a-kind model allows us to work in a way that better reflects how people experience healthcare—all with the intent to transform healthcare from what it is to what it should be. But we can’t do it alone – you in?

Real Chemistry is looking for a Business Intelligence Analyst join our growing team!  

Position Summary

Real Chemistry is looking for a resourceful, energetic individual to join our growing business intelligence team. We are looking for an experienced Senior Data Analyst to help drive the technical vision and build and manage data-driven business intelligence products that enable streamlined decision-making for our clients. As a part of the Business Intelligence team, you will partner closely with our Client Success, Data Engineering, Analytics, and User experience teams to build intuitive and well-designed dashboards and automated reporting solutions.

This is a hybrid role, based in any of our US offices—including New York City, Boston, Chicago, Carmel, or San Francisco—or remotely within the US, depending on team and business needs.

What you’ll do:

Data Discovery and Data Modeling

• Conduct thorough data discovery, understand and document data sources, adhering to data quality and data governance policies.

• Collaborate with stakeholders across Real Chemistry to understand business requirements and translate them into data models that effectively capture data and enable measurement.

• Design and implement data models using Databricks Delta Lake, ensuring data integrity, consistency, and scalability.

• Document data models and data governance processes to maintain knowledge transfer and ensure data quality standards.

Data Engineering and Transformation

• Understand key data engineering concepts and partner with data engineers to develop and implement data pipelines using Databricks

• Collect, process, and transform data from various sources.

• Automate and streamline ELT processes, ensuring data quality and consistency.

• Implement data quality checks and data cleansing techniques to ensure data accuracy and consistency.

• Optimize data pipelines for performance and scalability to handle large volumes of data.

Data Visualization and Insights

• Develop and maintain client and internal facing data visualizations and dashboards using tools like Tableau, Power BI and Databricks Dashboards/Genie

• Create interactive dashboards that provide business users with self-service access to data insights.

• Communicate data insights effectively to stakeholders, translating technical concepts into clear and actionable recommendations.

This position is a perfect fit for you if: 

• Our Company values – Best Together, Impact-Obsessed, Excellence Expected, Evolve Always and Accountability with an “I” – really speak to you. 

• You are adaptable, resilient, and OK with adjusting your scope, responsibilities, and focus as we grow. When things change, so do we. We’re always evolving. 

• You are proactive, driven, and resourceful with strong prioritization skills and a desire to dive into the data. 

• You are highly organized self-starter, able to work independently and under tight deadlines. 

What you should have:  

• 2+ years in a data analyst, data analytics or business intelligence role

• 2+ years of SQL and/or Python experience, specifically to write complex, highly optimized queries across large volumes of data.

• 2+ Expe