Data Manager

2 weeks ago

Toronto, Canada Tokyo Smoke Full time

The Data Manager works amongst a team of professionals and plays a key role in the overall success and future growth of our business. You will be primarily accountable for researching, designing, implementing, and administering database solutions in a welcoming environment.

**Key Responsibilities**
- Design and implement a database from scratch, combining data from a variety of sources
- Design and implement effective database solutions and models to store and retrieve company data
- Streamline data flows from sources such as QuickBooks Online and COVA into the database
- Maintain an array of Microsoft Azure SQL databases across critical production and non-production environments
- Proactively develop, implement, and improve procedures to increase the overall effectiveness and integrity of our databases and systems
- Identify opportunities for improvement of existing processes to enhance data integrity and accuracy
- Proactively perform database monitoring, optimization, performance tuning, and database maintenance and testing as well as Implements large-scale data migrations
- Assess database implementation procedures to ensure they comply with internal and external regulations
- Create data products for Business Analysts in various teams to improve productivity
- Implement systems to track data quality and consistency
- Applies data modeling, data design and implementation to support business requirements and drive the organization forward
- Respond to ad-hoc data requests within the organization in a timely manner
- Educate staff members through training and individual support
- Offer support by responding to data problems in a timely manner
- Support the creation, review, and maintenance of framework, policy, and procedure documentation relating to Data Quality
- Develop and implement a Data Governance process
- Participate in project teams and collaborate as a team to deliver business outcomes
- Proactively monitor and respond to database Alerts
- Research technical problems, analyze business requirements, evaluate alternative design approaches and technical design processes to meet business requirements
- Design and implement conceptual, logical, and physical data models for corporate database solutions

**Key Qualifications**
- Bachelor's degree required, Master's degree preferred in Software Engineering, Computer Science, or equivalent work experience in a Technology or business environment
- 5+ years of practical experience within a MS SQL DBA capacity, with strong knowledge of SQL Server administration, implementation, and optimization in large and complex environments
- Intermediate competency in Azure Cloud, database development and modelling
- Extensive experience with MS SQL Server (tables, triggers, unions, joins, complex queries, and stored procedures)
- Experience in managing clustered SQL environments utilizing mirroring, availability groups, and log shipping
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- Exposure to Azure Cloud and hands on experience with Database Cloud Migrations
- Good understanding of NoSQL databases (Redis, MongoDB and Cosmos DB preferably) and some experience with relational DBMS nice to haveVB.Net and the ability to create ad-hoc solutions for data issues such as building macros to create temporary dataflows while a permanent flow is developed
- Competency in Microsoft Power BI considered a great asset
- Expert in data warehouse concepts
- Strong experience working in teams to perform ETL (Extract, Transform & Load) of data
- Self-motivated, results driven with strong attention to detail
- Demonstrated strong organizational and analytical skills
- Well-developed communication, collaboration, interpersonal and leadership skills with an ability to build and maintain effective relationships
- Thank you for your interest in joining our team Those moving forward in the process will be contacted by a member of our team. Our organization is committed to being fully vaccinated against COVID-19. We require the successful applicant to disclose their vaccination status and provide proof of their full COVID-19 vaccination._

**Job Types**: Full-time, Permanent

Schedule:

- Monday to Friday

Ability to commute/relocate:

- Toronto, ON: reliably commute or plan to relocate before starting work (required)

**Education**:

- Bachelor's Degree (required)

