RQ11239 Report Developer Senior

Scope:

• Provide planning assessment and development effort to complete the migration of approximately 270 operational reports from Courts legacy systems to new CDT solution.
  
• Work with Project Manager and Business Areas to evaluate and modernize reports where applicable.
  
• Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
  
• Work with project team to complete all relevant and required documentation such as knowledge transfer and communication to support the completion of the project
  

Assignment Deliverables:

• Participate in reporting needs assessment to understand the functionality and design of the current operational reports in use
  
• Perform assessment and define approach in collaboration with project team and stakeholder to migrate operational reports to appropriate CDT solution standard reporting features or to a Power BI tool (i.e. Desktop or Report Builder)
  
• Perform design and development activities to migrate operational reports to Power BI in alignment with OPS Standards and Guidelines (i.e. AODA WCAG 2.0 Level AA)
  
• Perform troubleshooting and apply corrective actions to resolve issues with migrated reports and dashboards discovered during pre-release testing
  
• Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer
  
• Participate in knowledge transfer activities
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• 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)
  

Skill Set 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
  

Technical Knowledge:

• 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
  

Analytical and Problem Solving Skills:

• 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
  

Communication Skills:

• 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
  

Required Skills:

Experience and Skill Set Requirements: Must Haves: 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) Skill Set 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 Technical Knowledge: 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 Analytical and Problem Solving Skills: 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 Communication Skills: 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

Employment Type : Full Time
Experience: years
Vacancy: 1