A Note on Assignment Type :
This position is currently listed as Onsite working 7.25 hours per calendar day sometime between 8 : 00 AM and 5 : 00 PM (excluding breaks) Monday to Friday inclusive unless otherwise identified.
Experience and Skill Set Requirements
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. Services required beyond this date will be acquired through a Request for Services (RFS) issued under the successor VOR.
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 Paginated 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
- Demonstrated work knowledge of ETL tools such as Microsoft Azure Data Factory Data Bricks and IBM InfoSphere DataStage as well as data modelling methodologies. At least 2 years experience
Desired Skills and Experience
Experience working in a business intelligence team / environment developing and delivering business intelligence and / or analytical reports and dashboardsExperience working with Power BI Desktop and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reportsExperience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reportsExperience performing troubleshooting of SQL queries business intelligence and analytical reports as well as performing data analysis to complete data validation and ensure report accuracy.Knowledge of Microsoft SQL Server and Oracle databasesKnowledge of ETL tools such as Azure Data Factory Microsoft SSDT IBM InfoSphere DataStage etc.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 / demonstrated ability using ETL tools such as Microsoft Azure Data Factory Data Bricks and IBM InfoSphere DataStage as well as data modelling methodologies. At least 2 years experienceCriteria 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 validationDemonstrated experience working within a team environment to troubleshoot and resolve technical problemsCriteria 3 : Communication Skills - 20 Points
Oral and written communication skills Interpersonal and consultative skills Facilitation skillsDemonstrated 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 membersExperience preparing documentationKnowledge Transfer
What needs to be KT
All documentation relating to the technology designs and technology knowledge specific to the candidates assignment All information gathered while working with vendors and internal solutions to be shared Any best practices work around lessons learned must be documentedCodesScriptsPower BI report and dashboard specifications (PBIX files)To whom
Project Manager / Team membersWhen
1 : 1 meetings / team meetings / documentation on SharePoint site throughout the duration of the project life cycle etc.MUST HAVES
Demonstrated working knowledge of Power BI Desktop and Power BI Paginated 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
Demonstrated work knowledge of ETL tools such as Microsoft Azure Data Factory Data Bricks and IBM InfoSphere DataStage as well as data modelling methodologies. At least 2 years experience
Key Skills
Cobol,Foreclosure Paralegal,Machinery Maintenance,Accounts Reconciliation,General Services,HR Recruitment
Employment Type : Full Time
Experience : years
Vacancy : 1