Data Management Analyst - Hamilton, Canada - GM BluePlan Engineering

GM BluePlan Engineering
GM BluePlan Engineering
Verified Company
Hamilton, Canada

3 weeks ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter
Description

Data Management Analyst

(full-time permanent position)

Location:
Hamilton, Ontario

GM BluePlan
Engineering is a dynamic engineering, management and technology consulting company that provides full service and full asset life cycle offerings to our clients across Canada. With over 50 years of experience, we provide expert guidance to plan, design, implement and support our clients' infrastructure.

Our Hamilton office is looking for a Data Management Analyst to join our team. This role will support our Data Management team through data collection, analysis, reporting and presentations.


Responsibilities:


  • Provide support in planning, data collection, data analysis, reporting, and presentations.
  • Transform datasets from a variety of inputs to create one or more data sets that can be used to analyze, track, and predict the performance of different infrastructure assets.
  • Complete statistical modelling and computations to provide analytical solutions for our clients' business problems.
  • Write SQL queries, functions, stored procedures, and triggers.
  • Work with large amounts of granular data, from structured and unstructured data sources.
  • Participate in various structured and adhoc analysis projects.
  • Assist with the development of and implementation of decision support systems, maintenance management systems, and flow analysis systems for various clients.

Required Experience and Q
ualifications:


  • A diploma, degree, or experience in either Statistics, Data Science, Mathematics, Database Development, Computer Science, Business Intelligence, or another highly quantitative discipline related to data analysis.
  • Strong quantitative research skills, including cleaning and preprocessing of data, assessment of data quality, designing and implementing models that explore spatial and/or temporal dynamics.
  • Experience with SQL Server including the use and creation of SQL queries, functions, and stored procedures.
  • Requires strong attention to detail and accuracy.
  • Ability to work through problems using first principles thinking.
  • Must work effectively with a team and independently.
  • Ability to translate and communicate complex concepts to nontechnical individuals.
  • Ability to produce highquality, accurate work in a timely way, and in accordance with multiple project deadlines.
  • Excellent scientific and quantitative problemsolving skills, with demonstrated ability to build, test, and iterate on a variety of model forms.
  • Troubleshooting skills.
  • Enthusiasm about solving complex problems with a variety of analytical tools.

Experience and Q
ualifications Considered an Asset:

  • Experience designing relational databases and ensuring their stability, reliability, and performance.
  • Experience with Microsoft Office Suite including strong MS Excel skills, especially using pivot tables, macros, and ODBC data sources.
  • Strong basics in programming languages such as Python, R, and Excel-VBA.
  • Experience creating dashboards (Power BI, Excel, Dash, Tableau, etc.)

We are committed to providing:


  • A dynamic work environment which encourages teamwork, initiative and creativity.
  • Career development and education opportunities.
  • A competitive compensation package commensurate with experience, including a benefit package and RRSP program.
Extra-curricular social activities (hockey, golf and many more social events).


Join our Team

  • We thank all applicants; however only those selected for an interview will be contacted._
More jobs from GM BluePlan Engineering
See all jobs of GM BluePlan Engineering