Remote Data Engineer — SSAS/SSIS & Power BI Specialist

Trilogy Federal; Northern (KY); Hybrid; USD 115,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Dental coverage

Vision coverage

Optional FSA

Paid parental leave

401(k) match

Paid time off

11 holidays

Life/AD&D insurance

Pet insurance

Phone stipend

Internet stipend

Tuition reimbursement

Job summary

Trilogy Federal is seeking a remote Data Engineer with expertise in SSAS, SSIS, and Power BI to support a federal client. The role emphasizes implementing SSAS, developing complex dashboards, and transforming raw data into actionable insights.

Candidates should have extensive SQL, cloud experience (AWS/Azure), and the ability to work independently while meeting evolving requirements. Ideal candidates will hold a bachelor’s degree, 8+ years of experience, and must be eligible for a Public Trust

Qualifications

• Minimum of 8 years of professional experience and a bachelor’s degree.
• Minimum of 6 years of experience with Java and JavaScript.
• Minimum of 3 years of experience with SQL.
• Define and develop new reporting and data queries using SQL, SSAS, and SSIS.
• Experience building both star and snowflake schemas.
• Working knowledge of tabular, relational, and multidimensional data models.
• Working knowledge of AWS and/or Azure cloud environments.
• Experience building complex dashboards and reports with Power BI.
• Expert-level understanding of ETL, data pipeline, and data warehousing concepts.

Responsibilities

• Implement a functional SSAS environment.
• Build and redesign reports for the Analysis Services environment.
• Collaborate with the 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.
• Document logical and physical data models.
• Document and update reporting environment data model.
• Develop new reports based on customer requirements.

Skills

SSIS

SSAS

Power BI

SQL

Java

JavaScript

ETL

Data warehousing

Dimensional modeling

AWS

Azure

Data modeling

Reporting

Education

Bachelor's degree

Tools

SQL Server

Azure Synapse

Job description

Trilogy Federal is seeking a remote Data Engineer with expertise in SSAS, SSIS, and Power BI to support a federal client. The role emphasizes implementing SSAS, developing complex dashboards, and transforming raw data into actionable insights.

Candidates should have extensive SQL, cloud experience (AWS/Azure), and the ability to work independently while meeting evolving requirements. Ideal candidates will hold a bachelor’s degree, 8+ years of experience, and must be eligible for a Public Trust