Azure Analytics Developer full_time

Building the space between proven and possible, MDA Space (TSX:MDA) is a trusted mission partner to the global space industry. A robotics, satellite systems and geointelligence pioneer with a 55-year+ story of world firsts and more than 450 missions, MDA Space is a global leader in communications satellites, Earth and space observation, and space exploration and infrastructure. The MDA Space team of more than 3,000 space experts in Canada, the US and the UK has the knowledge and know-how to turn an audacious customer vision into an achievable mission – bringing to bear a one-of-a-kind mix of experience, engineering excellence and wide-eyed wonder that’s been in our DNA since day one. For those who dream big and push boundaries on the ground and in the stars to change the world for the better, we’ll take you there.

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 of MDA’s 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. 

MDA is 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. 

As our Analytics Developer, you will:

• 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

Required Qualifications:

• 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)

Preferred Qualifications:

• 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

We’re a dream team of purpose-driven, collaborative and passionate people, and we are constantly looking for others to join #TeamMDA to ignite new and innovative approaches to problem-solving that push us forward to improve life on and above Earth. If you’re excited to expand our place in space and driven to inspire the next generation, we’ll take you there.

We have entered a new era of exploration and development, and MDA welcomes all who yearn to suit up and be part of it. An equal opportunity employer prizing diversity, integrity and collaboration, we are committed to growing MDA’s and Canada’s leadership in this next golden age.

The compensation range for this position is $80,000 – $115,000 annually. The specific compensation offered will be based on the qualifications and experience of the successful candidate.

Comments/Special Considerations:

MDA provides competitive compensation and benefits packages for its employees at all locations. As a team member of MDA, you and your qualified dependents are eligible to participate in a benefit plan that ensures a comprehensive level of protection through competitive health care including; extended healthcare and flexible drug plans, dental and vision benefits, disability income protection, life insurance, group retirement savings plans; and an employee and family assistance program.

MDA is an equal opportunity employer prizing diversity and inclusion. We are committed to treating all employees and applicants for employment with respect and dignity. If you require assistance and/or reasonable accommodation due to a disability during the application or the recruiting process, please feel free to notify us.