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
  

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 prerelease testing
  
• Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer
  
• Participate in knowledge transfer activities
  

Requirements

MANDATORY REQUIREMENTS:

• Demonstrated working knowledge of Power BI Desktop At least 2 years of experience
  
• Demonstrated working knowledge of SQL query languages (TSQL PLSQL) At least 4 years of experience
  
• Demonstrated working knowledge of DAX programming (At least 2 years of experience)
  
  

SKILLS AND KNOWLEDGE:

• Experience working in a business intelligence team/ environment developing and delivering business intelligence and/or analytical reports and dashboards
  
• Experience 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 reports
  
• Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports
  
• Experience 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
  
• Knowledge of ETL tools such as Azure Data Factory Microsoft SSDT.
  

Must haves:

• Demonstrated working knowledge of Power BI Desktop At least 2 years of experience
  
• Demonstrated working knowledge of SQL query languages (TSQL PLSQL) At least 4 years of experience
  
• Demonstrated working knowledge of DAX programming (At least 2 years of experience)