

SSAS Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an SSAS Engineer with a contract length of over 6 months, offering a pay rate of $160,000 - $170,000 per year. It requires 12+ years of experience, SQL Server expertise, and Microsoft certifications, with remote work in the U.S.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
727
🗓️ - Date discovered
May 10, 2025
🕒 - Project duration
More than 6 months
🏝️ - Location type
Remote
📄 - Contract type
Unknown
🔒 - Security clearance
Yes
📍 - Location detailed
United States
🧠 - Skills detailed
#Agile #Base #"ETL (Extract #Transform #Load)" #Data Analysis #SQL Server #Cloud #Transformers #Data Security #SSIS (SQL Server Integration Services) #Security #AWS (Amazon Web Services) #Computer Science #Indexing #Data Engineering #Database Performance #SQL (Structured Query Language) #Azure #Complex Queries #Data Modeling #Project Management #SSAS (SQL Server Analysis Services) #BI (Business Intelligence)
Role description
Overview
GovCIO is seeking a talented SSAS Engineer to join our team. This role involves designing, developing, and maintaining SSAS solutions, including OLAP cubes and tabular models, to enhance our data analytics capabilities. The ideal candidate will have experience in SQL Server, data modeling, and performance optimization. This position will be fully remote located within the United States.
Please note : The contract has been awarded; however, this position remains unfunded and is contingent upon funding release.
Responsibilities
• Develop and maintain SSAS cubes and tabular models to support business intelligence reporting.
• Design ETL processes using SQL Server Integration Services (SSIS) for efficient data flow.
• Collaborate with data analysts, engineers, and business stakeholders to define reporting needs.
• Ensure performance optimization of SSAS solutions, including indexing and partitioning strategies.
• Implement and maintain data security and role-based access controls within SSAS.
• Troubleshoot SSAS-related issues and provide ongoing support for BI solutions.
Qualifications
Required Skills and Experience
• Bachelor's degree in computer science, Information Technology or a related field.
• 12+ years of relevant experience, or equivalent professional expertise.
• Microsoft certifications in SQL Server or Azure Data Engineering.
• Experience with cloud-based analytics solutions (Azure, AWS).
• Optimizing SSAS models for efficiency and performance tuning.
Preferred Skills And Experience
• Familiarity with Agile methodologies and project management tools.
• Certifications in relevant technologies.
• Designing and managing multidimensional and tabular models.
• Writing complex queries and optimizing database performance.
• Querying OLAP cubes and tabular models.
Clearance Required
Ability to obtain and maintain a Suitability/Public Trust clearance.
Company Overview
GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.
But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.
Posted Pay Range
The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an "at-will position" and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.
Posted Salary Range
USD $160,000.00 - USD $170,000.00 /Yr.
Overview
GovCIO is seeking a talented SSAS Engineer to join our team. This role involves designing, developing, and maintaining SSAS solutions, including OLAP cubes and tabular models, to enhance our data analytics capabilities. The ideal candidate will have experience in SQL Server, data modeling, and performance optimization. This position will be fully remote located within the United States.
Please note : The contract has been awarded; however, this position remains unfunded and is contingent upon funding release.
Responsibilities
• Develop and maintain SSAS cubes and tabular models to support business intelligence reporting.
• Design ETL processes using SQL Server Integration Services (SSIS) for efficient data flow.
• Collaborate with data analysts, engineers, and business stakeholders to define reporting needs.
• Ensure performance optimization of SSAS solutions, including indexing and partitioning strategies.
• Implement and maintain data security and role-based access controls within SSAS.
• Troubleshoot SSAS-related issues and provide ongoing support for BI solutions.
Qualifications
Required Skills and Experience
• Bachelor's degree in computer science, Information Technology or a related field.
• 12+ years of relevant experience, or equivalent professional expertise.
• Microsoft certifications in SQL Server or Azure Data Engineering.
• Experience with cloud-based analytics solutions (Azure, AWS).
• Optimizing SSAS models for efficiency and performance tuning.
Preferred Skills And Experience
• Familiarity with Agile methodologies and project management tools.
• Certifications in relevant technologies.
• Designing and managing multidimensional and tabular models.
• Writing complex queries and optimizing database performance.
• Querying OLAP cubes and tabular models.
Clearance Required
Ability to obtain and maintain a Suitability/Public Trust clearance.
Company Overview
GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.
But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.
Posted Pay Range
The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an "at-will position" and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.
Posted Salary Range
USD $160,000.00 - USD $170,000.00 /Yr.