Trilogy Federal

Senior Data Engineer

Trilogy Federal

full-time

Posted on:

Location Type: Remote

Location: ColoradoConnecticutUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $130,000 - $150,000 per year

Job Level

Tech Stack

About the role

  • 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

Requirements

  • Minimum of 10 years of overall professional experience and a master's degree (OR 12 years of experience and a bachelor’s degree)
  • Bachelor’s degree must be in Computer Science
  • Expert-level experience building databases and creating logic queries
  • 7+ years’ programming in SQL, PL/SQL
  • 7+ years’ working experience with SSAS, SSIS, SSRS
  • 7+ years’ deep database knowledge with either SQL server or Oracle
  • Experience building both star and snowflake schemas
  • Working knowledge of tabular, relational, and multidimensional data models
  • Excellent written and verbal communication skills
  • The ability to obtain a Public Trust clearance
Benefits
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPL/SQLSSASSSISSSRSdatabase designdata modelingstar schemasnowflake schemalogical data models
Soft Skills
written communicationverbal communication
Certifications
master's degreebachelor's degree