RQ07802 - Software Developer - Senior

• Create custom reports as required applying Microsoft Technologies including PowerBI
  
• Develop modify and debug SQL scripts in Microsoft SQL Server.
  
• Provide realistic work estimates to support project planning; capture business requirements and update business rules based on the requirements
  
• Use structured methodologies design best practices implement code that is of quality and clearly documented. The application should function as required without any defects.
  
• Conduct testing integration and deployment of the developed changes across the environment
  
• Review analyze and recommend solutions to any defects discovered in production
  
• Fully document all developed code and transition in a steady state to a fulltime resource.
  
  

Requirements

Technical Skills

• 10 years of experience with developing code in SQL and Azure SQL TSQL
  
• Indepth knowledge of onpremises SQL Server
  
• Demonstrated experience with power query/power pivot and being able to combine datasets from different sources
  
• Demonstrated experience with OnPremises data gateway
  
• Demonstrated experience with PowerBI and PowerBI best practices
  
• Demonstrated experience in enabling rolebased security in the reports by restricting access to information (recordbased access) and reports
  
• Demonstrated experience with deployment of Report into Azure infrastructure.
  
• Demonstrated ability to translate complex business requirements into technical solutions
  
• Analytical mind with a problemsolving aptitude
  
• Experience with UI Design Principles is an asset
  
• Familiar with Azure Streaming Analytics SQL Azure Event Hub
  
• Familiar with Data Lake Store (Gen 2) Data Factory
  
• Familiar with SSAS Partitioning
  

Design and Development Experience

• 10 years of technical data warehousing experience with a focus in the design and development of Business Intelligence
  
• Experience with Azure Analysis Services / SSAS (tabular/multidimensional) SQL Server Reporting Services (SSRS) and Power BI
  
• Experience with end to end management of the Software Development Life Cycle (SDLC)
  
• Demonstrated experience in design and data modeling of data warehouse (e.g. dimensional modeling) data cubes tabular models to support reporting both adhoc and canned reports.
  
• Demonstrated experience in design and development of data models for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) environments based on industry best practices.
  
• Demonstrated experience in design and development of visualizations for various reports/dashboards including near realtime to be shared with both B2B and B2C
  
• Demonstrated experience in building and deploying Mobile dashboards
  
• Familiar with design and development of ETL (Extract transform load) processes and validating data sources
  

Communication Skills

• Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
  
• Writing Business Requirements Document
  
• Ability to work with minimal supervision in an agile environment be an effective communicator with other team members and the business owners.
  
• A demonstrated team player with a proven track record for meeting deadlines
  
• Demonstrated experience in creating of conceptual logical and physical data documentation for knowledge retention and transfer.
  

Industry Experience

• Experience in working on multiyear projects
  
• Experience with building enterprise level reporting solutions that protect highsensitive information
  
• Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM architecture gating) an asset
  

MUST HAVES:

• 10 years of experience with developing code in SQL and Azure SQL TSQL
  
• Demonstrated experience with power query/power pivot and being able to combine datasets from different sources
  
• Demonstrated experience with PowerBI and PowerBI best practices
  
• 10 years of technical data warehousing experience with a focus in the design and development of Business Intelligence