Medpace
Posted 7mo ago

Data Engineer

Medpace
Cincinnati, Ohio, United States
OnsiteFull Time
Responsibilities
  • design BI
  • implement ETL
  • collaborate team
Requirements
  • Bachelor's degree in CS/DS
  • 3+ years data engineering
  • Strong SQL/ETL
  • Snowflake, dbt, Power BI
  • Python
  • REST API
  • SQL Server
  • Azure
  • Excellent communication
Technical tools mentioned
SnowflakedbtAzure Data FactorySSISPower BIANSI SQLSQL ServerT-SQLPythonREST APIC#Azure developmentSQL

Job description

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

Full-service clinical research organization for pharmaceutical and biotechnology industries.

Similar jobs

Data Engineer roles near Cincinnati, Ohio
1d
Save
Mark Applied
Hide
Data Engineer
Cincinnati, Ohio, United States
HybridFull Time
Great American Insurance Group
Great American Insurance GroupNYSE: AFG: Provides specialized property and casualty insurance products for businesses.
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
1d
Save
Mark Applied
Hide
Data Engineer / Python & SQL Developer
Washington or Dayton
RemoteFull Time
Graham Technologies
Graham Technologies: Provides secure IT services and modernization solutions.
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
2d
Save
Mark Applied
Hide
Data Engineer - North America Fabric Care
Cincinnati, Ohio, United States
$85k-$122k/yr HybridFull Time
Procter & Gamble
Procter & GambleNYSE: PG: Manufactures and sells diverse consumer packaged goods globally.
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
5d
Save
Mark Applied
Hide
Data Engineer
Cincinnati, Ohio, United States
OnsiteFull Time
Cincinnati Reds
Cincinnati Reds: Operates the Cincinnati Reds Major League Baseball franchise.
2+ YOEBachelor's degree or equivalent technical experience, 2+ years of professional experience, SQL and Python proficiency, and experience with cloud, ETL/ELT, DevOps, orchestration, and infrastructure tools.
SQL, Python, PySpark, Git, Continuous Integration/Continuous Deployment (CI/CD), Azure DevOps, Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS), Terraform, CloudFormation, Kafka, Kinesis, Apache Airflow, Dagster, Prefect
5d
Save
Mark Applied
Hide
Senior Data Engineer (P1129)
Chicago or Cincinnati or United States
$98k-$169k/yr OnsiteFull Time
84.51°
84.51°NYSE: KR: Provides retail data analytics and targeted advertising services.
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
6d
Save
Mark Applied
Hide
Data Engineer
Dayton, Ohio, United States
$62k-$141k/yr OnsiteFull Time
Booz Allen Hamilton
Booz Allen HamiltonNYSE: BAH: Consulting and technology services for government and commercial clients
5+ YOERequires 5+ years in data architecture, design, or engineering, a bachelor's degree in computer science or a technical discipline, AWS knowledge, programming experience, and TS/SCI clearance.
IoT, machine learning, artificial intelligence, Extract, Transform, Load (ETL), NoSQL, SQL, AWS, Amazon S3, AWS IAM, Amazon EventBridge, AWS Step Functions, AWS Lambda, dbt, Airflow, GitHub, CI/CD, Python, Rust, C++, Java, API, AWS architecture
1w
Save
Mark Applied
Hide
Google Senior Data Engineer
Albany or Arlington or Atlanta or Austin or Beaverton or Bentonville or Boston or Carmel or Charlotte or Chicago or Cincinnati or Cleveland or Columbus or Culver City or Denver or Des Moines or Detroit or Hartford or Houston or Irving or Kirkland or Miami or Milwaukee or Minneapolis or Morristown or Mountain View or Nashville or New York City or Oklahoma City or Overland Park or Philadelphia or Pittsburgh or Raleigh or Redmond or Sacramento or San Diego or San Francisco or Scottsdale or Seattle or St. Louis or St. Petersburg or Walnut Creek or United States
$80k-$266k/yr HybridFull Time
Accenture
AccentureNYSE: ACN: Global professional services firm providing consulting and technology solutions.
5+ YOERequires 5+ years in data engineering, analytics, or ML; 4+ years with GCP; 5+ years with SQL and pipelines; 3+ years with Python or AI tools; and a bachelor's degree or equivalent.
Google Cloud Platform (GCP), BigQuery, Looker, Vertex AI, Gemini Foundation Models, Gemini Enterprise, Dataflow, Dataproc, Pub/Sub, Cloud Storage, Looker Studio, Model APIs, Embeddings, Dataplex, IAM, SQL, Python, Git
1w
Save
Mark Applied
Hide
Data Engineer
Dayton, Ohio, United States
$62k-$141k/yr OnsiteFull Time
Booz Allen Hamilton
Booz Allen HamiltonNYSE: BAH: Provides technology and management consulting services to diverse organizations.
5+ YOERequires 5+ years in data architecture, design, or engineering; cloud migration, ETL, pipelines, databases, AI/ML integration, AWS, TS/SCI clearance, and a bachelor's degree in computer science or a technical discipline.
IoT, machine learning, artificial intelligence, Extract, Transform, Load (ETL), NoSQL, SQL, AWS, Amazon S3, AWS IAM, Amazon EventBridge, AWS Step Functions, AWS Lambda, dbt, Apache Airflow, GitHub, Python, Rust, C++, Java, CI/CD