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