Job ID: MI-143628 (98090616)
Hybrid/Local Power BI/SAS Developer (Lansing 2hr/15+/5 page resume) with SQL Server Admin/DBA, Desktop, Power Query, PowerBook, DAX, SSRS, ETL, Data Modeling and QA experience
Location: Lansing, MI (CEPI)
Duration: 12 Months
Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week.
Local candidates ONLY. Must be located within 2 hours of Lansing, MI at time of submission.
Top Skills/Requirements:
Years of experience: 8 or more years of experience in the field is required.
A bachelor’s degree is required
Power BI Desktop, Power Query, DAX, and PowerBook tools
SQL Database Services
SAS and SQL Data Modeling.
– Bachelor’s Degree Required
This position supports the Center for Educational Performance and Information (CEPI) database
environment.
The database environment includes:
Multiple SQL Server instances
Multiple Collection Environments (Development, Quality Assurance/Testing, Pre-Release, and
Production)
• Numerous SQL Reporting Services Servers
35+ collection databases
100+ analysis databases.
This position is the Subject Matter Expert (SME) for the modernization to Power BI reporting and
requires considerable independent judgment directing and coordinating the appropriate data
administration and management methods, practices, procedures and tools, to complete the required
assignments. Expertise is required in Microsoft SQL Server database support, and professional
knowledge in the PowerBI platform as well as SAS will be required
We are seeking a technically skilled and detail-oriented data professional to join our team on a
temporary basis. This role is responsible for working directly with business users to understand how
Power BI is currently utilized, including identifying the data sources, databases, and tables supporting
existing dashboards and reports. A key focus of this position is to analyze and convert complex SAS
programs into optimized SQL code that integrates seamlessly with Power BI, while ensuring accuracy,
performance, and adherence to best practices in data management.
The ideal candidate will possess strong experience with SAS, SQL, and Power BI tools, including Power
Query and DAX. They will be adept at documenting current-state processes, identifying opportunities for
automation or efficiency, and developing sustainable data pipelines and models. Clear communication
skills and the ability to collaborate with both technical and non-technical stakeholders are essential,
along with a proactive, customer-focused approach. This is an excellent opportunity for someone who
enjoys problem solving, translating legacy code, and contributing to high-impact data reporting
solutions.
Description of work:
Top 3 skills needed: Power BI Desktop, Power Query, DAX, and PowerBook tools experience, SQL
Database ETL experience, SAS and SQL Data Modeling
Collaborate with customers to understand current use of Power BI, including identifying key
dashboards, reports, and underlying data sources and tables.
Review and analyze existing SAS programs to convert them to optimized SQL code suitable for
Power BI reporting.
Apply advanced SAS and SQL knowledge to ensure logic accuracy, performance optimization,
and consistency across data platforms.
Assess and document current data processes, recommending improvements and automation
opportunities that align with best practices.
Work with stakeholders to identify data sources, ETL processes, and transformation logic
critical for reporting needs.
Build and maintain robust, sustainable data pipelines with a focus on clarity, performance,
and long-term maintainability.
Leverage Power BI Desktop, Power Query, DAX, and PowerBook tools to support data
modeling, development, and visualization.
Apply strong problem-solving skills to debug, validate, and optimize ETL and data
transformation processes.
Communicate effectively with technical and non-technical audiences, documenting processes
and collaborating across teams.
Work independently in a contract/temporary role while delivering high-quality work with
accuracy, attention to detail, and a customer-focused mindset.
SOMI Candidate Cover Sheet (1).docx