Work Location: Hybrid remote in Toronto, ON

  • Data Analyst

    Found in: Talent CA 2A C2 - 2 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    Found in: Appcast CA C2 Glassdoor - 1 week ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    Found in: Whatjobs CA C2 - 2 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company Description Data SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    Found in: Appcast CA A2 P - 1 week ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Entry Clerk

    23 hours ago

    Toronto, Canada StarPRO - Better Data Instantly Full time

    Company Description StarPRO is a research and tracking application used by companies who invest in skilled nursing homes. The application helps optimize and monitor operational performance indicators that investors correlate to strong clinical and financial performance. Successful nursing home operators and key management leaders rely on StarPRO for ongoing...

  • Data Entry Clerk

    1 day ago

    Toronto, Canada StarPRO - Better Data Instantly Full time

    Company Description StarPRO is a research and tracking application used by companies who invest in skilled nursing homes. The application helps optimize and monitor operational performance indicators that investors correlate to strong clinical and financial performance. Successful nursing home operators and key management leaders rely on StarPRO for ongoing...

  • Data Entry Clerk

    24 hours ago

    Toronto, Canada StarPRO - Better Data Instantly Full time

    Company Description StarPRO is a research and tracking application used by companies who invest in skilled nursing homes. The application helps optimize and monitor operational performance indicators that investors correlate to strong clinical and financial performance. Successful nursing home operators and key management leaders rely on StarPRO for ongoing...

  • Data Entry Clerk

    2 days ago

    Toronto, Canada StarPRO - Better Data Instantly Full time

    Company DescriptionStarPRO is a research and tracking application used by companies who invest in skilled nursing homes. The application helps optimize and monitor operational performance indicators that investors correlate to strong clinical and financial performance. Successful nursing home operators and key management leaders rely on StarPRO for ongoing...

  • Data Entry Clerk

    1 day ago

    Toronto, Canada StarPRO - Better Data Instantly Full time

    Company Description StarPRO is a research and tracking application used by companies who invest in skilled nursing homes. The application helps optimize and monitor operational performance indicators that investors correlate to strong clinical and financial performance. Successful nursing home operators and key management leaders rely on StarPRO for ongoing...

  • Research Analyst, Data

    1 week ago

    Toronto, Canada International Data Group, Inc. Full time

    Overview: - Do you want to be part of a dynamic team in a fast-paced exciting industry? You can make an impact by joining IDC Canada._ IDC Canada is looking for a **Research Analyst **to join our Data and Analytics team on a full-time basis for a permanent opportunity. Reporting to the Research Manager of IDC Canada’s Market Insights and Analytics,...

  • Data Center Technician

    2 weeks ago

    Toronto, Canada Estruxture Data Centers Full time

    La version française suit la version anglaise **_ ***We host the data. We **provide** the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the country, over 760,000 square feet of space, over 130MW of power and access to over 1,400 network and cloud...

  • Product Manager, It

    7 days ago

    Toronto, Canada Bridgemarq Real Estate Services Manager Limited Full time

    Status: Full time About RPS Real Property Solutions - At RPS we thrive on finding incredibly smart home and neighborhood real estate intelligence and insights for our customers to help add value to the home journey, we find, understand, and overcome the barriers that keep the business from delivering a positive customer experience. We are a team who shares...

  • Account Manager

    3 days ago

    Toronto, Canada Estruxture Data Centers Full time

    La version française suit la version anglaise **_ - Are you a strong communicator who loves talking about technology? - Are you enthusiastic about helping customers thrive by providing them with the perfect solution for their business needs? - Would you like to make a difference in a fast-growing data center company (_And at eStruxture we mean FAST: we grew...

  • SEO/sem Manager

    3 days ago

    Toronto, Canada International Data Group, Inc. Full time

    Overview: **IDC Canada **is seeking a dynamic and experienced **SEO/SEM Manager** to join our team. As an integral part of our marketing efforts, you will be responsible for driving organic and paid traffic to our digital properties/products, optimizing conversion rates, and ultimately contributing to the growth of our user base and revenue. **Why...

  • Manager, Master Data Management

    5 hours ago

    Toronto, Canada OCS Full time

    About Us The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler to authorized private retail stores. Working at the OCS is a unique opportunity to be part of an agile start-up in a...

  • Manager, Data Governance

    3 days ago

    Toronto, Canada Hydro One Networks Inc Full time

    **49367** - **Toronto** - **Regular** - **Ongoing** Hydro One is proud to be the largest electricity transmission and distribution provider in Ontario, serving nearly 1.4 million customers. We have a long history in the industry with our roots dating back over 110 years to 1906. Since then, we have worked to grow and evolve to meet the changing needs of our...

  • Associate, Data Management

    5 days ago

    Toronto, Canada Royal Bank of Canada Full time

    **Job Summary** **What is the opportunity?** The primary objective of the role is to support data management work for the Corporate Banking loan book; perform root cause analysis of potential data quality findings, support the business unit in fulfilling data related policy and regulatory requirements; and support the design, implementation and enhancement...

  • Data Management Consultant

    2 days ago

    Toronto, Canada Beta Search Full time

    **Job Category**:Financial services**Job Type**:Contract**Job Location**:Toronto Canada- Position Title: - Data Management Consultant- Full time / Consultant: - Consultant- No. of Resources: - 1- Project Scope/Description: - Business Data Consultant to lead and guide an Asset Management Enterprise Data management project to implement a vendor solution....

  • Manager, Data Platform

    2 weeks ago

    Toronto, Canada Porter Airlines Inc. Full time

    Job Summary: The Manager, Data Platform is an essential technology leadership role for Porter organization. The role requires a unique blend of technical expertise and leadership skills, and involves responsibilities for data platform architecture, release planning and development and operations. Having a strong technical role accountable for both the data...

  • Data Management Analyst

    7 days ago

    Toronto, Canada OCS Full time

    About Us The Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler of authorized private retail stores. Working at the OCS is a unique opportunity to be part of an agile start-up in a...