Junior Data Engineer
About the role
We are seeking a full-time, office-based Junior Data Engineer to join our Information Technology team. This position will work on a team to accomplish tasks and projects instrumental to the company’s success, offering an exciting career where you can use your expertise and grow further.
Responsibilities
- Utilize skills in development areas including data warehousing, business intelligence, and databases (Snowflake, ANSI SQL, SQL Server, T-SQL).
- Support programming/software development using Extract, Transform, and Load (ETL) and Extract, Load and Transform (ELT) tools (dbt, Azure Data Factory, SSIS).
- Design, develop, enhance, and support business intelligence systems primarily using Microsoft Power BI.
- Collect, analyze, and document user requirements.
- Participate in the software validation process through development, review, and/or execution of test plans/cases/scripts.
- Create software applications by following the software development lifecycle process, including requirements gathering, design, development, testing, release, and maintenance.
- Communicate with team members regarding projects, development, tools, and procedures.
- Provide end-user support including setup, installation, and maintenance for applications.
Requirements
- Bachelor's Degree in Computer Science, Data Science, or a related field.
- Internship experience in Data or Software Engineering.
- Knowledge of developing dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs.
- Solid ETL development and reporting knowledge based on an intricate understanding of business processes and measures.
- Knowledge of Snowflake cloud data warehouse, Fivetran data integration, and dbt transformations is preferred.
- Knowledge of Python is preferred.
- Knowledge of REST API.
- Basic knowledge of SQL Server databases is required.
- Knowledge of C# and Azure development is a bonus.
- Excellent analytical, written, and oral communication skills.
About the company
Medpace is a full-service clinical contract research organization (CRO) providing phase I-IV clinical development services to the biotechnology, pharmaceutical, and medical device industries. Our mission is to accelerate the global development of safe and effective medical therapeutics through the advancement of clinical research. We leverage in-country regulatory and therapeutic expertise across major therapeutic areas, including oncology, cardiology, metabolic, endocrinology, central nervous system, and anti-viral and anti-infective. Headquartered in Cincinnati, Ohio, we employ more than 6,500 people across 40+ countries.
Benefits
- Competitive compensation programs that recognize and reward performance.
- Comprehensive health, wellness, retirement, and PTO benefits.
- Office-based culture with occasional work-from-home flexibility for eligible positions after training.
- Company-sponsored social events and intramural sports.
Work environment
- Purpose-driven work alongside physicians, scientists, and industry-leading experts.
- Collaborative culture with open communication, mutual trust, and accessible leadership.
- Defined career paths with clear advancement opportunities and industry-renowned onboarding/training programs.
- Ongoing training and continuous learning opportunities throughout your career.
- Modern corporate campus in Cincinnati designed to support collaboration and productivity.
- Multiple on-site dining options, free parking, and 24/7 on-site fitness/wellness facilities.