SQL Server Analysis Services Developer (683958) // US or GC // 100% On-site Harrisburg, PA // 1099, W2

Dantech

$65/hr Employer stated

1234 Some Street, Harrisburg, PA, US · Onsite

Posted 2 months ago · Confirmed live 11 hours ago

Skills this job asks for

  • SQL
  • SSAS

Tailor your resume for this job

See which of these skills you have, and tailor your resume for this job.

Sign up free

Tailor your resume for this job

Start from your profile and shape your resume to this role.

At a glance

Type
Full-time
Level
Not stated
Experience
5+ years
Work model
Onsite
Schedule
Not stated
Education
Bachelor's degree
Benefits
Not stated
Team
Engineering

Description

About the Opportunity
  • We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
  • We are only considering local candidates who currently reside within 45 minutes of postal code 17101
  • No Third Party Agencies
  • $65 per hour 1099, W2 + Benefits Rate Available
  • 100% On-site in Harrisburg, Pennsylvania
  • Job Id: OST-683958
  • Must be able to provide proof of COVID-19 vaccination plus booster shot
  • Contract Term: Till end of the 2022 fiscal year with yearly extension based upon performance

Short Description

The Commonwealth of Pennsylvania’s Department of Education (PDE) is seeking an SQL Server Analysis Services Developer to lead the development efforts for a Research data repository. The ideal candidate will possess 5+ years of Microsoft SSAS and Reporting Services, 5+ years of developing data cubes, and 5+ years of SQL.


Required Skills/Years of Experience

  • Bachelor’s degree in IT or related field or equivalent experience
  • 5+ years of experience using BI tools such as Microsoft SQL Server Analysis Services
  • 5+ years of experience developing data cubes with Microsoft SSAS
  • 5+ years of experience with SQL
  • 5+ years of experience with Reporting Services


Desired Skills/Years of Experience:

  • 5+ years of experience with Analysis Services
  • 5+ years of experience with Integration Services


Complete Description

The Commonwealth of Pennsylvania’s Department of Education (PDE) is seeking an SQL Server Analysis Services Developer to lead the development efforts for a Research data repository. The ideal candidate will possess 5+ years of Microsoft SSAS and Reporting Services, 5+ years of developing data cubes, and 5+ years of SQL.

The SQL Server Analysis Services Developer will be tasked to:

  • Lead the development efforts for a research data repository
  • Report to the Data Quality Office Director
  • Apply strong Integration Services skills
  • Work with BI tools such as Microsoft SQL Server Analysis Services and Reporting Services
  • Utilize knowledge of education, education data, and the Pennsylvania Information Management System (PIMS)
  • Apply experience with multi-dimensional cubes, data linking, and automation of data refreshing between different data sources
  • Utilize understanding of various types of project management methodologies
  • Work on the research data repository project along with other projects as assigned
  • Apply technical proficiency throughout the software development life cycle
  • Interface with key stakeholders
  • Apply strong Reporting Services skills
  • Deliver high-quality code
  • Lead validations for testing and all activities related to implementation
  • Document, design, develop, test, and implement solutions
  • Support data analysis with data models, cubes, and reports
  • Apply a thorough understanding of business processes
  • Work independently and consult with business units and team members
  • Translate business needs into analytics/reporting requirements
  • Track the status of assigned projects to ensure timely completion
  • Communicate with the project manager and team regarding the progress of the work
  • Attend meetings and workshops to support the success of the projects
  • Schedule and oversee production rollouts
  • Apply strong SQL skills
  • Coach and educate end-users on best practices, standards for querying, and the proper use of reports and cubes
  • Identify opportunities for improving BI development methods and procedures
  • Apply prior experience with SSAS
  • Research database issues, standards, and products as required
  • Develop data cubes with Microsoft SSAS
  • Apply strong Analysis Services skills


Hiring Expectations

  • We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
  • No Third Parties
  • Right to Represent authorization is required
  • Expect technical interview screening
  • Expect F2F interview
  • Background check and/or credit check will be required


About Dantech
Dantech Corporation, Inc. is a Certified Business Enterprise (CBE) in the District of Columbia and a federally recognized Woman Owned Small Business (WOSB). The company has a history of technology, innovation and transformation since its launch in 1999. As an Equal Opportunity/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, or disability status. For more information about positions with Dantech, please see: the employer's site.

About Dantech

Dantech

See all 165 open roles at Dantech