Database Administrator

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Microsoft Power BI
Power Query
DAX
Public Sector
PowerBook
SQL
Database
Extract
Transform
Load
ETL development
SAS
Data Modeling
Reporting
Microsoft SSRS
Microsoft SQL Server
Testing

Job Details

Job Title: Data Integration & Reporting Analyst (Power BI/SAS Specialist)

Work Arrangement: Hybrid (Onsite from Day 1, two days per week)

Location: Lansing, MI

Duration: 12 months

Client: State of Michigan Center for Educational Performance and Information (CEPI)

Position Overview:

This position supports the database environment of the Center for Educational Performance and Information (CEPI). The environment consists of:

  • Multiple SQL Server instances
  • Multiple collection environments, including Development, QA/Testing, Pre-Release, and Production
  • Numerous SQL Server Reporting Services (SSRS) servers
  • 35+ collection databases
  • 100+ analysis databases

This role serves as the Subject Matter Expert (SME) for CEPI s modernization initiative transitioning to Power BI reporting. It requires a high level of independent judgment in managing and coordinating data administration methods, tools, and best practices. Deep expertise in Microsoft SQL Server, Power BI, and SAS is essential.

We are seeking a technically proficient, detail-oriented data professional to join our team on a contract basis. The successful candidate will engage directly with business users to assess current Power BI utilization, including data sources, databases, and tables supporting existing dashboards and reports.

A primary focus of this position is the analysis and conversion of complex SAS programs into optimized SQL code that integrates seamlessly with Power BI, ensuring data accuracy, performance, and compliance with best practices.

Responsibilities:

  • Collaborate with users to analyze the current use of Power BI, identifying key dashboards, reports, and underlying data sources.
  • Review, analyze, and convert existing SAS programs into efficient, well-structured SQL code for Power BI reporting.
  • Apply advanced SAS and SQL expertise to ensure accurate logic, performance optimization, and cross-platform consistency.
  • Document and assess current data workflows and recommend improvements or automation opportunities.
  • Identify key data sources, ETL processes, and transformation logic essential to business reporting.
  • Build and maintain robust, sustainable data pipelines focusing on clarity, performance, and maintainability.
  • Use Power BI Desktop, Power Query, DAX, and PowerBook tools for data modeling, report development, and visualization.
  • Diagnose, debug, and optimize ETL and data transformation issues.
  • Communicate technical concepts clearly to both technical and non-technical stakeholders.
  • Deliver high-quality, accurate work independently in a contract role, with a strong attention to detail and a customer-focused approach.

Top Skills & Requirements:

  • Minimum Experience: 8+ years in data-related roles
  • Education: Bachelor s degree required
  • Technical Skills:
    • Power BI Desktop, Power Query, DAX, PowerBook tools
    • SQL Database services and ETL development
    • SAS and SQL data modeling
  • Proven ability to convert legacy SAS code into optimized SQL for Power BI integration
  • Experience supporting reporting environments in public sector or enterprise settings preferred
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.

About tCognition, Inc