Business Intelligence Analyst — Data Engineering

Medpace’s interview process typically begins with an online aptitude test, followed by a technical interview focusing on SQL queries, Python scripting, and data modeling scenarios. The final HR round assesses cultural fit, communication skills, and motivation. Overall difficulty is moderate, with emphasis on problem‑solving and clear articulation of analytical approaches.

Medpace fosters a collaborative and entrepreneurial culture where learning and mentorship are emphasized. Employees enjoy a balanced work‑life environment with clear career progression paths and opportunities to work on global clinical research projects.

Bachelor's Degree in Business, Life Sciences, Computer Science or related field; Minimum 60% aggregate (or CGPA 6.0/10); Graduation batch 2023‑2026; No active backlogs at the time of joining; Strong analytical and communication abilities.

Round 1: Online Aptitude Test → Round 2: Technical Interview (SQL/Python/BI concepts) → Round 3: HR Interview

Medpace, Inc. is a globally recognized Clinical Contract Research Organization (CRO) that delivers end‑to‑end Phase I‑IV clinical development services for biotechnology, pharmaceutical, and medical‑device companies. Headquartered in Cincinnati, Ohio, Medpace operates in more than 40 countries with a workforce of over 6,500 professionals. The company’s core mission is to accelerate the development of safe and effective therapeutics, leveraging deep scientific expertise, rigorous regulatory knowledge, and a data‑driven approach to streamline clinical trials. In India, Medpace’s presence is anchored in Navi Mumbai, where a vibrant team of scientists, clinicians, and data professionals collaborates to support global projects. The Indian office offers a dynamic, multicultural environment that encourages continuous learning, mentorship, and cross‑functional collaboration. Employees benefit from exposure to international standards, cutting‑edge technologies, and a culture that values innovation, integrity, and patient‑centric outcomes. The Business Intelligence Analyst – Data Engineering role sits at the intersection of analytics and data engineering, partnering closely with the US Data Engineering team to translate complex data into actionable insights. As a key member of the Data Engineering team, you will design, develop, and maintain analytical solutions that empower business stakeholders across the organization. Your work will directly influence strategic decisions, operational efficiencies, and the overall data‑driven culture at Medpace. Key Responsibilities: 1. Work with large, complex data sets to perform deep‑dive analysis and uncover hidden patterns. 2. Design, develop, and maintain metrics, reports, and interactive dashboards that drive informed business decisions. 3. Collaborate with data engineers to implement robust data architecture and ensure data quality for analytical workloads. 4. Identify and communicate critical business insights to senior leadership and functional teams. 5. Lead end‑to‑end enterprise data initiatives, from requirement gathering to delivery and post‑implementation support. 6. Build scalable, reusable analytical solutions using dimensional modeling and data warehousing best practices. 7. Translate business requirements into technical specifications and data models. 8. Conduct data validation, testing, and documentation to guarantee reliability of BI assets. 9. Stay updated with emerging BI tools and technologies, recommending improvements where appropriate. 10. Mentor junior analysts and contribute to knowledge‑sharing sessions within the team. Technical Stack: Advanced SQL, Python (pandas, numpy), Dimensional/Data Modeling, Data Warehousing concepts, BI visualization tools (Tableau, Power BI or similar), ETL processes, and familiarity with cloud data platforms (AWS/GCP/Azure). Growth Path: Starting as a Business Intelligence Analyst, you can progress to Senior Analyst, Data Engineer, and eventually Lead Data Engineer or Analytics Manager, with clear career ladders and continuous up‑skilling opportunities. Why Join Medpace: You will work on high‑impact clinical research data, gain exposure to global pharmaceutical clients, and be part of a collaborative, mentorship‑rich environment. The role offers a blend of technical challenge and business impact, making it an ideal launchpad for fresh graduates eager to build a career in data analytics within the life‑science industry.