Senior Data Analyst Power BI & SQL Modernization

Overview

On Site
$$60/hr on C2C or $50/hr on W2
Contract - W2
Contract - 12 month(s)

Skills

Technical Documentation
Process Automation
Microsoft SQL Server
Data Visualization
Data Transformation
DAX
SAS
Power BI Desktop
Power Query
PowerBook tools
SQL Database ETL
SQL Data Modeling
Data Pipeline Development
Communication with Stakeholders

Job Details

Job Title: Senior Data Analyst Power BI & SQL Modernization
Location: Lansing, MI (Hybrid 2 days onsite/week, onsite from Day 1, no remote-only option)
Interview Type: Virtual via MS Teams (video, screen sharing required)

  • Candidate Requirement: Must be local (within 2 hours of Lansing, MI)
  • This Database Administrator 3 role supports CEPI's complex database environment, which includes:
  • This position is the Subject Matter Expert (SME) for CEPI's modernization effort toward Power BI reporting and transformation of legacy SAS processes into optimized SQL and Power BI solutions.
Preferred Qualification:
  • Bachelor's Degree required
Responsibilities:
  • Collaborate with users to understand current use of Power BI and the associated data landscape
  • Analyze, optimize, and convert complex SAS programs to efficient SQL code suitable for Power BI
  • Develop and document data pipelines, ETL processes, and transformation logic
  • Utilize Power BI Desktop, Power Query, DAX, and PowerBook tools for modeling and visualization
  • Ensure accuracy and performance of data models and reports
  • Troubleshoot and optimize data processes with strong problem-solving skills
  • Communicate clearly with both technical and non-technical stakeholders
  • Provide documentation and recommendations for process improvements and automation
Top Skills & Experience Required:
  • 8+ years of experience in Database Administration or related data roles
  • Expertise in Power BI Desktop, Power Query, DAX, and PowerBook tools
  • Strong SQL Database ETL experience
  • Proficiency in SAS and SQL Data Modeling
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.