Job Title: Sr. Infrastructure Specialist
Location: Toronto, London or Winnipeg (Hybrid)
Estimated Duration: 12 Months
Role profile:
As part of the Data and Analytics Team you will help provide the data foundation for planning and decision making. You will provide technical leadership and hands-on skills to support the systems that enable the collection, integration, analysis and presentation of information.
In this role you will wear many hats: building Azure Data Factory and ETL processes, writing complex SQL, and supporting operational processes in both our Data Warehouse and Microsoft Azure data hub. In addition, the role requires experienced thought leadership and ability to drive initiatives that enable our development pipelines to continually be available and capable of meeting our business partners’ needs.
What you will do:
- Develop, maintain, and optimize SQL Server T?SQL solutions, including writing and maintaining complex stored procedures, functions, and queries
- Perform SQL Server Database Administration tasks such as monitoring, backups, recovery, maintenance, and troubleshooting
- Design and implement star?schema and data?warehouse–style database models to support reporting and analytics needs
- Analyze and improve database performance, including query optimization, indexing strategies, and resource utilization
- Provide database?related production support, diagnosing issues, resolving incidents, and partnering with application teams to ensure system stability
- Build data pipelines in MS Azure platform that supports the consumption of structured and unstructured data from various sources with the use of Azure Data Factory and Data Bricks
- Work will involve proficiency in MS SQL Server as the focus gradually shifts to Azure Databricks over the course of database migration
- Collaborate with cross functional teams to analyze, transform, and model large complex data sets for business insights, operational reporting, and analytics
- Develop data solutions that facilitates re-usability across various business functions
- Develop and support the creation of conceptual, logical, and physical data models
- Lead and support the migration of on-premise data solutions to the MS Azure platform
- Actively contribute and improve our data solutions and best practices
- Collaborate with internal technical stakeholders and business partners for solving data related technical issues
- Advise others on Data Modelling and the use of database technologies
- Apply enhancement and provide support for initiatives related to existing legacy databases
What you will bring
- Bachelor’s degree in Computer Science, Mathematics, Statistics or in a related field.
- 10+ years of hands-on experience in developing data solutions with a strong background in data warehousing (incorporating a Kimball dimensional design methodology)
- High proficiency in SQL Server T?SQL development, including the design and implementation of complex stored procedures, functions, and queries
- Strong experience with SQL Server Database Administration, including maintenance, monitoring, backups, recovery, and troubleshooting
- Recent development experience in MS Azure platform (Databricks, ADF), Kafka, Python (or R), and Change Spark
- Hands?on experience with change data capture (CDC) solutions or implementations is an asset.
- Previous investment and/or insurance experience will be considered an asset
- Good communication and collaboration skills
- Seeks to understand business needs, and delivers high quality service to the business while understanding the organization’s vision, purpose and values
- Passionate about technology, the user experience, demonstrates inner self starter, and is accepting of and open to learning new ideas outside scope or knowledge
- Familiar with API, microservice integration
- Explains technical issues to diverse audiences
- Decision-making: understands the costs and benefits of actions, and makes recommendations towards the most appropriate one, uses collaboration and judgement to form conclusions
The pay range that the employer reasonably expects to pay for this position is between CA$80.00 and CA$95.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
This posting is for an existing vacancy.If you believe this post to be fraudulent, please report by clicking here
Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!