Medpace
Posted 1mo ago

Data Engineer

Medpace
Cincinnati, Ohio, United States
OnsiteFull Time
Responsibilities
  • designing models
  • developing etl
  • supporting applications
Requirements
  • Bachelor's in CS/Data Science or related
  • 3+ years data engineering
  • ETL/ELT
  • Dimensional modeling
  • Snowflake and SQL knowledge
  • Python and REST API preferred
  • Strong analytical and communication skills
Technical tools mentioned
SnowflakeANSI SQLSQL ServerT-SQLdbtAzure Data FactorySSISMicrosoft Power BIFivetranPythonREST APIC#Azure

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. 

  • 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
  • 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 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.

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

  • 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 contract research organization for medical development.

Similar jobs

Data Engineer roles near Cincinnati, Ohio
4d
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
4d
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
5d
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
5d
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
5d
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
6d
Save
Mark Applied
Hide
Data Engineer Lead
San Antonio or Beavercreek or Houston or Charlotte or Huntsville or Atlanta
$92k-$153k/yr OnsiteFull Time
Guidehouse
Guidehouse: Provides management and technology consulting services to diverse organizations.
7+ YOEBachelor's degree in a technical field, 7+ years of data or software engineering experience, technical leadership, Python, SQL, Spark/PySpark, cloud platforms, data pipelines, ETL/ELT, CI/CD, Docker, and Kubernetes.
Python, SQL, Spark, PySpark, AWS, Azure, Databricks, Snowflake, Docker, Kubernetes, Terraform, CloudFormation, Bicep, ARM, Kafka, Event Hub, Kinesis, Splunk, Datadog, CloudWatch, Kibana, Elasticsearch
6d
Save
Mark Applied
Hide
Branch Operations Data Engineer
Irving or Hopkins or Cincinnati or United States
$93k-$109k/yr OnsiteFull Time
U.S. Bank
U.S. BankNYSE: USB: Provider of personal, business, and institutional financial services.
4+ YOEBachelor's degree in a related field or equivalent experience, plus 4–5 years of statistical or data analytics experience; requires advanced analytics, predictive modeling, communication, and project management skills.
E-Verify
6d
Save
Mark Applied
Hide
Google Senior Data Engineer
Albany or Milwaukee or Dallas or Columbus or Kirkland or Cincinnati or New York City or Cleveland or Oklahoma City or Austin or Chicago or St. Petersburg or Hartford or Pittsburgh or St. Louis or Miami or Sacramento or Raleigh or Minneapolis or Mountain View or Scottsdale or San Francisco or Morristown or Denver or Boston or Philadelphia or Des Moines or Overland Park or Los Angeles or Charlotte or Walnut Creek or Carmel or Seattle or Houston or Arlington or Atlanta or Redmond or Bentonville or Beaverton or Nashville or Detroit or San Diego or United States
$80k-$266k/yr HybridFull Time
Accenture
AccentureNYSE: ACN: Global provider of management consulting and technology services.
5+ YOERequires 5+ years in data engineering, analytics, or ML; 4+ years on GCP; 5+ years with SQL, modeling, and pipelines; 3+ years with Python or AI tools; bachelor's degree or equivalent.
Google Cloud Platform (GCP), BigQuery, Looker, Vertex AI, Gemini Foundation Models, Gemini Enterprise, Model APIs, Embeddings, Dataflow, Dataproc, Pub/Sub, Cloud Storage, Looker Studio, Dataplex, IAM, SQL, Python, CI/CD, Git, RAG