Senior Data Engineer

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. They are looking for a remote Senior Data Engineer to support their federal client by implementing a functional SSAS environment and transforming raw data into meaningful business decisions.

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

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
• Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment
• Preferred VA experience