Role Snapshot
Temporary data engineering position supporting the School of Medicine IT department in developing and maintaining reliable data pipelines, ETL processes, and Power BI solutions using SQL Server and Azure-based platforms. The role focuses on data integration, modeling, and business intelligence to enable operational and reporting needs.
Key Responsibilities: Develop and optimize SQL Server queries, stored procedures, and ETL workflows using tools like Informatica IICS or SSIS; perform data validation and quality checks across Bronze, Silver, and Gold data layers; create and maintain Power BI reports, dashboards, and semantic models with DAX measures and row-level security.
Skills & Tools: Proficiency in SQL Server, Azure data platforms (Microsoft Fabric, Azure Databricks), ETL tools (Informatica IICS, SSIS), Power BI development, and data modeling; strong understanding of lakehouse and medallion architecture patterns; ability to optimize queries and troubleshoot performance issues.
Qualifications: Bachelor's degree in computer science, data engineering, or related field with 2-3 years of experience in data engineering, SQL development, or ETL processes; demonstrated experience with SQL Server, cloud data platforms, and Power BI development.
Compensation: $65K–$85K/yr (estimated)
Job Description
This temporary position provides short-term support for data engineering, data integration, data modeling, and business intelligence activities within the School of Medicine Information Technology department. The role focuses on developing and supporting reliable data pipelines, curated data layers, and Power BI solutions using SQL Server and Azure-based data platforms such as Microsoft Fabric or Azure Databricks.
Essential Duties and Responsibilities:
* Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures in support of operational and reporting needs.
* Perform data validation, reconciliation, and quality checks across source, transformation, and curated data layers.
* Assist with data extraction, transformation, and loading (ETL) processes using Informatica (IICS), SSIS, or comparable ETL tools.
* Support integration of data from multiple source systems into SQL Server environments.
* Optimize SQL queries, transformations, data pipelines, and reporting datasets under the guidance of senior technical staff.
* Develop, maintain, and support Power BI reports, dashboards, semantic models, and data refresh processes using approved reporting and analytics tools.
* Support data ingestion and transformation workflows that prepare curated data for Power BI reporting using Azure-based platforms, including Microsoft Fabric or Azure Databricks.
* Work with lakehouse and medallion architecture patterns, including Bronze, Silver, and Gold data layers, to support reliable and reusable reporting datasets.
* Assist with Power BI data modeling, DAX measures, Power Query transformations, row-level security, refresh troubleshooting, and report performance optimization.
* Prepare and maintain documentation for source-to-target mappings, data pipelines, transformation logic, curated datasets, semantic models, and scheduled processes.
Essential Duties and Responsibilities:
* Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures in support of operational and reporting needs.
* Perform data validation, reconciliation, and quality checks across source, transformation, and curated data layers.
* Assist with data extraction, transformation, and loading (ETL) processes using Informatica (IICS), SSIS, or comparable ETL tools.
* Support integration of data from multiple source systems into SQL Server environments.
* Optimize SQL queries, transformations, data pipelines, and reporting datasets under the guidance of senior technical staff.
* Develop, maintain, and support Power BI reports, dashboards, semantic models, and data refresh processes using approved reporting and analytics tools.
* Support data ingestion and transformation workflows that prepare curated data for Power BI reporting using Azure-based platforms, including Microsoft Fabric or Azure Databricks.
* Work with lakehouse and medallion architecture patterns, including Bronze, Silver, and Gold data layers, to support reliable and reusable reporting datasets.
* Assist with Power BI data modeling, DAX measures, Power Query transformations, row-level security, refresh troubleshooting, and report performance optimization.
* Prepare and maintain documentation for source-to-target mappings, data pipelines, transformation logic, curated datasets, semantic models, and scheduled processes.