Associate Consultant – Data Warehousing, BI & Reporting

Purpose of Job

As an Associate consultant, you will be a key contributor, creating and driving impactful analytics solutions that optimize commercial performance for our life sciences clients. You will leverage your strong analytical mindset and skills to deliver actionable insights, solve complex business problems, and apply advanced analytical techniques, including modeling and simulation, to inform key business decisions and drive positive commercial outcomes. You will also have the opportunity to mentor and train junior team members.

We'll trust you to:

• Business Requirements to BI Solutions: Translate client needs into technical specifications and lead the design, development, and deployment of BI solutions using Tableau, Power BI, and Excel-based reporting.
• Advanced Analytics & Visualization: Apply data visualization best practices and advanced analytical techniques to build insightful, interactive, and actionable dashboards that support decision-making.
• Methodologies & Quality Standards: Utilize agile and other delivery approaches while embedding QA reviews, mid-development validations, and unit testing to ensure reliability of BI solutions.
• Client & Stakeholder Engagement: Collaborate with project leads and clients to refine reporting needs, provide updates, and present results through compelling data stories and visualizations.
• Team Collaboration & Mentoring: Manage and support BI/reporting developers, mentor junior associates on visualization techniques, and ensure smooth task execution across teams.
• Communication of Insights: Deliver clear, visually driven presentations and dashboards tailored to stakeholders.
• Continuous Innovation in BI: Stay updated on new Power BI/Tableau features, adopt emerging visualization trends, and continuously optimize dashboards for better usability and impact.

You'll need to have:

• 2–4 years of relevant experience in Power BI/Tableau - reporting, and analytics projects (consulting experience preferred).
• Exposure to medium-to-large scale technology/BI solution delivery environments.
• Ability to work effectively in global, cross-functional teams with flexibility to support multiple projects.
• Technical Skills (Must Have)
• Hands-on experience with Power BI and/or Tableau for dashboards, reports, and interactive visualizations.
• Strong expertise in SQL for querying, data analysis, and report development.
• Familiarity with data pipelines, data quality, and DBMS fundamentals.
• Proficiency in MS Excel and familiarity with modern BI platforms.
• Understanding of data modeling concepts, BI data management best practices, and analytics methodologies.
• Basic exposure to cloud BI environments (Azure, AWS, or GCP) and distributed data systems.
• Foundational programming knowledge in Python or similar scripting languages (for analytics/automation).

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.