Sonoma Consulting Inc.
Consulting & Professional ServicesDirect SmartRecruiters career site

BI- SSAS developer

Location
New Kensington, PA · On-site
Job type
Full-time
Level
Director
Experience
10+ years
Listed
Today

Skills & highlights for this role

  • SSAS
  • SSIS
  • T-SQL
  • MDX
  • DAX

Also useful

  • SSRS
  • data warehousing
  • ERP data integration
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

The core responsibility of the Senior 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 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.

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
  • 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 BI team members on the various aspects of BI development
  • Other duties and responsibilities performed as assigned.

Education and Experience

  • 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.

About the Company

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was 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 which range from entrepreneurial start-ups to Global Fortune 500.

Sonoma Consulting has a culture which is very distinct, professional, experienced and progressive. We take pride in providing quality consultants to reputable clients in order to ensure a mutually beneficial relationship. Our team is very results driven for our clients and candidates being passionate about the right people with the right companies. We fully 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 Honesty
  • Commitment to excellence
  • Accountability to the employees, consultants and customers we work with
  • Community and Diversity
Read the original posting

From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this BI- SSAS developer role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the BI- SSAS developer job at Sonoma Consulting Inc. located?

This BI- SSAS developer position at Sonoma Consulting Inc. is located in New Kensington, PA (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.

What qualifications are required for BI- SSAS developer at Sonoma Consulting Inc.?

For the BI- SSAS developer role, Sonoma Consulting Inc. highlights 10+ years of relevant experience; experience with SSAS, SSIS, T-SQL, MDX, DAX. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the BI- SSAS developer position at Sonoma Consulting Inc.?

This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.