Database Administrator

Job Title: Database Administrator
Location: Lansing, MI (Hybrid)
Type: W2 Contract

Required Education:
Bachelor s Degree Required

Required Skills:
Years of experience: 8 or more years of experience in the field is required
Power BI Desktop Power Query DAX and PowerBook tools
SQL Database Services
SAS and SQL Data Modelling

Top 3 skills needed: Power BI Desktop Power Query DAX and PowerBook tools experience SQL Database ETL experience SAS and SQL Data Modelling
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 modelling 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

Job Responsibilities:
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 Power BI 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

The Database Environment:
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