Responsibilities
- Design, develop and implement Store Procedures, Functions and other artifacts in TSQL for data migration from staging area to EDW
- Design, develop and implement the ETL process using SSIS, including data quality and testing
- Design, develop and implement SSAS cubes for various business functions
- Implement security requirements for the SSAS cubes using role-based or dimensional based
- Create/maintain project documentation to successfully implement IT-based solutions including: Project Plans, Functional/Technical Design documents
- Develop Training materials focused on end-users for various business functions
- Assist in the install and configuration of various MS-SQL BI infrastructure, utilizing referenced project documentation
- Work with other team members as needed to implement solutions in a timely manner
- Assist management with prioritization of projects and establishing accurate timelines for implementation
- Enforce best technical practices for the BI infrastructure to enhance user experience
- Coach and mentor PCNA BI team members on the various aspects of BI development
- Other duties and responsibilities performed as assigned.
Requirements
- Strong knowledge of relational and multidimensional databases including cubes
- Strong emphasis on MDX, DAX languages
- Excellent communication skills
- Must be able to work onsite
- Experience with SQL Server Integration Services (SSIS)
- Experience with T-SQL for setup of Enterprise Datawarehouse (EDW)
- Experience with SQL Server Analysis Services (SSAS) cube development
Work Arrangement
On-site — New Kensington, PA
Additional Information
- Local to New Kensington, PA is preferred, but not necessary.
- Interview process: phone interview, also open for Skype to start.
- NO REMOTE WORK - ONLY ONSITE
