Junior Data Engineer

Medpace is actively hiring for the role of Junior Data Engineer! Responsibilities of the candidate: 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 plan/cases/scripts; Create software applications by following the 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. 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, 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. Medpace is actively hiring for the role of Junior Data Engineer! Responsibilities of the candidate: 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 plan/cases/scripts; Create software applications by following the 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. 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, 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.