Remote Data Engineer

Posted 4 Days Ago
Hiring Remotely in Washington, DC, USA
In-Office or Remote
115K-130K Annually
Senior level
Information Technology • Financial Services
The Role
Build and implement SSAS environments, redesign reports, develop SQL queries and Power BI dashboards, and apply tabular, relational, and multidimensional data modeling. The role transforms and pre-aggregates data, documents logical and physical models, develops reporting solutions, and collaborates with federal client technical teams. Expertise in ETL, data pipelines, data warehousing, SQL, SSIS, SSAS, Power BI, and cloud environments is required.
Summary Generated by Built In
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.

Skills Required

  • Bachelor's degree
  • At least 8 years of overall professional experience
  • At least 6 years of experience with Java and JavaScript
  • At least 3 years of experience with SQL
  • Experience developing reporting and data queries using SQL, SSAS, and SSIS
  • Experience building 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
  • Ability to work independently and within a team
  • Flexibility and ability to respond to changing requirements
  • Ability to obtain a Public Trust clearance
  • Experience with financial data modeling and analytics, including budgeting, financial management, or personnel environments
  • Veterans Affairs experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Arlington, VA
121 Employees
Year Founded: 2009

What We Do

Founded in 2009 and headquartered in the Washington DC metro area, Trilogy Federal is a verified service-disabled, veteran-owned small business (SDVOSB) providing financial management and information technology consulting to the Federal government. Trilogy has an extensive and distinctive history helping Federal clients achieve their financial management goals. Our leadership team has over 60 years of combined experience supporting Federal financial management initiatives. Our professional staff specializes in federal financial management and maintains certifications in several relevant programs. Trilogy strives to provide its clients with a flexible and comprehensive approach to financial management with the ultimate goal of fiscal compliance and audit readiness. The Trilogy approach starts with assessing the financial management solution and determining its effectiveness in capturing functional business requirements and meeting agency reporting requirements. Since our inception, we have assisted our federal partners in migrating to new financial management systems or enhancing existing systems to meet new requirements. Ultimately, success lies in the data, where Trilogy utilizes industry leading Business Intelligence and Business Performance Management tools to assess the overall effectiveness of financial business operations and to produce timely, reliable and value-added financial reporting. We have a proven track record of successful implementations for agencies large and small.

Similar Jobs

CrowdStrike Logo CrowdStrike

Senior Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
140K-215K Annually

CrowdStrike Logo CrowdStrike

Data Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
120K-180K Annually

Rula Logo Rula

Senior Data Engineer

Healthtech • Social Impact • Software • Telehealth
Remote
United States
620 Employees
152K-186K Annually

CrowdStrike Logo CrowdStrike

Infrastructure Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
100K-155K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account