Database Administrator 3
Database Administrator 3
Posted on :
14-06-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Position Description CEPI Database Administrator 3
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.
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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
