Description

Modernize the database reporting environment by converting legacy SAS programs into optimized SQL for Power BI and building sustainable data pipelines.

This role is hybrid.

Responsibilities

• Collaborate with business users to identify data sources and tables supporting existing Power BI dashboards.
• Analyze and convert complex SAS programs into optimized SQL code for Power BI integration.
• Document current data processes and recommend automation or efficiency improvements.
• Build and maintain sustainable data pipelines focused on clarity and performance.
• Leverage Power BI tools to support data modeling, development, and visualization.

Required Skills

• 8+ years of experience in database administration.
• Expertise in Microsoft SQL Server database support across multiple collection environments.
• Proficiency with Power BI Desktop, Power Query, DAX, and PowerBook tools.
• Strong experience with SQL Database ETL processes.
• Proficiency in SAS and SQL Data Modeling.
• Ability to translate legacy code and debug ETL/data transformation processes.
• Experience working with 35+ collection and 100+ analysis databases.
• Clear communication when interacting with technical and non-technical stakeholders.

Preferred Skills

• Experience with data pipeline automation.

Key Skills

Education

Any Graduate