Senior Business Intelligence Developer,Loc: New Kensington, PA.

100,000 - 200,000

Job Description:

This position is a full-time employment role - not a contract opportunity.
The core responsibility of the Senior BI Developer is to design and develop complete Business Intelligence (BI) solutions
This would include design and development of programs using SQL Server Integration Services (SSIS) to extract information from various ERP into the staging area.
Also includes development of various artifacts using T-SQL for the setup of the Enterprise Datawarehouse (EDW).
Development of SQL Server Analysis Services (SSAS) cube and SQL Server Reporting Services (SSRS) for various business functions is also one of the primary responsibilities.
Additionally, the role will involve interacting with business users and infrastructure support teams and will be responsible for the development and implementation of customer solutions that align with the business needs.
This position would also provide an excellent opportunity to enhance your technical skillset in a dynamic environment and work with high energy team focused on building a self-service Business Intelligence ecosystem.

FUNDAMENTAL DUTIES:

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
Design, develop and implement SSAS cubes 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
Create/maintain project documentation to successfully implement IT-based solutions including: Project Plans and Functional/Technical Design documents
Develop Training materials focused on end-users for various business functions
Other duties and responsibilities performed as assigned

MINIMUM QUALIFICATIONS REQUIRED:

Bachelors degree in Information Technology or Computer Science or Engineering
10+ years of experience of BI development using MS-SSAS for Multidimensional & Tabular cubes
5+ years of experience in writing T-SQL scripts on various versions of SQL server
5+ years of experience in using SSMS for design of tables, views, common table expressions, foreign key constraints, and stored procedures
5+ years of experience with complete SDLC lifecycle in this area, including but not limited to requirements gathering, data analysis, design, development, QA, deployment
3+ years of experience related to SSIS for data integration/ETL technologies
3+ years of design and development experience in SSRS
2+ years of experience in MDX, DAX language is highly required
2+ years of Power BI and Tabular reporting is preferred
2+ years of experience in SQL server 2012 is required, SQL server 2014 is preferred
Knowledge of Syteline ERP on Multisite is highly preferred
Ability to accurately estimate the ETL and Data Architecture components of data integration, Business Intelligence, Analytics, Reporting and Data Warehouse delivery projects
Strong analytical, attention to detail, organizational and core project management skills.
Strong teamwork, communication and customer service skills.