Medpace
Posted 3mo ago

Data Engineer

Medpace
Cincinnati, Ohio, United States
OnsiteFull Time
Responsibilities
  • developing pipelines
  • designing models
  • analyzing requirements
Requirements
  • Bachelor's in CS/Data Science
  • 3+ years data engineering experience
  • Experience with Snowflake
  • Dimensional modeling
  • ETL/ELT (dbt
  • Fivetran
  • Azure Data Factory, SSIS)
  • SQL Server/T-SQL
  • Power BI
  • Python and C#/Azure knowledge preferred
Technical tools mentioned
SnowflakeANSI SQLSQL ServerT-SQLdbtAzure Data FactorySSISMicrosoft Power BIFivetranPythonREST APIC#Azure

Job description

Job Summary:

Our corporate activities are growing rapidly, and we are currently seeking a full-time, office-based Data Engineer to join our Information Technology team. This position will work on a team to accomplish tasks and projects that are instrumental to the company’s success. If you want an exciting career where you use your previous expertise and can develop and grow your career even further, then this is the opportunity for you. 

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 software validation process through development, review, and/or execution of test plan/cases/scripts;
  • Create software applications by following software development lifecycle process, which includes requirements gathering, design, development, testing, release, and maintenance;
  • Communicate with team members regarding projects, development, tools, and procedures; and
  • Provide end-user support including setup, installation, and maintenance for applications
Qualifications :
  • Bachelor's Degree in Computer Science, Data Science, or a related field;
  • 3+ years of experience in Data Engineering;
  • Knowledge of developing dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs;
  • Solid ETL development, reporting knowledge based off intricate understanding of business process 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#, Azure development is a bonus; and
  • Excellent analytical, written and oral communication skills.
Medpace Overview :

Medpace is a full-service clinical contract research organization (CRO). We provide 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 its scientific and disciplined approach. We leverage local regulatory and therapeutic expertise across all major areas including oncology, cardiology, metabolic disease, endocrinology, central nervous system, anti-viral and anti-infective. Headquartered in Cincinnati, Ohio, employing more than 6,000 people across 40+ countries.

Why Medpace?:

People. Purpose. Passion. Make a Difference Tomorrow. Join Us Today.

 

The work we’ve done over the past 30+ years has positively impacted the lives of countless patients and families who face hundreds of diseases across all key therapeutic areas. The work we do today will improve the lives of people living with illness and disease in the future.

 

Cincinnati Perks

  • Cincinnati Campus Overview
  • Flexible work environment
  • Competitive PTO packages, starting at 20+ days
  • Competitive compensation and benefits package
  • Company-sponsored employee appreciation events
  • Employee health and wellness initiatives
  • Community involvement with local nonprofit organizations
  • Discounts on local sports games, fitness gyms and attractions
  • Modern, ecofriendly campus with an on-site fitness center
  • Structured career paths with opportunities for professional growth
  • Discounted tuition for UC online programs

Awards

  • Named a Top Workplace in 2024 by The Cincinnati Enquirer

  • Recognized by Forbes as one of America's Most Successful Midsize Companies in 2021, 2022, 2023 and 2024
  • Continually recognized with CRO Leadership Awards from Life Science Leader magazine based on expertise, quality, capabilities, reliability, and compatibility

TWP 2024          CRO2024

 

What to Expect Next

A Medpace team member will review your qualifications and, if interested, you will be contacted with details for next steps.

About Medpace

Global full-service clinical contract research organization.

Year founded
1992
Employees
6500
Organization type
Public
Latest investment
IPO (2016)
Headquarters
US

Similar jobs

