Dice is the leading career destination for tech experts at every stage of their careers. Our client, tCognition, Inc, is seeking the following. Apply via Dice today! 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