1

Ssas Administrator Jobs (NOW HIRING)

MSSQL Database Administrator

San Diego, CA · On-site

$53 - $66.25/hr

Provide end-user training/support for accessing OLAP/SSAS via Pivot Tables & Power Query * Develop ... Ability to manage an IBM B2Bi PaaS installations (System Admin, Trading Partner Setup, Direct ...

SQL Database Administrator

Troy, MI · On-site

$47.50 - $59.25/hr

Title: Sr. SQL Database Administrator Location: Metro Detroit, MI Citizenship: U.S. Citizen ... maintaining SSAS. Ensure all database servers are backed up in a way that meets the business ...

SQL Database Administrator

Troy, MI · On-site

$47.50 - $59.25/hr

Title: Sr. SQL Database Administrator Location: Metro Detroit, MI Citizenship: U.S. Citizen ... SSAS. • Ensure all database servers are backed up in a way that meets the business's Recovery ...

Power BI, Performance Point, Excel Services, SSAS, SSIS, SSRS Qualifications * The SharePoint Administrator will have at least 3 years prior experience administering and maintaining SharePoint 2010 ...

SQL Database Admin

Chicago, IL · On-site

$51.50 - $64.50/hr

SQL Database Admin Location: Chicago, IL (onsite) Job Type: Full time * SQL Server 2022 ... SSRS,SSAS installation and configuration expertise * Experience in Handling Large databases

... SSAS)) database administrators for managing administrative operations of school district's Student System Power School, Data Warehouse, Laserfiche document management and other SQL Server based ...

MS SQL DBA Location: Melbourne, FL Duration: Permanent Description: Client that is seeking a MS SQL ... Familiarity with SSIS, SSAS, SSRS, Power BI, DAX, and Azure Synapse * Ability to think critically ...

Showing results 21-40

Ssas Administrator information

See salary details

$39K

$73.3K

$152.5K

How much do ssas administrator jobs pay per year?

As of Aug 16, 2026, the average yearly pay for ssas administrator in the United States is $73,281.00, according to ZipRecruiter salary data. Most workers in this role earn between $56,000.00 and $81,500.00 per year, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive as an SSAS administrator?

To thrive as a SSAS Administrator, you need strong expertise in Microsoft SQL Server Analysis Services (SSAS), multidimensional data modeling, and a solid understanding of database management, typically supported by a degree in computer science or information technology. Familiarity with tools like SQL Server Management Studio (SSMS), DAX/MDX scripting, and relevant Microsoft certifications such as MCSE: Data Management and Analytics is highly valuable. Attention to detail, problem-solving ability, and effective communication skills help distinguish top performers in this role. These skills ensure efficient data processing, accurate analytics, and seamless collaboration with business intelligence teams.

What is an SSAS administrator?

SSAS Administrators are IT professionals responsible for managing and maintaining SQL Server Analysis Services (SSAS) environments. Their duties include installing, configuring, monitoring, and optimizing SSAS servers and databases to ensure high availability and performance. They also handle security settings, backup and restore operations, and troubleshoot issues related to SSAS cubes and data processing. SSAS Administrators often collaborate with developers and business analysts to support business intelligence solutions and ensure data integrity.

What is the difference between Ssas Administrator vs Data Analyst?

AspectSsas AdministratorData Analyst
Required CertificationsSQL Server certifications, Microsoft certificationsData analysis certifications, Microsoft Excel, SQL certifications
Work EnvironmentIT departments, database management teamsBusiness units, analytics teams
Industry UsageData management, reporting, BI infrastructureData interpretation, reporting, insights

While both roles involve working with data and SQL Server tools, Ssas Administrators focus on managing and maintaining SQL Server Analysis Services environments, ensuring data models and cubes run efficiently. Data Analysts primarily analyze data to generate reports and insights. The roles often collaborate but have distinct focuses within data management and analysis.

What are the common challenges faced by an SSAS administrator when managing large-scale data models?

As an SSAS Administrator managing large-scale data models, one common challenge is optimizing performance while handling complex cube structures and large volumes of data. Administrators often need to balance processing times, query responsiveness, and resource usage, which can require deep knowledge of partitioning, indexing, and aggregation techniques. Additionally, ensuring data security and managing user permissions across different teams adds complexity. Regular monitoring and proactive maintenance are essential to prevent bottlenecks and downtime in production environments.
More about Ssas Administrator jobs
Infographic showing various Ssas Administrator job openings in the United States as of August 2026, with employment types broken down into 1% As Needed, 84% Full Time, 10% Part Time, 1% Temporary, and 4% Contract. Highlights an 92% Physical, 3% Hybrid, and 5% Remote job distribution, with an average salary of $73,281 per year, or $35.2 per hour.

MSSQL Database Administrator

ROHM Semiconductor

Santa Clara, CA • On-site

$59 - $73.75/hr

Full-time

Re-posted 11 days ago


