Data Analyst Jobs in Ottawa, Ontario, Canada
Create alert for “Data Analyst”
Ottawa, Ontario, Canada
About the role
The Data Analyst will be responsible for translating raw data into actionable insights, providing data-driven recommendations to support business strategy and decision-making. This role involves collecting, cleaning, analyzing, and visualizing data to identify trends, patterns, and opportunities for process and performance improvement.
Collect clean and analyze operational data and generate dashboards and reports tracking KPIs (e.g. order ingestion volumes, error rates , SLA adherence) Conduct trend analysis and performance monitoring Provide recommendations for process improvements based on data insights Collaborate with Operational Analyst and Operation Managers for data validation
Key Responsibilities and Duties: Data Acquisition and Preparation: Extract, Transform, and Load (ETL) data from various primary and secondary data sources (e.g., internal databases, cloud platforms, external APIs). Clean and preprocess raw data to ensure accuracy, consistency, and completeness, including identifying and correcting errors, managing missing data, and transforming formats. Design and maintain databases (e.g., data warehouse models) and data systems to optimize data access and quality.
Data Analysis and Interpretation: Apply statistical methods and data analysis techniques to perform exploratory and diagnostic analysis to uncover trends, anomalies, and relationships within complex datasets. Conduct hypothesis testing and develop models (e.g., regression analysis) to support business questions and predict outcomes. Define, track, and report on Key Performance Indicators (KPIs) and metrics across various business functions (e.g., Marketing, Sales, Operations).
Reporting and Visualization: Design, develop, and maintain interactive dashboards and reports using visualization tools to present data in a clear, digestible format for both technical and non-technical audiences
Collaboration and Improvement: Collaborate with cross-functional teams (e.g., Data Engineering, Product, IT) to understand data requirements and deliver targeted, timely insights. Proactively identify and recommend process improvements, system modifications, and operational changes based on data analysis.
Required Qualifications and Skills:
Essential Technical Skills (Hard Skills): SQL (Structured Query Language): Advanced proficiency in writing complex queries, stored procedures, and managing relational databases. Statistical Programming: Expertise in at least one statistical programming language (Python or R) for complex data analysis, statistical modeling, and automation (e.g., using libraries like Pandas, NumPy, Scikit-learn). Data Visualization Tools: High proficiency in industry-standard tools like Tableau, Power BI, or Google Looker Studio for creating interactive dashboards. Spreadsheet Tools: Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUPs, functions, modeling). Statistical Analysis: Strong foundation in descriptive and inferential statistics.
Essential Workplace Skills (Soft Skills): Critical Thinking and Problem-Solving: The ability to approach a business problem logically, ask the right questions, and find meaningful patterns in data. Communication and Presentation: Excellent verbal and written communication skills to clearly articulate complex technical information and its business implications. Attention to Detail: Meticulous approach to data cleaning and quality assurance to ensure the highest level of data integrity and reporting accuracy.
Business Acumen: Understanding of business processes and the industry to ensure data analysis is relevant and actionable.
Not the right fit? Search for Data Analyst jobs in Mississauga, Ontario, Canada
About KTek Resourcing
Ktek Resourcing is a global staffing and recruitment firm specializing in IT, engineering, and professional services.
We combine data, AI, and human insight to deliver smarter, faster hiring solutions. Whether you’re filling a single role or scaling an entire team, we bring over two decades of recruiting expertise to every engagement. Ktek is proudly headquartered in Houston, TX.
Our reach spans North America, South America, Asia, and EMEA, connecting businesses with top-tier talent. We are committed to creating equitable opportunities for candidates from all backgrounds and helping companies build inclusive, high-performing teams.
Trusted by startups and Fortune 500 companies alike, Ktek is the partner of choice for organizations looking to hire with impact.
Looking to grow your team or find your next opportunity? Let’s connect.