Data Engineer roles near Cincinnati, Ohio
3d
Save
Mark Applied
Hide
Data Engineer
Miamisburg, Ohio, United States
OnsiteFull Time
United Wheels
United Wheels: Private outdoor lifestyle holding making bicycles, e-bikes, scooters, and ride-ons for families worldwide.
3+ YOEBachelor's degree in a related field and 3+ years designing and supporting data pipelines, analytical queries, reports, data models, and visualization-ready datasets. Strong SQL and programming skills required.
SQL, Python, Java, C#, Scala, R, Amazon S3, AWS Glue, Amazon Redshift, AWS Lambda, Amazon RDS, Athena, CloudWatch, IAM, Amazon Quick, Power BI, Tableau, Snowflake, BigQuery, Azure SQL Database, SQL Server, Databricks, Microsoft Fabric, Microsoft Office Suite, REST APIs, EventBridge, Step Functions
4d
Save
Mark Applied
Hide
Data Engineer/Python SQL Developer*
Beavercreek, Ohio, United States
RemoteFull Time
SierTeK
SierTeK: Minority- and service-disabled veteran-owned defense contractor providing advisory, technical, and IT services to federal DoD clients.
Advanced Python and SQL expertise, AWS Lambda, AWS Glue, Amazon S3, ETL, database design, Agile and Jira experience, technical documentation, and strong analytical and communication skills required.
Python, SQL, AWS Lambda, AWS Glue, Amazon S3, Jira
5d
Save
Mark Applied
Hide
Data Engineer/Python SQL Developer*
Beavercreek, Ohio, United States
RemoteFull Time
SierTeK
SierTeK: Minority- and service-disabled veteran-owned defense contractor providing advisory, technical, and IT services to federal DoD clients.
Advanced Python and SQL expertise; AWS Lambda, AWS Glue, Amazon S3, ETL, database design, scalable data pipelines, technical documentation, Agile delivery, and Jira experience required.
Python, SQL, AWS Lambda, AWS Glue, Amazon S3, Jira
1w
Save
Mark Applied
Hide
Data Engineer I - Finance
Cincinnati, Ohio, United States
OnsiteFull Time
Total Quality Logistics
Total Quality Logistics: One of the largest freight brokerage firms in North America.
1+ YOEBachelor’s degree and 1+ year in BI, data engineering, or analytics engineering. Requires SQL, Power BI, Excel, analytical and reconciliation skills; cloud data platform exposure preferred.
SQL, Power BI, Microsoft Fabric, Microsoft Excel, Power Query, DAX, Databricks, Azure, Tabular Editor, DAX Studio, Python, Git, Power Automate
2w
Save
Mark Applied
Hide
Data Engineer
Cincinnati, Ohio, United States
HybridFull Time
Great American Insurance Group
Great American Insurance GroupNew York Stock Exchange: AFG: Specialty property and casualty insurance and risk management services.
Bachelor’s degree in a related technical field; proficiency in Python, SQL, and R; cloud, ETL/ELT, data pipeline, AI, machine learning, data modeling, architecture, and governance experience.
Snowflake, Python, SQL, R, Informatica, Generative AI, UC4, Tableau
2w
Save
Mark Applied
Hide
Data Engineer / Python & SQL Developer
Washington or Dayton
RemoteFull Time
Graham Technologies
Graham Technologies: Minority-owned federal IT consulting firm delivering cloud, data analytics, cybersecurity, and modernization solutions for government agencies.
5+ YOEAdvanced Python and SQL expertise with hands-on ETL, AWS, database design, data modeling, troubleshooting, testing, code review, documentation, and Agile delivery experience.
Python, SQL, AWS Lambda, AWS Glue, Amazon S3, Jira
2w
Save
Mark Applied
Hide
Data Engineer - North America Fabric Care
Cincinnati, Ohio, United States
$85k-$122k/yr HybridFull Time
Procter & Gamble
Procter & GambleNYSE: PG: A multinational consumer goods.
Bachelor's degree in Computer Science or related field; data engineering experience; Python and SQL; ETL/ELT, data modeling, distributed processing, cloud platforms, APIs, databases, Git, CI/CD, and Generative AI.
Python, SQL, Azure, GCP, VS Code, Git, CI/CD, Generative AI, Azure Databricks, PySpark, Spark, Power BI
2w
Save
Mark Applied
Hide
Senior Data Engineer (P1129)
Chicago or Cincinnati or United States
$98k-$169k/yr OnsiteFull Time
84.51°
84.51°: Retail data science, insights and media creating personalized shopper experiences.
3+ YOERequires 3+ years in data development, Databricks, PySpark/Spark, and Python or Java; ETL, data warehousing, orchestration, CI/CD, version control, Agile, AI concepts, and a relevant bachelor's degree.
PySpark, Python, Databricks, FastAPI, Helm, Azure Kubernetes Service (AKS), Spark, Java, Azure, Databricks Delta Tables, Delta Lake, Delta Live Tables, Flask, Kubernetes, Structured Streaming, Kafka, Azure Event Hubs, GitHub, GitHub Actions, Terraform, Tableau, Microsoft Power BI, Cognos