Data Engineer
Trilogy Federal
full-time
Posted on:
Location Type: Remote
Location: Remote • Colorado, Connecticut, Florida, Illinois, Maryland, New York, South Carolina, Texas, Virginia, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $70,000 - $80,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AWSAzureCloudETLReactSQLSSIS
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
- A bachelor’s degree
- Minimum of 3 years of relevant professional experience
- The ability to obtain a Public Trust clearance
- 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
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
SQLSSASSSISETLdata pipelinedata warehousingtabular data modelingrelational data modelingmultidimensional data modelingPower BI
Soft skills
self-starterindependent workteam collaborationflexibilityadaptability
Certifications
bachelor's degreePublic Trust clearance