SQL Developer

Mbi Llc; Harrisburg (Dauphin County); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading data solutions provider is seeking a senior SSAS developer to lead development efforts for a research data repository. The ideal candidate will have over 5 years of experience with SQL and SSAS, and a strong familiarity with education data management systems. Responsibilities include interfacing with stakeholders, delivering high-quality code, and documenting solutions. This position requires excellent analytical skills and an ability to work independently under the guidance of a project director.

Qualifications

• More than 5 years of demonstrated experience in SQL development and SSAS.
• Familiarity with education data, especially Pennsylvania Information Management System (PIMS), is highly desired.
• Experience with multi-dimensional cubes and data automation is preferred.

Responsibilities

• Interface with key stakeholders and apply technical proficiency through the SDLC.
• Deliver high quality code and lead validations for testing.
• Document, design, and support solutions like data models and cubes.
• Consult with business to translate needs into analytics/reporting requirements.
• Schedule and oversee production rollouts.

Skills

Microsoft SQL Server Analysis Services

SQL development

Data cube development

Project management methodologies

Education

4-year bachelor's degree

Tools

Microsoft SSAS

SQL Server Reporting Services

Job description

- The Pennsylvania Department of Education (PDE), Data Quality Office, is managing a federal government grant and a number of associated projects. PDE requires senior-level SSAS developer to lead the development efforts for a Research data repository.

- PDE requires an experienced SQL developer with proven experience with SSAS.

- The candidate should have more than 5 years of demonstrated experience and a 4 year bachelor’s degree.

- Familiarity with education, education data, and Pennsylvania Information Management System (PIMS) and its data is highly desired.

- The candidate will primarily work on Research data repository project along with other projects as assigned.

- Experience with multi-dimensional cubes, data linking and automation of data refresh between different data sources is highly desired.

- The candidate preferably has experience in education and has knowledge and understanding of various types of project management methodologies.

Responsibilities

1. Interface with key stakeholders and apply technical proficiency through the SDLC.
2. Deliver high quality code, lead validations for testing and all activities related to implementation.
3. Document, design, develop, test, implement and support solutions such as data models, cubes and reports to support data analysis.
4. Work closely with business units and team members to thoroughly understand business processes.
5. Consult and collaborate with business to translate needs into analytics/reporting requirements.
6. Track the status of assigned projects to ensure timely completion. Maintain communication with project manager and project team regarding progress of work.
7. Schedule and oversee production rollouts.
8. Coach and educate end users on best practices, standards for querying, and proper use of reports and cubes.
9. Identify opportunities for improving BI development methods and procedures.
10. Research database issues, standards and products as required.

Qualifications

1. Development experience using BI tools such as Microsoft SQL Server Analysis Services and Reporting Services.
2. Minimum 5 years of related experience * Experience developing data cubes with Microsoft SSAS.
3. Analysis Services skills a plus.
4. Integration Services skills a plus.

Reporting Structure

Directly reports to the Data Quality Office Director and is expected to work independently.

Travel Requirements

Attend meetings and workshops to support the success of the projects within the DQO.