Senior Data Engineer
Trilogy Federal
•
Washington, DC
0
0
0
0
Not Applicable
Posted March 29, 2026
Job link
Thinking about this job
Responsibilities
Commitments
Responsibilities
- Implement a functional SSAS environment.
- Building and re-designing a set of reports that need to transition to an analysis services environment.
- Work with our customer’s technical team to identify initial requirements.
- Apply tabular, relational, and multidimensional data modeling methodologies.
- Transform raw data into meaningful business decisions and pre-aggregate data for optimal results.
- Document logical and physical data models.
- Document and update reporting environment data model
- Develop new reports based on customer requirements
Commitments
The ability to obtain a Public Trust clearance
Optional FSA
Safe Harbor 401(k) with employer contributions 100% vested from day 1
No cost group term life/AD&D plan, and optional supplemental coverage
Monthly phone and internet stipend
Not Met Priorities
What still needs stronger evidence
Requirements
- Minimum of 10 years of overall professional experience and a master's degree (OR 12 years of experience and a bachelor’s degree)
- Expert-level experience building databases and creating logic queries
- 7+ years’ programming in SQL, PL/SQL
- 7+ years’ working experience with SSAS, SSIS, SSRS
- 7+ years’ deep database knowledge with either SQL server or Oracle
- Experience building both star and snowflake schemas
- Working knowledge of tabular, relational, and multidimensional data models
- Excellent written and verbal communication skills
- The ability to obtain a Public Trust clearance
Preferred Skills
- The ability to obtain a Public Trust clearance
- Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
- Preferred VA experience
- Experience with C programming or equal knowledge or experience
Education
- (Required) – Minimum of 10 years of overall professional experience and a master's degree (OR 12 years of experience and a bachelor’s degree)
- (Not required) – Bachelor’s degree must be in Computer Science
Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our collaborative, client-first service approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results.
Trilogy Federal is looking for a remote Senior Data Engineer with working knowledge of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI to join our growing company and support our federal client. Our ideal candidate will contribute effectively towards our team goals and ensure exceptional customer experience for our client and their employees.
We are seeking an experienced candidate who has prior implementation skills to implement a functional SSAS environment. The selected candidate must have working knowledge of tabular and multidimensional data models, in addition to experience documenting logical and physical data models.
Primary Responsibilities:
Implement a functional SSAS environment.
Building and re-designing a set of reports that need to transition to an analysis services environment.
Work with our customer’s technical team to identify initial requirements.
Apply tabular, relational, and multidimensional data modeling methodologies.
Transform raw data into meaningful business decisions and pre-aggregate data for optimal results.
Document logical and physical data models.
Document and update reporting environment data model
Develop new reports based on customer requirements
Minimum Requirements:
Minimum of 10 years of overall professional experience and a master's degree (OR 12 years of experience and a bachelor’s degree)
Bachelor’s degree must be in Computer Science
Expert-level experience building databases and creating logic queries
7+ years’ programming in SQL, PL/SQL
7+ years’ working experience with SSAS, SSIS, SSRS
7+ years’ deep database knowledge with either SQL server or Oracle
Experience building both star and snowflake schemas
Working knowledge of tabular, relational, and multidimensional data models
Excellent written and verbal communication skills
The ability to obtain a Public Trust clearance
Preferred Qualifications:
Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
Preferred VA experience
Experience with C programming or equal knowledge or experience
Benefits (including but not limited to):
Health, dental, and vision plans
Optional FSA
Paid parental leave
Safe Harbor 401(k) with employer contributions 100% vested from day 1
Paid time off and 11 paid holidays
No cost group term life/AD&D plan, and optional supplemental coverage
Pet insurance
Monthly phone and internet stipend
Tuition and training reimbursement
Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.
Trilogy Federal is looking for a remote Senior Data Engineer with working knowledge of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI to join our growing company and support our federal client. Our ideal candidate will contribute effectively towards our team goals and ensure exceptional customer experience for our client and their employees.
We are seeking an experienced candidate who has prior implementation skills to implement a functional SSAS environment. The selected candidate must have working knowledge of tabular and multidimensional data models, in addition to experience documenting logical and physical data models.
Primary Responsibilities:
Implement a functional SSAS environment.
Building and re-designing a set of reports that need to transition to an analysis services environment.
Work with our customer’s technical team to identify initial requirements.
Apply tabular, relational, and multidimensional data modeling methodologies.
Transform raw data into meaningful business decisions and pre-aggregate data for optimal results.
Document logical and physical data models.
Document and update reporting environment data model
Develop new reports based on customer requirements
Minimum Requirements:
Minimum of 10 years of overall professional experience and a master's degree (OR 12 years of experience and a bachelor’s degree)
Bachelor’s degree must be in Computer Science
Expert-level experience building databases and creating logic queries
7+ years’ programming in SQL, PL/SQL
7+ years’ working experience with SSAS, SSIS, SSRS
7+ years’ deep database knowledge with either SQL server or Oracle
Experience building both star and snowflake schemas
Working knowledge of tabular, relational, and multidimensional data models
Excellent written and verbal communication skills
The ability to obtain a Public Trust clearance
Preferred Qualifications:
Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
Preferred VA experience
Experience with C programming or equal knowledge or experience
Benefits (including but not limited to):
Health, dental, and vision plans
Optional FSA
Paid parental leave
Safe Harbor 401(k) with employer contributions 100% vested from day 1
Paid time off and 11 paid holidays
No cost group term life/AD&D plan, and optional supplemental coverage
Pet insurance
Monthly phone and internet stipend
Tuition and training reimbursement
Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.