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
1 day ago