RQ07802 Software Developer

This is a contract position for a Software Developer - Senior for our public sector client.

Work location : 5700 Yonge Street, 9th Floor

Duration : Six Months

7.25 hours / day

This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages

Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities

• 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 full-time resource.

Qualifications

Technical Skills

• 10+ years of experience with developing code in SQL and Azure SQL, T-SQL
• In-depth knowledge of on premise SQL Server
• Demonstrated experience with power query / power pivot, and being able to combine datasets from different sources
• Demonstrated experience with On-Premise data gateway
• Demonstrated experience with PowerBI and PowerBI best practices
• Demonstrated experience in enabling role-based security in the reports by restricting access to information (record-based 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 problem-solving 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 ad-hoc and canned reports.
• Demonstrated experience in design and development of data models for OLTP (On-line Transaction Processing) and OLAP (On-line Analytical Processing) environments based on industry best practices.
• Demonstrated experience in design and development of visualizations for various reports / dashboards including near real-time 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 multi-year projects
• Experience with building enterprise level reporting solutions that protect high-sensitive information
• Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM, architecture gating) an asset

Summary

If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees.

In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming;

Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle.

We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.

ca to ensure their ability to fully participate in the interview process.