Analyst, Databases

• The tools you need to succeed – including the tools for the job as well as training and development programs
• A successful and knowledgeable team to be part of and learn from
• Competitive base pay plus the ability to earn more tied to your success – the only limit is your potential

• A great benefits plan for you / your family
• Career paths so you can advance in the company
• Awarded Canada’s Most Admired Corporate Cultures with a proudly diverse and inclusive team

• Supports and contributes to evolving the Enterprise Data Strategy and Architecture
• Working knowledge of traditional database systems applying ETL and data movement solutions to support target data models.
• Ability to enhance and develop detailed architecture and technical design documentation and transitional and data flows
• Ability to work as a lead both independently and / or as a team member to solution design, including work by Vendors & Internal Partners
• Maintain COTS (Commercial off-the-shelf) applications including interfaces, configuration, database tuning and GUI
• Monitor vendor bulletins, sites, publication and users group for enhancements and release.
• Manage features and enhancement to mobile and web user applications
• Provide 2nd level support and triage assigned tickets based on priorities.
• Analyzing and improving current system integrations and migration strategies
• Identifying, debugging, and advising on system errors or architecture issues
• Work with project team members and business analysts to understand requirements and design solutions to support the project requirements
• Understand the software development life cycle, involve, and support each stage of SDLC
• Support offshore team overseeing all development activities.
• Ability to work in an Agile environment. Analyze issues with other team members and respond quickly to other business needs within the deadlines.
• Ability to communicate end to end data outcomes to all levels of the team hierarchy.
• Knowledge and know-how to troubleshoot potential issues and resolution
• Performs code reviews and makes sure development team is following standards. Ensures proper Test Coverage and Unit Testing is performed. Identify ways to utilize platform to improve productivity and make recommendations to support an organization scaling at a rapid pace
• Provide technical leadership, setting best practices (e.g., integration and application development, deployment, testing, iterative refinement).
• Self-sufficient, self-starters & quick learners on understanding Reliance’s current integration environment.

• College diploma or university degree in the field of computer science, information systems
• 5+ years of application development, configuration, and support experience
• Excellent understanding of application development environments, techniques, and the key operational activities to maintaining enterprise level applications.
• Knowledge on Enterprise Service Bus (ESB) Tools and Azure Pipelines
• Experienced with Azure Data tools such as Azure Storage accounts, Azure Data Factory, Azure Databricks, Azure Automation Accounts, Azure Key vault, Azure Synapse Analytics, Azure SQL Database, Azure Analysis Services and Azure Fabric Services.
• Experienced with MS SQL SSIS, MS SQL SSRS, oData, SOAP/REST API’s, BLOG storage, Runbooks, Notebooks, Functions and code version control GIT / GitHub and DevOps
• Knowledgeable C#, Microsoft ASP.NET Web Forms, JAVA, Phyton, Json
• Demonstrated experience working with large-scale, high-availability applications.
• Experience in Database Design and development with Business Intelligence using SQL Server 2016/2019, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema.
• Used Azure download/upload tasks to download and upload blobs.
• Create automated workflows with the help of triggers, runbooks and ETL sequence.
• Excellent time and workload management skills.
• Good knowledge of System Development Life Cycle (SDLC).
• Knowledge database structuring, optimization, tuning, analysis, and recommendation.
• Design, develop and implement complex database systems, programs, and applications
• Provide thought leadership with scoping solution design for process improvements, ERD diagrams, Database architecture, and documentation.
• Excellent interpersonal and team leadership skills
• Team player with good logical reasoning ability, coordination and able to complete projects independently.
• Can act as a mentor to their fellow team members
• Fluent in written and spoken English
• Experience driving continuous improvement

Reliance Home Comfort