Primary 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
Minimum Requirements:
- Minimum of 10 years of overall professional experience and a master's degree (or 12 years of experience and a bachelor’s degree)
- 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
Preferred Qualifications:
- Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
- Preferred VA experience
Benefits (including but not limited to):
- 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
Top Skills
What We Do
Founded in 2009 and headquartered in the Washington DC metro area, Trilogy Federal is a verified service-disabled, veteran-owned small business (SDVOSB) providing financial management and information technology consulting to the Federal government. Trilogy has an extensive and distinctive history helping Federal clients achieve their financial management goals. Our leadership team has over 60 years of combined experience supporting Federal financial management initiatives. Our professional staff specializes in federal financial management and maintains certifications in several relevant programs.
Trilogy strives to provide its clients with a flexible and comprehensive approach to financial management with the ultimate goal of fiscal compliance and audit readiness. The Trilogy approach starts with assessing the financial management solution and determining its effectiveness in capturing functional business requirements and meeting agency reporting requirements. Since our inception, we have assisted our federal partners in migrating to new financial management systems or enhancing existing systems to meet new requirements. Ultimately, success lies in the data, where Trilogy utilizes industry leading Business Intelligence and Business Performance Management tools to assess the overall effectiveness of financial business operations and to produce timely, reliable and value-added financial reporting. We have a proven track record of successful implementations for agencies large and small.
