BI Engineer Loc :L - Edmonton, AB

100,000 - 200,000

Job Description:

  • Develop data set processes for data modeling, mining and production
  • Develop and maintain ETL processes using Cloud and Big Data technologies â?? AWS and Cloudera experience preferred
  • Participate in development of data marts for reports and data visualization solutions
  • Support the gathering and translation of business requirements for data acquisition/manipulation and provide detailed specifications that can be passed downstream for use
  • Identify, analyze, troubleshoot and communicate technical problems, process and solutions
  • Create Ad-Hoc queries and reports as needed along â?? Tableau experience preferred
  • Recommend ways to improve data reliability, efficiency and quality

Qualifications

Knowledge, Skills, Attributes

  • The candidate should exhibit the following core qualifications:
  • Bachelor??s Degree in Computer Science, MIS, Computer Engineering or other Information Technology related degree
  • 2+ years SQL experience with at least one DBMS: MySQL, Oracle, MS SQL Server
  • 2+ years programming experience with at least one of languages: Python, PHP
  • 2+ years?? experience in a Data Warehouse environment
  • 2+ years?? experience using at least one BI or analytics tools: Tableau, Google Analytics, Power BI, IBM Cognos, Business Objects, Oracle OBIEE
  • High level of technical aptitude with data analysis and troubleshooting experience. Ability to identify data required in different sources, locations and formats, and implement ETL
  • Excellent team player and quick learner

Following qualifications are highly desired or considered assets:

  • Masters Degree in Computer Science, MIS, Computer Engineering or other Information Technology areas
  • 5+ years SQL experience to build, debug and optimize complex queries, functions and procedures
  • 5+ years programming experience with Python, PHP to build data pipelines
  • 5+ years?? experience in a Data Warehouse and BI environment
  • 3+ years?? experience in Cloud and Big Data analytics environment ? AWS, Cloudera Hadoop, Hive, Impala, Spark, Kafka, NoSQL, Google Analytics, Google BigQuery, Google Tag Manager preferred
  • Experience in Content Management System(CMS), Drupal preferred
  • Experience in online publishing, online advertising. Experience with DFP data extract preferred
  • Experience in administration and configuration of Cloudera Hadoop, AWS and database


Share Profile