Director, Business Intelligence
Model N
AzureSQL
Financial Data Analyst
Trilogy Federal
full-time
Posted on:
Origin: • 🇺🇸 United States • Virginia
Visit company websiteSalary
💰 $80,000 - $110,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AzureMS SQL ServerOracleSQL
About the role
- Support external customers with analyzing current data and reporting business needs, developing reporting requirements, implementing data management and reporting solutions, and supporting end users.
- Provide federal financial data subject matter expertise using Momentum Financials.
- Develop reports and data management tools using Power BI, Pyramid Analytics, MS SQL Server, Oracle, Azure Synapse, Databricks, Microsoft Office Suite, SQL, and DAX.
- Review and analyze data and audit requests from end users and compile the requested data from Momentum financials and other VA systems.
- Develop and update guides, training tools, reconciliation approaches, and standard operating procedures for reports and data tools from Momentum financials and other VA systems.
- Conduct analysis on the quality of data in Momentum financials and test the migration of data from FMS and other VA systems to Momentum financials.
- Provide functional support for system testing, such as developing test scenarios and documentation, performing validation testing for Momentum Financials reports as well as any VA-specific reports and data sources.
- Support new client-requested initiatives, such as analyzing reporting requirements, developing design documentation, and training and supporting end users with system functionality.
- Attend and participate in meetings with client stakeholders. Potentially lead client meetings.
Requirements
- 4+ years of experience as a Business Analyst or Developer supporting reporting and data management efforts, including requirements analysis, report design, validation, and testing.
- 4+ years of experience with Momentum Financials data and table structures.
- Experience with some or all of the following tools: Power BI, Pyramid Analytics, MS SQL Server, Oracle, Azure Synapse, Databricks, Microsoft Office Suite, SQL, and DAX.
- Ability to effectively communicate and interact with senior level management and clients.
- Strong written and oral communication skills.
- An outstanding ability to work independently, establish priorities, and meet deadlines.
- 4-year degree in Information Systems, Computer Science, Accounting, or similar.
- Ability to obtain a Public Trust clearance.
- VA experience preferred.
- Experience with Federal finance and accounting processes, including monthly reporting, budget execution, and financial audit responses.
- Experience working in an Agile environment (SAFe preferred).
