Data Analyst Jobs in Town of Ajax, Ontario

Experience with end-to-end project management

Development of data collection processes and data management systems

2+ years of professional or military experience

1+ years of working with computers and Microsoft Office products and applications experience

Experience with Microsoft Office products and applications

Maintenance of data integrity (0% error rate)

Strong SQL skills are essential; experience writing complex queries spanning multiple tables is required.

Strong domain knowledge on OTC derivatives, markets.

7+ years of experience in IT and data base/data warehouse domain

Experience in writing sqls in Hive, Impala

Working knowledge of performance tuning of database queries (understanding the inner working of the query optimizer, query plans, indexes, partitions etc.).

Exposure to scripting language like shell scripting, python is required.

Strong SQL skills are essential; experience writing complex queries spanning multiple tables is

7+ years of experience in IT and data base/data warehouse domain

Working knowledge of performance tuning of database queries (understanding the inner working of the query optimizer, query plans, indexes, partitions etc.).

Experience in writing sqls in Hive, Impala

Exposure to scripting language like shell scripting, python is required.

Position: Tech Data Analyst (DA)

Benefits after the probation period, medical insurance

Education Consultants Canada (ECC) Inc.

oriented. You have excellent organizational skills with meticulous record-keeping

● At least 2 years of experience

● Knowledge of Power BI; all other data visualization tools are an asset

● Strong knowledge of Tableau

Work with management to prioritize business and information needs

BS in Mathematics, Economics, Computer Science, Information Management or Statistics

Strong knowledge of, and experience with reporting packages (business data objects, databases (GCP, SQL, etc.), programming (XML, Javascript, or ETL frameworks)

Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SAS, etc.)

Developing ongoing reporting capabilities, monitor performance and identify improvements

5+ years of proven working experience as a Data Analyst or Business Data Analyst

* Work with management to prioritize business and information needs

* BS in Mathematics, Economics, Computer Science, Information Management or Statistics

* Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SAS, etc.)

* Developing ongoing reporting capabilities, monitoring performance and identifying improvements.

* 5+ years of proven working experience as a Data Analyst or Business Data Analyst

* Strong leadership and communication skills

Gathering requirements from business users, developing data & reporting solutions

3 Years experience with SQL - with ability to write good, complex SQL queries

Ensure Data Integrity at all time.

Collaborate with the Data Insights and Advanced Analytics (DIAA) team to evolve the reporting environment to meet future business needs.

Identify potential issues and develop solutions as needed to ensure continuity of data & reporting solutions.

Maintain reports and data extracts

Strong time management and organizational skills

Contributes to ongoing quality assurance of medico-legal data and knowledge products of Safe Medical Care Research

Knowledge of administrative health care data.

Experience with DAD, NACRS and OHIP data a strong asset.

Sound programming skills, particularly a statistical analysis package (preferably SAS), and familiarity with data visualization software

Strong data extraction, manipulation and exploration skills

Current knowledge of and experience with Healthcare delivery system operations, healthcare informatics, and healthcare benefits and terminology

Bachelor’s Degree in related field (Business or Healthcare Administration, Computer Science, or Finance preferred).

Demonstrated leadership, conflict resolution, interpersonal and organizational skills

Proven written and verbal communication skills

Preference for proficiency in French/English language skills

Identify, organize, consolidate, format and validate large volumes of operational data for secure and efficient use and access by report/presentation consumers

Experience with Data Management standards relevant to ensuring data integrity;

Drafts communication materials and presentations for diverse stakeholder groups, including senior management, on EDC’s climate data initiatives.

Experience with the measurement of financed emissions aligned with PCAF and tracking progress against science-based targets (i.e. SBTI or PACTA);

Liaises with internal data engineering teams and external consultants to ensure alignment with EDC’s business requirements on climate data;

Experience of TCFD and relevant climate change reporting frameworks;

Experience with international organizations such as the IFC, WB, OECD and/or the UN;

- Salary of $75,000K to $80,000 + 10% pay in lieu of pension benefits

- Expert knowledge of SQL or similar database software

What’s in it for you:

- Hybrid work environment (2 days per week)

- 35-hour work week (Monday to Friday)

- Compressed work week in the summer (Fridays are half days in the summer)

Experience with end-to-end project management

Development of data collection processes and data management systems

2+ years of professional or military experience

1+ years of working with computers and Microsoft Office products and applications experience

Experience with Microsoft Office products and applications

Maintenance of data integrity (0% error rate)

Time management skills and an ability to prioritize various tasks to meet strict deadlines.

General pipeline knowledge or experience desirable.

Strong communication skills, both verbal and written.

Customer relation skills when dealing with project inquiries.

Knowledge and application of artificial intelligence systems desirable.

Knowledge of computer programming (Python, SQL, MATLAB, C++, VBA) and data science methods desirable.

Ability to manage multiple projects/responsibilities at the same time.

Analytical mindset and data analysis skills including demonstrated ability to manage large data sets with efficiency.

Manage transactional work for purchase orders, raw material authorization and SLOB across the full EM MAKE Team.

Experience developing and managing analytical reports for large scale reports within the team.

Experience working with a business environment focused on continuous improvement and exposure to continuous improvement concepts is preferred.

Execute monthly dashboards and analytics processes to track EM performance, activities and key performance metrics.

Analytical experience, facility working with numbers, and strong problem-solving skills.

**3 days a week onsite in downtown Ottawa, 2 days remote from home.

A minimum of 5 solid years of analysis experience.

Advanced Excel skills using complex formulas (testing is part of the interview process)

University Degree in a relevant discipline (e.g. Human Resources, Business Administration, Accounting, Finance)

Experience working with HRIS systems would be an asset

Have an interest or direct experience in the following: Executive Protection, Intelligence, Operations, Critical Incident Management or Corporate Security

Demonstrated organizational and time management skills

Write security incident investigation reports to provide situational awareness and communicate risks to management

Contribute to procedures and processes to standardize and enhance risk management

Required And Preferred Experience And Qualifications

Bachelor’s degree in a related field is strongly preferred. Either bachelor's degree or equivalent military experience

Strong knowledge of SQL, Java, and API programming languages, with experience working with relational and non-relational databases.

Collaborate with cross-functional teams to gather requirements and implement data-related solutions for the Services Supply Chain.

Experience with Power BI and Qlik sense.

Excellent problem-solving skills and the ability to work effectively with cross-functional teams.

Strong written and verbal communication skills, with the ability to present complex data in a clear and concise manner.

Lead or play a leading role in an ongoing Qlik to Power BI transformation project.

What you have to offer:

Ready to Make an impact?

Here’s Where You’ll Be Focusing

Comfortable and experience in administering and creating reports in Hubspot(preferred) or similar Sales/CRM tools.

Some knowledge of APIs, writing SQL and migration from Sandbox to Production.

Comprehensive Benefits Package (Health, Dental, Medical, Vision) from Day 1

Ability to troubleshoot automation errors and good at root cause analysis

Build reports and tools that define success metrics and track Sales Key Performance Indicators(KPI) on a weekly/monthly basis.

Look for opportunities to automate insights through alerting, workflow, nurture email campaigns, process builder , anomaly detection and actionable reporting.

Experience with end-to-end project management

Development of data collection processes and data management systems

2+ years of professional or military experience

1+ years of working with computers and Microsoft Office products and applications experience

Experience with Microsoft Office products and applications

Maintenance of data integrity (0% error rate)