Azure Analytics Developer
Brampton, ON • Direct Hire • October 21, 2024 • 73229
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