Trilogy Federal logo

Remote Data Engineer

Posted about 24 hours ago

RemoteWashington, D.C.SE115k - 130k USD
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. 

### 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.
    Trilogy Federal logo
    Trilogy Federal
    View company page

    Trilogy’s story began in 2009 when our founders decided to combine the best practices and lessons learned from working across both large and small organizations to launch a new company focused on delivering client-centric, high-quality solutions. Together, these leaders saw an opportunity to create a different type of company with the goal of supporting our Federal clients, with special emphasis on helping our nation’s Veterans. Influenced by two shared work experiences at other organizations, our company’s founders were determined to make the third chapter in their careers the very best it could be. They named this chapter Trilogy. Trilogy was founded with core value system that balances service delivery excellence with a people-centric culture. Building on our foundation of implementing, operating, and modernizing Financial Management systems, Trilogy has evolved to provide our clients and partners with a wide range of professional services via a collaborative, client-first approach to solving their most challenging problems. This approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results.

    Employees
    143
    Industry
    IT Services and IT Consulting
    Headquarters
    Arlington, Virginia
    Founded
    2009
    Company location
    1100 Wilson Blvd, 1100, Arlington, Virginia 22209, US
    Specialties
    Data & Analytics, Systems Integration, Systems Implementation, Healthcare Transformation, Government Services, Benefits Optimization, Process & Resource Optimization, Policy Reform, Organizational Change Management, Audit Support Services, Financial Management Modernization, Financial Reporting, Risk & Compliance, Financial Management Operations, Enterprise Data Management, Digital Workplace, and Emerging Technologies
    Apply smarter with Jobr

    Jobr aggregates jobs directly from company career portals — no middlemen. Our team applies on your behalf with AI-tailored resumes, reviewed by a human before submission.

    Direct from company career pages
    AI-personalised cover letters
    Human review before every submit
    Application tracking & follow-ups