Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

RQ08447 - Software Developer - Senior (SQL and AZURE)

Remote: 
Full Remote
Contract: 
Fixed term
Experience: 
Expert & Leadership (>10 years)
Work from: 
Canada

Offer summary

Qualifications:

10+ years of experience in SQL and Azure, In-depth knowledge of Azure PaaS data services, Experience with data warehousing and BI solutions, Strong understanding of software development life cycle.

Key responsabilities:

  • Review and update existing code architecture
  • Develop new features and enhancements as required
  • Create custom reports and conduct testing
  • Document all developed code and transition to full-time resource
S M Software Solutions Inc logo
S M Software Solutions Inc SME https://www.smsoftconsulting.com/
51 - 200 Employees
About S M Software Solutions Inc
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.
See all jobs

Job description

If you are interested kindly send the updated resume at [email protected] by Tuesday, January 21, 7:00 AM EST if that interests you and matches your profile.

Job Title: RQ08447 - Software Developer - Senior
Client: Ministry of Health
Work Location: 5700 Yonge Street., Toronto, Ontario, Hybrid
Estimated Start Date: 2025-04-01
Estimated End Date: 2026-04-05
#Business Days: 500.00
Extension: Probable after the initial mandate
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must Have
  • 10+ years of experience with developing code in SQL and Azure SQL, T-SQL, Azure Streaming Analytics SQL
  • In-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory
  • In-depth knowledge of on premise SQL Server
Description
  • Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability requirements
  • Code enhancements to existing features and new features as per approved requirements and design direction
  • 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. The application must operate with the Operating System (OS) and other peripherals as identified
  • Create custom reports as required, applying Microsoft Technologies
  • 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.
Experience and Skill Set Requirements
Design and Development Experience
  • 10+ years of experience with developing code in SQL and Azure SQL, T-SQL, Azure Streaming Analytics SQL
  • In-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory
  • In-depth knowledge of on premise SQL Server
  • In-depth knowledge of Azure PaaS data streaming services such as Azure Event Hub, Streaming Analytics
  • Familiar with SSAS Partitioning
  • Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources
  • Writing Python and SQL script for custom Computer Aided Dispatch (CAD) installations
  • Demonstrated experience with Datafactory, On-Premise data gateway
  • Familiar with PowerBI best practices
  • Experience with and knowledge of UI Design Principles
  • Experience in SOAP and REST web services for processing real-time data streams
  • 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 
35%
Technical Skills
  • 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
  • End to end management of the Software Development Life Cycle (SDLC) for Computer Aided Dispatch (CAD)
  • Developing process models and ongoing analysis of program effectiveness for Computer Aided Dispatch (CAD),
  • 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 ETL (Extract, transform, load) processes, and validating data sources
  • 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 architecting, design, and building of dynamic, real-time analytics pipelines and dashboards using visualization tools such as PowerBI
  • Demonstrated experience in building and deploying Mobile dashboards
35%
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, Data Sharing Agreements,
  • Strong consulting skills to engage with all stakeholders, lead meetings with internal and external clients to gather and document business requirements.
  • 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.
20%
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 OPS governance methodologies (e.g. UPM, architecture gating)
10%

Note:
This position is currently listed as "Hybrid"; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.
Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. HSC may exercise its option(s) to extend the SOW beyond April 5, 2026, for up to one additional extension term of one year. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.
The resource needed till March 31, 2027, will include an option to extend, at the same rate, till March 31, 2027 if Tender_12075 Managed Service Provider for Contingent IT Resources is also extended for a further one year, else an RFS under the Successor VOR will be issued for the services required April 5, 2026 to March 31, 2027.
  • Hybrid - Candidate must be able to work 3 days onsite and 2 days remote

Required profile

Experience

Level of experience: Expert & Leadership (>10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Microsoft AzureAzure Synapse AnalyticsSQL (Programming Language)PowerpivotAzure Data FactorySQL Server Reporting ServicesAzure Event HubsData ModelingMicrosoft Analysis ServicesSoap NotePower BIOracle OLAPVisualizationPowerqueryDashboardMicrosoft SQL ServersData WarehousingETL (Extract Transform Load)Data LakesSQL AzureDigital DashboardsBusiness IntelligenceAgile Software Development

Other Skills

  • Social Skills
  • Problem Solving
  • Communication
  • Negotiation
  • Teamwork
Are you interested?

Software Engineer Related jobs

See more Software Engineer jobs