Sonoma Consulting
BI- SSAS developer
Sonoma Consulting, New Kensington, Pennsylvania, United States,
Sonoma Consulting
is one of the fastest growing national IT Consulting and Executive Search companies in the United States, founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients ranging from entrepreneurial start-ups to Global Fortune 500.Our culture is distinct, professional, experienced, and progressive. We take pride in providing quality consultants to reputable clients to ensure a mutually beneficial relationship. Our team is results-driven, passionate about connecting the right people with the right companies. We understand the competitiveness of our business and rely on each other to maintain an adaptable, professional atmosphere. Our employees work in a fast-paced environment focused on goal setting and accomplishing those goals.Achieving our mission requires intelligent, energetic, and committed people who possess:Integrity and HonestyCommitment to excellenceAccountability to the employees, consultants, and customers we work withCommunity and DiversityJob Description
The core responsibility of the Senior BI Developer is to design and develop complete BI solutions. This includes the design and development of programs using SQL Server Integration Services (SSIS) to extract information from various ERPs into the staging area, as well as the development of various artifacts using T-SQL for the setup of the Enterprise Data Warehouse (EDW). Development of SQL Server Analysis Services (SSAS) cubes for various business functions is also a primary responsibility.The BI developer must have strong knowledge of relational and multidimensional databases, including cubes, with a strong emphasis on MDX and DAX languages to coach and mentor the BI team.The role will require interactions with business users and infrastructure support teams, so strong communication skills, teamwork, and the ability to effectively prioritize and manage a wide variety of tasks are essential.FUNDAMENTAL DUTIESDesign, develop, and implement stored procedures, functions, and other artifacts in T-SQL 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 methods.Create and maintain project documentation to successfully implement IT-based solutions, including project plans.Develop training materials focused on end-users for various business functions.Assist in the installation 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 BI team members on various aspects of BI development.Perform other duties and responsibilities as assigned.EDUCATION AND EXPERIENCE10+ 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 the complete SDLC lifecycle in this area, including but not limited to requirements gathering, data analysis, design, development, QA, and 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 and 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.Qualifications
SSASAdditional Information
All qualified applicants will receive consideration for employment without regard to race, color, religion, place of origin, ethnic origin, national origin, ancestry, age, sex, sexual orientation, gender identity, transgender status, genetic information, mental or physical disability, marital status, pregnancy, veteran status, or any other characteristic protected by applicable national, state, or local law.
#J-18808-Ljbffr
is one of the fastest growing national IT Consulting and Executive Search companies in the United States, founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients ranging from entrepreneurial start-ups to Global Fortune 500.Our culture is distinct, professional, experienced, and progressive. We take pride in providing quality consultants to reputable clients to ensure a mutually beneficial relationship. Our team is results-driven, passionate about connecting the right people with the right companies. We understand the competitiveness of our business and rely on each other to maintain an adaptable, professional atmosphere. Our employees work in a fast-paced environment focused on goal setting and accomplishing those goals.Achieving our mission requires intelligent, energetic, and committed people who possess:Integrity and HonestyCommitment to excellenceAccountability to the employees, consultants, and customers we work withCommunity and DiversityJob Description
The core responsibility of the Senior BI Developer is to design and develop complete BI solutions. This includes the design and development of programs using SQL Server Integration Services (SSIS) to extract information from various ERPs into the staging area, as well as the development of various artifacts using T-SQL for the setup of the Enterprise Data Warehouse (EDW). Development of SQL Server Analysis Services (SSAS) cubes for various business functions is also a primary responsibility.The BI developer must have strong knowledge of relational and multidimensional databases, including cubes, with a strong emphasis on MDX and DAX languages to coach and mentor the BI team.The role will require interactions with business users and infrastructure support teams, so strong communication skills, teamwork, and the ability to effectively prioritize and manage a wide variety of tasks are essential.FUNDAMENTAL DUTIESDesign, develop, and implement stored procedures, functions, and other artifacts in T-SQL 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 methods.Create and maintain project documentation to successfully implement IT-based solutions, including project plans.Develop training materials focused on end-users for various business functions.Assist in the installation 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 BI team members on various aspects of BI development.Perform other duties and responsibilities as assigned.EDUCATION AND EXPERIENCE10+ 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 the complete SDLC lifecycle in this area, including but not limited to requirements gathering, data analysis, design, development, QA, and 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 and 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.Qualifications
SSASAdditional Information
All qualified applicants will receive consideration for employment without regard to race, color, religion, place of origin, ethnic origin, national origin, ancestry, age, sex, sexual orientation, gender identity, transgender status, genetic information, mental or physical disability, marital status, pregnancy, veteran status, or any other characteristic protected by applicable national, state, or local law.
#J-18808-Ljbffr