Trilogy Federal is looking for a Data Engineer to support their federal client by implementing a functional SSAS environment, building and re-designing reports, and transforming raw data into meaningful business decisions.
Requirements
- 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
Responsibilities
- Implement a functional SSAS environment.
- Building and re-designing a set of reports that need to transition to an analysis services environment.
- 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
Other
- Minimum of 3 years of relevant professional experience
- The ability to obtain a Public Trust clearance
- Self-starter able to work independently and within a team
- Flexibility and the ability to react to rapidly changing requirements
- Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
