Remote Data Engineer

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 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.

Trilogy Federal is looking for a remote 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.

Trilogy Federal is looking for aremote 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.  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. 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 8 years of overall professional experience and bachelor’s degree

Minimum of 6 years of experience with JAVA and JAVA Script

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 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

Preferred Qualifications:

Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.

Preferred VA experience but not required

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.

8+ years overall experience with bachelor's degree; 6+ years Java/JavaScript; 3+ years SQL; SSAS, SSIS, Power BI; star/snowflake schemas; AWS/Azure; ability to obtain Public Trust clearance.

Key Responsibilities

• implementing SSAS environments
• building reports
• documenting data models

Skills & Tools

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, Java, JavaScript, SQL, AWS, Azure

Job Details

• Category: Data and Analytics
• Seniority: Senior Level
• Commitment: Full Time
• Workplace: Remote — United States
• Salary: USD 115,000 – 130,000 / year
• Languages: English

Benefits

• 401k matching
• Generous paid time off
• Tuition reimbursement
• Retirement plan
• Generous parental leave

About Trilogy Federal

A consulting firm delivering innovative solutions for financial management, healthcare, and government industries. — Industry: Information Technology