A Note on the VOR Master Service Agreement:
The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027. Extension(s) are only allowed using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause.
The start date is subject to change based on security clearances and contract signing timelines.
Experience and Skillset Requirements
Mandatory Requirements
- Demonstrated working knowledge of Power BI Desktop and Power BI Report Builder [At least 2 years of experience]
- Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
- Demonstrated working knowledge of DAX programming (At least 2 years of experience)
Desired Skills and Experience
- Experience building, testing and implementing complex reports, dashboards, and other objects
- Provide technical guidance and subject matter expertise on report implementation to OPS staff
- Building data models optimized for business intelligence and analytic functions
- Financial Data reporting and data reconciliation
- Prototyping to develop business requirements for future implementation
- Analyze, Design, Build and Test databases based on business requirements
- Analyze, Design, Build and Test Reports, Dashboards and other objects
- Design functional test and technical deployment strategies
- Research, document, prototype, design, build, test and implement business requirements for advanced business intelligence and analytic capabilities
- Design, build and deploy data models optimized for business intelligence and analytics
- Analyze, Design, Build and Test data models and integration with third party systems
- Conduct research and prototyping of new business intelligence and analytics capabilities to support OPS business requirements
Resumes Evaluation/Criteria:
Criteria 1: Technical Knowledge – 50 Points
- Experience / demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)
- Experience / demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)
- Experience working with ETL tools, such as Azure Data Factory, Microsoft SSDT
Criteria 2: Analytical and Problem Solving Skills – 30 Points
- Experience / demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment / team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)
- Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation
- Experience building, testing and implementing complex reports, dashboards, and other data visualizations
Criteria 3: Communication Skills – 20 Points
- Oral and written communication skills, interpersonal and consultative skills, facilitation skills
- Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members
- Experience preparing documentation and providing knowledge transfer
Knowledge Transfer
What needs to be KT
- All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment. All information gathered while working with vendors and internal solutions to be shared. Any best practices, work around, lessons learned must be documented
- Codes
- Scripts
- Power BI report and dashboard specifications (PBIX files)
To whom
- Project Manager / Team Members
When
- 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle, etc.
