Azure Analytics Developer

Base Salary Range: $80000 - $115000

Job Title: Azure Analytics Developer
Job ID: 80777
Location: Brampton, Kanata, Montreal or Richmond, British Columbia - Hybrid 


Overview:
We’re on the hunt for an Azure Analytics Developer on our Business Systems Team at our Brampton, Kanata, Montreal or Richmond BC office. Supporting all three business areas in Geointelligence, Robotics & Space Operations, and Satellite Systems, our Corporate team knows from experience that working in a hands-on learning environment enables us to collaborate across disciplines and get the job done. From HR and Finance to IT and Communications, we are all committed to reaching new heights and advancing humanity’s place in the universe and here on Earth. We are 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, compute, storage and networking

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

• Stay on top and showcase knowledge in 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, 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 process 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 process 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 of different types of storage and working with different kinds of data (structured, unstructured, metrics, logs)

• Experience using .NET/C#

• Understanding & Conveying of Data Models and Data Architecture

SalaryRate 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