Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Hi
I hope you are doing great today.
I wanted to contact you about a job opening with one of our clients. Please review the requirements below and let me know if you are available.
- Job Title: Database Administrator 3
- Contract Length: 12 Weeks
- Location: Lansing MI
- Req id: 143628
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.
Top Skills/Requirements:
- Years of experience: 8 or more years of experience in the field is required.
- A bachelors degree is required
- Power BI Desktop Power Query DAX and PowerBook tools
- SQL Database Services
- SAS and SQL Data Modeling
Microsoft Power BI,Power BI Desktop,Power Query,DAX,PowerBook tools,SQL,SQL Developer Data Modeler,ETL,ETL Tools,SAS,Reports Analysis,Power BI
Employment Type
Full Time
