
Senior Data Engineer
Trilogy Federal
full-time
Posted on:
Location Type: Remote
Location: Colorado • Connecticut • United States
Visit company websiteExplore more
Salary
💰 $130,000 - $150,000 per year
Job Level
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