- 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