Data Engineer

Job Description:

• Integrate new data feeds into a cloud-based data warehouse
• Design a high performing data schema to support a dashboard report
• Design and build a marketing database to support a client’s business needs
• Develop data automation and monitoring scripts
• Develop ETL scripts to perform data transformations
• Integrate with a legacy database system to support data analysis
• Create documentation and data dictionaries to support end-users of data systems
• Perform business analysis and requirements gathering to support a variety of data projects
• Define and implement web analytics from time to time, you’ll have the opportunity to work directly with clients on-site at their offices within the GTA (Toronto, Mississauga, etc.).
• Ability to work with ambiguity, translate high-level direction to specific deliverables and effectively plan self-assigned tasks efficiently in complex work streams

Required Skill:

• 3-5 years’ experience in technology/data roles
• Experience with relational database systems (MSSQL, Oracle, Sybase, MySQL, Postgres, SAP HANA)
• Advanced skills in data scripting and database development technologies (SQL, C#, Python, PowerShell, Ruby, Java, Batch Scripting)
• Experience with Cloud platforms (AWS, Azure, Google Cloud), specially working experience with Azure BI Platform and Google BigQuery
• Experience with Big Data Technologies (Hadoop, Spark, RedShift, Big Query, Apache Stack)
• Experience with ETL/Data Pipeline tools (Apache Airflow, SSIS, Alteryx, Talend, Informatica, Oracle SQL Loader)
• Basic understanding of NoSQL technologies (Splunk, ELK, AWS DynamoDB, Mongo DB)
• Strong business, high detail-orientation and solid logical acumen

Additional Qualifications/Experience:

• Reporting/Visualization tools like Tableau, Qlik, Spotfire
• CRM/Marketing Automation Systems (Salesforce, Pardot, Exact Target, Marketo)
• Web/Software development experience
• Understanding of Network Infrastructure (e.g. Firewalls, CIDR blocks, Ports etc.)
• Streaming/Real-Time data technologies (AWS Kinesis, Kafka, Flume)
• Develops, constructs, tests and maintains architectures such as database and large-scale processing systems.
• Develop data set processes for data modelling, mining and production
• Excellent verbal and written communication skills appropriately applied to all levels of seniority

COMPENSATION & OTHER BENEFITS: 

• Weekly 2 holidays- Friday & Saturday (except the first Saturday of the month)
• Lunch & Snacks facility
• Festival Bonus
• Annual Salary Review & Performance Bonus
• Employee Loan Facility
• Health Checkup Rebate