Data Engineer
Description
We are looking for a Sr. Data Engineer to join our growing team. You will support the team across our three areas of focus: insights, analytics, and data. Across these three functions your area of focus will be in data strategy, analysis, data integration and data management. We are looking for someone who has a solid foundation in technology, who can use data methodologies, solutions and tools to optimize performance by managing, sorting and filtering large volumes of data while extracting meaningful value from these large volumes of data. You will have exceptional analytical and problem-solving skills as well as a desire to learn new technologies.
- Design and develop data ingestions within cloud environments (AWS, GCP, Azure)
- Integrate and operationalize data feeds (API and file-based) into cloud-based data warehouses
- Design high performing data schemas to support dashboard reports
- Design and build marketing databases and reporting/BI datamarts
- Develop data automation and monitor scripts
- Develop ETL scripts to perform data transformations
- Perform data profiling and data QA
- Review data for inconsistencies or anomalies
- 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
- Provide guidance/direction, best practices, code review with other data engineer team members
Qualifications
- 5+ years of experience in data engineering
- Experience with cloud platforms (Azure, AWS, GCP); Certification is an asset
- Hands on experience with cloud warehouse technologies, including Snowflake and/or Redshift
- Strong understanding of data modelling concepts
- Advanced skills in data scripting and database development technologies (SQL, Python, Powershell, R)
- Experience with Airflow, Talend, FiveTran, Matillion or similar tools
- Experience designing and building cloud databases and designing a high performing data schema
- Experience integrating new data feeds into a cloud-based data warehouse
- Ability to work with ambiguity, translate high-level direction to specific deliverables and effectively plan self-assigned tasks efficiently in complex work streams
- Ability to take business requirements and create technology solutions
- College or University degree (or relevant work experiences)
Experience with some or all of the following technologies would be an asset:
- Reporting / Visualization tools like Tableau and Power BI
- Machine learning algorithms