Responsibilities
- Design, implement, and execute ETL pipelines for data ingestion and transformation
- Support ingestion of high volume, multi format data, including thousands of files and very large (TB scale) datasets
- Develop and maintain analytics ready datasets based on project specifications
- Translate research and analytical requirements into efficient, scalable data warehouse structures
- Optimize query performance using SQL Server, including advanced queries, stored procedures, indices, views, functions, and execution plans
- Perform supporting DBA functions, including permissions management, performance tuning, and monitoring
- Collaborate closely with project analysts, Principal Investigators, and other DBAs/data engineers to support multiple concurrent research projects
- Apply strong organizational, documentation, and communication skills, including proficiency with Microsoft Office
Tech Stack
SQL Server, SAS, Stata, Spark, Web technologies, C#, Python, PowerShell, Power BI, Snowflake, Health related datasets
Work Arrangement
On-site
Additional Information
- Duties are primarily sedentary
- May be required to move objects up to 25 pounds occasionally
