Remote Data Engineer — SSAS, Power BI & ETL Expert

Trilogy Federal; United States; Remote; USD 115,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Paid time off

Holidays

Job summary

Trilogy Federal seeks an experienced Data Engineer to implement a functional SSAS environment, build reports, and design data models. You will work with a federal client remotely, applying tabular, relational, and multidimensional modeling to transform raw data into actionable insights.

Requirements include 8+ years in the field, strong SQL/JAVA/JAVAScript skills, and Power BI reporting experience. Cloud exposure (AWS/Azure) and ability to obtain Public Trust clearance are preferred.

Qualifications

• 8+ years of professional experience and a bachelor’s degree.
• 6+ years with JAVA and JAVA Script.
• 3+ years 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 understand of ETL, data pipeline, and data warehousing concepts.
• Self-starter able to work independently and within a team.
• Flexibility and the ability to react to rapidly changing requirements.
• The ability to obtain a Public Trust clearance.

Responsibilities

• Implement a functional SSAS environment.
• Build and redesign reports transitioning to an analysis services environment.
• Collaborate with client’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.

Skills

JAVA

JavaScript

SQL

Power BI

ETL/Data Warehousing

Data Modeling

SSAS

SSIS

Star/Snowflake Schemas

Cloud (AWS/Azure)

Public Trust Clearance

Dashboards/Reports

Education

Bachelor’s Degree

Tools

SQL Server

SSAS

SSIS

Job description

Trilogy Federal seeks an experienced Data Engineer to implement a functional SSAS environment, build reports, and design data models. You will work with a federal client remotely, applying tabular, relational, and multidimensional modeling to transform raw data into actionable insights.

Requirements include 8+ years in the field, strong SQL/JAVA/JAVAScript skills, and Power BI reporting experience. Cloud exposure (AWS/Azure) and ability to obtain Public Trust clearance are preferred.