Analyst Data Role

Medpace’s interview process typically begins with an online aptitude test, followed by a technical interview focused on SQL queries, Python scripting, and data‑modeling scenarios. The final HR round assesses cultural fit, communication skills, and career aspirations. Candidates should be prepared with real‑world BI project examples and clear explanations of their analytical approach.

Medpace promotes a collaborative and inclusive culture where employees are encouraged to innovate and take ownership of projects. The company offers structured career paths, regular learning sessions, and a healthy work‑life balance supported by flexible work arrangements and wellness initiatives.

Bachelor's degree in Business, Life Sciences, Computer Science, Information Technology or related field; 0‑5 years of relevant experience; minimum 60% aggregate or CGPA 6.5/10; no active backlogs at the time of joining; eligible batch years 2022‑2025; strong analytical and communication abilities.

Round 1: Online Aptitude & Logical Reasoning Test → Round 2: Technical Interview (SQL, Python, Data Modeling, BI concepts) → Round 3: HR Interview (culture fit, motivations, salary expectations)

Medpace is a global, full‑service clinical contract research organization (CRO) headquartered in Cincinnati, Ohio. With more than 6,000 employees across 40+ countries, the company partners with biopharma and medical‑device firms to deliver end‑to‑end clinical development services from Phase I through Phase IV. Medpace’s core strength lies in its scientific rigor, regulatory expertise, and deep therapeutic knowledge across oncology, cardiology, metabolic disease, neurology, infectious diseases and more. Over the past three decades, Medpace has helped launch numerous life‑saving therapies, earning multiple industry awards and consistent recognition from Forbes and Life Science Leader magazine. The Data Engineering team at Medpace is expanding rapidly, aiming to embed a data‑driven culture throughout the organization. As a Business Intelligence Analyst – Data Engineering, you will serve as a bridge between business stakeholders and the technical data team, turning raw data into actionable insights that influence strategic and operational decisions. You will collaborate closely with the US‑based Data Engineering group, contributing to enterprise‑wide data initiatives, building robust data pipelines, and delivering intuitive visualizations. Key Responsibilities: 1. Design, develop, and maintain SQL queries and stored procedures for reporting and analytics. 2. Write Python scripts for data extraction, transformation, and loading (ETL) across multiple sources. 3. Create dimensional models and data‑warehouse schemas to support scalable analytics. 4. Build interactive dashboards and reports using tools like Tableau or Power BI. 5. Partner with data engineers to define data architecture and ensure data quality. 6. Conduct deep‑dive analyses to uncover business insights and recommend actionable strategies. 7. Document data lineage, business logic, and reporting standards. 8. Participate in agile sprint planning, providing estimates and status updates. 9. Mentor junior analysts and contribute to knowledge‑sharing sessions. 10. Stay updated on emerging BI technologies and best practices, proposing improvements where relevant. Tech Stack: SQL, Python, Dimensional Modeling, Data Warehousing, Tableau/Power BI, Git, AWS (or Azure) data services. Growth Path: Starting as an Analyst, you can progress to Senior Analyst, Data Engineer, BI Lead, and eventually to Data Architecture or Analytics Manager roles, with exposure to global projects and cross‑functional leadership opportunities. Why Join Medpace? You will work in a collaborative, fast‑paced environment that values innovation and continuous learning. The role offers hands‑on experience with cutting‑edge BI concepts, from data‑lake design to AI‑enabled analytics, while contributing to life‑saving clinical research. Competitive compensation, flexible work arrangements, and a strong culture of employee wellness make Medpace an attractive place for fresh talent to launch a rewarding career.