Job description

ROHM Semiconductor has an immediate career opportunity for an MSSQL Database Administrator with experience managing EDI (EDIFACT/ANSIX12). This position will be responsible for the data integration via EDI and in-house MSSQL database. This opening can be filled in any one of the following locales: California - San Diego County, Orange/Los Angeles County, Santa Clara County, or Novi, Michigan . Ideally hybrid work schedule; fully remote may be considered. The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance.
Essential MS SQL SERVER RDMBS Duties and Responsibilities (80%)
  • Configure, tune, monitor, and maintain MS SQL Server 2008 R2 to 2016+.
  • Become in-house data expert to support employees and customer data analysis/report requests.
  • Develop and maintain ETL processes and procedures for applications using SQL Server Integration Services (SSIS)
  • Maintain data warehouses (OLAP, SSAS)
  • Provide end-user training/support for accessing OLAP/SSAS via Pivot Tables & Power Query
  • Develop ad-hoc queries and datasets for various management audits/requests
  • Work with users to explore ways we can use our existing technology stack (MS SQL Server, B2Bi, .NET) to automate their manual workflows
  • Develop and maintain stored procedures, views, and functions
  • Create reports and data models using SSRS and Power BI that meet business requirements
  • Create and maintain technical documentation
  • Pro-actively work with department to resolve problems and to cross-train other team members
  • Provide high-level MS SQL Server technical support for IT department.
  • Diagnose and resolve database access and performance issues
  • Work with IT department to test/update MS SQL Server disaster recovery plans

Essential EDI Duties and Responsibilities (20%)
  • Analysis of customer EDI/data specifications, business requirements, and integration needs to develop automated solutions to transfer customer data into MS SQL for transmission into our in-house MRP system.
  • Provide a point of contact for EDI vendor, Customers, In-house Staff and Overseas offices for EDI and general data transmission automation requests.
  • Monitor daily EDI data transmission over IBM VAN/B2Bi Mapping Engine.
  • Monitor customer direct data connections (AS2/SFTP/HTTPs/etc.).
  • Utilize IBM B2Bi PaaS solution to translate customer EDI documents into formats compatible with MS SQL.
  • Create EDI translation maps based on ANSI X12 and EDIFACT, to be run on IBM B2Bi PaaS.
  • Experience mapping Order and Financial EDI documents (ANSI X12: 820, 830, 862, 850, 856, 810, 820); (EDIFACT: ORDRSP, DELFOR, ORDERS, ORDRSP, DELJIT, DESADV, INVOIC)
  • Development of EDI reports for operations and management

QUALIFICATIONS
Education/Training:
  • Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
  • 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries
  • 2+ years of MS SQL Server 2008R2+Management (Users, Permissions, Schema Changes, Queries, Functions)
  • 2+ years of MS SQL Service 2008R2+Solutions using (SQL Server Integration Services, Analysis Services, Reporting Services)
  • 2+ years developing extraction, transformation, and loading("ETL") processes using SSIS and other 3rd party tools
  • 2+ years of EDI Management (Trading Partners, Maps, Direct Connections, AnsiX12, EDIFACT)
  • Desired: 2+ years of experience in a similar technical role with applicable Microsoft SQL Server and IBM B2Bi certifications

Background/Knowledge:
  • Ability to read/translate EDI ANSI X12/EDIFACT documents for development of ETL processing
  • Ability to build data algorithms for EDI forecast models (Cumulative Order Processing) or Consignment Inventory Management
  • Ability to manage an IBM B2Bi PaaS installations (System Admin, Trading Partner Setup, Direct Connection Setup, EDI Document Mapping, etc.)
  • Ability to manage a Microsoft SQL Server 2008R2 to 2016 installation (Users, Permissions, Schema Design, Auditing Logs, Backups/Restores)
  • Ability to develop new solutions using MS SQL Server tools (SSMS, SSIS, SSAS, SSRS)
  • Ad-hoc development of reports using various tools (Access, Excel, SQL Reporting Services, T-SQL)
  • MS Office Suite (expert in Excel) required
  • Sterling Gentran v3-5.x experience is a plus

Abilities/Attitude:
  • Ability to collect, analyze and translate business and user requirements into functional specifications
  • Ability to produce documentation for all aspects of job function
  • Ability to envision optimal system development and migration approaches
  • Flexibility and adaptability to changing priorities
  • Ability to work alone with minimal supervision
  • Must have the ability to work independently and as part of a team
  • Exceptional customer service, problem solving, and communication skills
  • Positive customer service attitude while interacting with users
  • Strong written, verbal, listening communication skills; communicate effectively with internal and external customers
  • Stay abreast on new technologies

If you would like to contact us regarding the accessibility of our website or need assistance or accommodation to complete the application process, you may contact Human Resources at 858-625.3600 and leave a message that includes your name and phone number. This contact information is for accommodation requests only.