Azure Analytics Developer

Base Salary Range: $80000 - $115000

Job Title: Azure Analytics Developer
Job ID: 73229
Location: Brampton /Kanata / Montreal /Richmond, Bristish Columbia - Hybrid: 3 times a week onsite (Monday, Tuesday, and Thursday)


Overview:
Seeking an Azure Analytics Developer to be part of the Business Systems Team working to design and build reporting tools, information dashboards, data generators, and other end-user information portals or resources for existing and new systems hosted on-premise and in third-party IaaS/PaaS/SaaS clouds.


What you will be doing:

• Generate ad hoc operational reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts

• Integrate data from multiple sources to produce requested or required data elements

• Program and maintain report forms and formats, information dashboards, data generators, canned reports, and other end-user information portals or resources

• Create specifications for reports based on business requests

• Advise business groups by providing technical and strategic reports that identify and address business issues and opportunities

• Provide technical design, coding, testing, implementation, maintenance, system, and technical support for data initiatives using industry-standard ETL tools.

• Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ETL processes

• Present ETL documentation and designs to team members and convey complex information in a clear and concise manner

• Follow the release cycles and implement on-time delivery of bug fixes, change requests, and enhancements

• Provide on-call support in support of data solutions in production and support source upgrades, Hardware/Software upgrade projects with impact analysis, fixes and end-to-end testing

• Provide operational support on failures and outages

• Implement new technologies by participating in the assessment of tools, software, and technological practices

• Troubleshoot issues related to software, computing, storage, and networking

• Design training programs, create documentation and user guides, and deliver training to other Team Members

• Stay on top and showcase knowledge of the industry’s latest trends and technologies in Data Analytics

• Create and maintain requirements specifications, design/mapping specifications, and ETL documentation

• Collaborate with other teams, team members, and stakeholders

• Provide general Systems Analysis and Design support for other Business Systems activities as required

What you must have:

• Bachelor’s degree in Computer Engineering, Computer/Data Science or related discipline

• 5+ years of experience in Information Technology

• 3+ years of experience developing and maintaining data platforms using Azure

• 3+ years of experience developing and maintaining Operational Reports

• Experience in end-to-end implementation of Cloud data solutions using Azure including but not limited to Synapse Analytics, Databricks, Data Factory, Data Lake Analytics, Analysis Services, and Power

• Relational Database Experience (SQL Server)

• Critical Thinking, Strong problem-solving, and analytical skills

• Highly motivated, enthusiastic, and a positive thinker

• Successful candidates must obtain and hold security clearance at the reliability status level, and pass security assessment for the Controlled Goods Program (CGP)

Nice to have:

• Operational Reporting and Business Intelligence platforms: Power BI, Tableau, IBM Cognos, Crystal reports, and Microsoft BI (SSRS, SSIS, SSAS) are a plus or equivalent

• Source control tools (TFS, SVN, GIT, CVS or equivalent)

• Windows Azure, Azure DevOps, Azure Resources, Azure Security

• Good understanding and ability to apply various processes and Design Patterns

• Hands-on experience in Soap/Rest API/web service

• Experience with ERP, UKG, HR Systems, Time & Attendance Systems. Project Online, SharePoint Online, Salesforce, Banking Systems

• Good understanding and ability to apply various processes and Design Patterns

• Hands-on experience in Soap/Rest API/web service including hands-on experience in building point-to-point data integrations

• Relational Database Experience (SQL Server) - understanding of Data Modeling Concepts (Dimensional and Normalization), knowledge of OLAP structures, SQL Performance Tuning

• Understanding different types of storage and working with different kinds of data (structured, unstructured, metrics, logs)

• Experience using .NET/C#

• Understanding & Conveying Data Models and Data Architecture

 
Salary/Rate Range:  $80,000 - $115,000 annually CAD


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com