Technical Architecture Specialist

Job Title: Technical Architecture Specialist (800082)
Client: Commonwealth of PA
Duration: 06 Months

Notes: This is 100% remote role.

Job Description

• 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: The role and duties will include, but are not limited to, the following:
• Interface with key stakeholders and apply technical proficiency through the SDLC.
• Deliver high quality code, lead validations for testing and all activities related to implementation.
  Document, design, develop, test, implement and support solutions such as data models, cubes and reports to support data analysis
• Work closely with business units and team members to thoroughly understand business processes.
• Consult and collaborate with business to translate needs into analytics/reporting requirements.
• Track the status of assigned projects to ensure timely completion. Maintain communication with project manager and project team regarding progress of work.
• Schedule and oversee production rollouts.
• Coach and educate end users on best practices, standards for querying, and proper use of reports and cubes.
• Identify opportunities for improving BI development methods and procedures.
  Research database issues, standards and products as required.

Qualifications/Skills:

• Development experience using BI tools such as Microsoft SQL Server Analysis Services and Reporting Services
• Minimum 5 years of related experience * Experience developing data cubes with Microsoft SSAS
• Strong SQL skills required.
• Reporting Services skills required.
• Analysis Services skills a plus.
• Integration Services skills a plus.
• Reporting Structure a) Directly reports to the Data Quality Office Director b) Expected to be discerning enough to work independently.
• Travel Requirements: Attend meetings and workshops to support the success of the projects within the DQO.

If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction,
enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to
hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why
you think you are a fit.

About Us:
Since 2000, Tri-Force Consulting Services ( has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.