SA TECHNOLOGIES
Senior BI Developer
SA TECHNOLOGIES, New Kensington, Pennsylvania, United States,
Satincorp (www.satincorp.com) is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.We guarantee you the best rate for your skills and performance.Job Description
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 and 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.Qualifications
10+ years of experience related to Microsoft BI development using SSAS.5+ years of experience in writing T-SQL scripts on various versions of SQL server.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.3+ years of experience in using SSMS for design of tables, views, common table expressions, foreign key constraints, and stored procedures.2+ years of experience in SQL server 2012 is required, SQL server 2014 is preferred.2+ years of experience in MDX, DAX language is highly required.Exposure to Power BI and Tabular reporting is 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.
#J-18808-Ljbffr
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 and 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.Qualifications
10+ years of experience related to Microsoft BI development using SSAS.5+ years of experience in writing T-SQL scripts on various versions of SQL server.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.3+ years of experience in using SSMS for design of tables, views, common table expressions, foreign key constraints, and stored procedures.2+ years of experience in SQL server 2012 is required, SQL server 2014 is preferred.2+ years of experience in MDX, DAX language is highly required.Exposure to Power BI and Tabular reporting is 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.
#J-18808-Ljbffr