Position: Senior BI Developer
Location: New Kensington, PA
Employment: Contract (12 months plus extensions)
Project overview:
The core responsibility of the BI Developer is to design and develop complete 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 for various business functions is also one of the primary responsibilities.
The BI developer must have a strong knowledge of relational and multidimensional Databases including Cubes with strong emphasis on MDX, DAX languages to coach and mentor PCNA BI team. The role will also require interactions with business users and infrastructure support teams so must have strong communication skills, be a team player, as well as ability to effectively prioritize and manage a wide variety of tasks.
Job Summary:
- 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.
Location: Local to New Kensington, PA is preferred, but not necessary.
Interview process: phone interview, also open for Skype to start. .
Must have excellent communication skills.
***NO REMOTE WORK - ONLY ONSITE***
Apply on company website New Kensington, United States of America On-site Contract
SA Technologies is hiring a Senior BI Developer
About company
SA Technologies provides comprehensive Global Capability Center (GCC) solutions that drive innovation and business growth. The company specializes in expert GCC setup, talent solutions, and digital transformation services, enabling global enterprises to establish high-impact offshore centers in India.
With over 13 years of experience, SA Technologies offers flexible engagement models such as Build-Operate-Transfer (BOT) and Managed Teams, helping organizations de-risk expansion, accelerate time-to-market, and access elite talent. The company focuses on creating strategic assets that own outcomes, solutions, and intellectual property—not just tasks.
Services include strategic location selection, regulatory compliance, infrastructure and workspace setup, talent acquisition and development, and operational excellence, all tailored to support long-term business impact.