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. 

• 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 

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.