Enterprise DBA or Data Analyst
1 month ago
We understand the importance of a system that works together. Join our team of leaders to begin a rewarding career.
Current Need – This job is located in British Columbia, Canada. All applicants must have the right to work in Canada in order to be considered for this role.
The Enterprise DBA / Data Analyst is a member of the Enterprise Tools team, focusing on administration of the Microsoft SQL Server infrastructure used to support over 35 line of business applications and 90 databases, including the Data Warehouse and data integration services across the IWS business unit while meeting regulatory requirements and compliance standards. Approximately 50% DBA duties and 50% Data Warehousing duties.
- Manages the SQL Server environments, including Production, Test, and Development
- Responsible for High Availability and Disaster Recovery capabilities and strategy, such as fail-over clustering, backups, and log shipping
- Monitors and optimizes performance and troubleshoots both functional and performance related issues
- Provisions databases, permissions, and other configuration as required
- Oversees Data Warehousing strategy and implementation
- Contributes to the design and standards around dimensional data models, extract-transform-load (ETL), and reporting
- Manages the IWS QlikView infrastructure
- Develops databases, ETL, and reports as required
- Follows standards for documentation, configuration management and change management
- Carries out other tasks as assigned
Qualifications
- + years experience in database administration
Additional Knowledge & Skills
- years combined working experience as a DBA, database developer, and/or data analyst preferred
Critical Skills
- Strong administration experience with Microsoft SQL Server, including failover-clustering (FCI), log shipping or Availability Groups
- Experience in T-SQL database development, including views, complex stored procedures, functions, CLR functions and the like
- Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) or similar reporting/ETL tools
- Experience with monitoring tools, such as SQL Sentry, for server health and performance
- Any experience with other BI tools such as QlikView, Tableau, MS PowerPivot / PowerView / Semantic Model is an asset
- Any experience with Oracle / PL-SQL is an asset
- Excellent English communications (written and verbal) to communicate effectively with peers and stakeholders across the organization
- Excellent interpersonal skills
- Excellent organizational skills
- Able to learn quickly and independently
Education
- -year degree in computer science or related field or equivalent experience
-
DBA Analyst
1 month ago
Canada, CA Fopconsultants Full timeBrief description of the position: To meet the needs of its clients in the IT sector, FOP EXPERTS CONSEILS is looking for motivated consultants in DBA analysis (Oracle and SQL Server) for various projects. The main tasks would include developing functional specifications for programs and software, creating and testing solutions, monitoring productions,...
-
Data Engineering Architect
1 month ago
Canada, CA Wavicle Data Solutions Full timeAbout the Role We are looking for a highly skilled Data Engineering Architect with strong Talend implementation experience to serve as the lead Solution/Technical Architect and Subject Matter Expert for customer experience data solutions across multiple data sources. The ideal candidate will collaborate with the Enterprise Architect and the client IT team to...
-
Analyste Rseau
3 weeks ago
Canada, CA NexGedia Enterprise Full timeTitre : Analyste RéseauLieu : 90% présentiel à QuébecDate de début visée : dès que possible.Durée : 1 an, renouvelable pendant 2 ans pour un total de 3 ans.Langue : Bilingue ou Français unilingue.ResponsabilitésVeille au bon fonctionnement des équipements de télécommunications sur la colline parlementaire, dans les 125 bureaux de...
-
SQL Server DBA
4 weeks ago
Canada, CA ROSS Full timeOur client is a well-established leader in online sports gaming with a Technical Centre of Excellence at Yonge and Sheppard. They have engaged ROSS to help them recruit a SQL Server DBA. They are profitable and growing with over 400 employees worldwide. The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance...
-
Data Engineer
1 month ago
Canada, CA Data Spree GmbH Full timeThe role at KUBRA is focused on designing, building, and maintaining data infrastructure and ETL processes to support data analytics within the organization. The Data Engineer will work on AWS and Databricks to optimize data pipelines and frameworks using Python/Pyspark, manage SQL Server and AWS data infrastructure, and assist in migrating on-premise data...
-
Enterprise Business Analyst
4 weeks ago
Canada, CA Cpus Engineering Staffing Solutions Inc. Full timeWe are currently requesting resumes for the following position: Enterprise Business Analyst Resume Due Date: Monday June 17th, 2024 (5:00PM EST) Number of Vacancies: 1 Job ID: 24-042 Level: MP6 Duration: 24 months Hours of work:40 Location: 889 Brock Road (100% remote) Recruiter: Courtney Perron Job Overview The client is seeking an experienced candidate to...
-
Revenue Analyst
1 month ago
Canada, CA Jungle Scout Enterprise Full timeAt Jungle Scout, we are on a mission to build the best Amazon competitive intelligence tools for Amazon sellers and brands.We’re growing and we are looking to add a Revenue Analyst to our fast-paced and scrappy Finance team.The Revenue Analyst will be a strategic partner to the Sales team, providing critical insights to drive revenue growth and...
-
Data Analyst
1 month ago
Canada, CA I Can Infotech Full timeCompany DescriptionI Can Infotech is a technology solutions provider located in Kitchener, ON. We have helped companies across various domains deliver products that matter and strive to cover any technological need. Our team consists of highly skilled individuals who believe in delivering excellence. We are dedicated to helping businesses grow and offer...
-
Data Analyst
2 weeks ago
Canada, CA Shivansh Outsourcing Full timeJob Summary:We are seeking a skilled Data Analyst to join our team and contribute to data-driven decision-making. The ideal candidate will have a strong analytical mindset, proficiency in data manipulation and analysis tools, and the ability to translate complex data into actionable insights.Responsibilities:Collect, clean, and organize large datasets to...
-
Data Analyst
3 weeks ago
Canada, CA PrecisionERP Incorporated Full timeTitle: Data AnalystTerm: 6-9 month contractLocation: Montreal - in office 2-3 days per week mandatoryLanguage: fluently bilingual - ENG & FR (Spanish an asset)Role Description:This role is a great opportunity for a data-driven individual with strong Excel skills. Supporting the Data Master team, you will: Utilize SAP (RTBS), Excel and sparesFinder tools for...
-
Marketing Data Analyst
2 weeks ago
Canada, CA Cella Full timeWe are seeking a highly skilled Marketing Analyst with a strong focus on Paid Media to join our global client's team for a 12-month contract. This fully remote role is open to candidates across Canada. The ideal candidate will have a passion for data and a talent for turning complex numbers into actionable insights that drive business success.Key...
-
Data Analyst I
1 month ago
Canada, CA Oil and Gas Job Search Ltd Full timeMain FunctionsWhat are you going to doResponsible for importing, cleansing, validating and analyzing data with the purpose of understanding or drawing conclusions from the data. May consolidade and/or present data in charts, graphs, or tables.Focused on improving data quality.Position will receive direction and support.This position level would typically...
-
Lead Data Analyst
3 weeks ago
Canada, CA Quarry Consulting Full timeTitle: Data Profiler/ Data AnalystDuration: 12 months contractLocation: Remote but might have to go onsite in Ottawa periodically for workshops and would cover travel expenses. *** Must have Secret clearance or have lived in Canada for 10 consecutive years to be eligible for it)***Job description: Past team leadership experience Lead team of 4 data profilers...
-
Canada, CA TECO Energy Inc. Full timeOur people are our greatest investments. Be the light to help us keep our customers connected. If you are interested in a career and not just a position, Tampa Electric is the place to be! Tampa Electric offers competitive pay, a comprehensive benefits package and opportunities for growth and development in a friendly and professional work environment. We...
-
Senior Analyst Meter Data
2 months ago
Canada, CA DM Lyons Consulting Full timeSENIOR ANALYST, METER DATA90-100KOnsiteThe Sr. Analyst, Meter Data is responsible for key aspects of meter data management, including setup, system installation, and data analysis. This role involves data collection, monitoring, troubleshooting, and translating findings into actionable business recommendations. The Sr. Analyst will collaborate with...
-
SAS Data Analyst
1 month ago
Canada, CA Nexus Systems Group Inc. Full timeSAS Data Analyst Typical day: - The day starts with a stand-up meeting where we review the current tickets assigned for the current sprint and address roadblocks - After the stand-up, the top ticket priority would have time set aside to develop on. - After a few hours of coding you have a meeting with a stakeholder to confirm some cosmetic choices and...
-
Canada, CA eStaffing Full timeAre you a Data Entry Specialist seeking a transformative career change? This opportunity might be the perfect fit for you as you consider transitioning to Data Analyst Consulting. We are a staffing company specializing in training individuals for roles with our clients.Become a Data Analyst Consultant (No IT or Coding Required)Job Title: Data...
-
Lead Data Engineer
1 month ago
Canada, CA Bombardier Transportation GmbH Full timeBombardier’s Business Aircraft London Service Centre in Biggin Hill is part of an award-winning network and is the flagship of Bombardier’s European operation. This Base and Line Maintenance Centre is the fastest-growing Service Centre in Europe and the largest Business Aircraft OEM in the UK. The facility has the capabilities to perform an array of...
-
M&A Analyst
4 weeks ago
Canada, CA Keeplee Full timeKeeplee is looking for an IT Security and Compliance Analyst to join our growing Enterprise Systems team.Keeplee is looking for an IT Security and Compliance Analyst to join our growing Enterprise Systems team. This role will be responsible for day-to-day activities in implementing information security and compliance best practices. They will resolve...
-
Senior Data Analyst
1 month ago
Canada, CA MERCADEO INTERACTIVO GCR, S.A. DE C.V. Full timeQueen’s University, a leading Canadian research institution, offers a diverse employment experience across multiple fields. The university is committed to employment equity and diversity, welcoming individuals from various equity-seeking groups. The Senior Data Analyst role at the Southeastern Ontario Academic Medical Organization (SEAMO) focuses on...