Job Description
Job DescriptionYou will be joining and play a key role in architecting, implementing and managing data processing pipelines and data models that contribute to our data from various internal systems and third party vendors. Our goal is to streamline and simplify our data architecture to help our teams an customers make data-driven decisions and ROI optimization to a higher level. You will support our focus on member agencies, advisors and suppliers and set the foundation for every initiative and project that we undertake. Your understanding of users along with the economics of Ensemble’s business are important in delivering tools that will meet the needs of the company.Key Responsibilities• Design and prepare of end-user visualizations with an eye toward end user requirements and goals• Identify areas of improvement to the current data infrastructure, bring to the attention of the analytics team• Prepare detailed data flow charts and diagrams outlining data flow capabilities and processes.• Collect, clean and interpret disparate data sources into a interpretable and standardized formats• Design, build and automate data flows (ingest, transform, stage, deploy)• Maintain, support and evaluate data workflows for improvement.• Develop and assist in maintenance of the consortia data warehouse and related data pipelines to empower and standardize data access and self service.• Determine scope and prepare requirements documents for projects to ensure scope and business requirements are understood and acceptable to stakeholders.• Work as a team member with other technical staff, to ensure connectivity and compatibility between systems.• Document system problems and resolutions for future reference.Qualifications• Bachelors degree in a Computer Science, Engineering, Information Science, or relevant field.• Proven experience as a data developer, engineer or data scientist.• Background in data warehouse design, dimensional modeling and data mining.• In-depth understanding of database management systems and ETL (Extract, Transform, Load) frameworks.• Experience with Apache AirFlow and Spark and/or Microsoft Data Fabric, Factory and Synapse and Microsoft platform technologies.• Knowledge of and experience with different databases (MSSQL, MySQL), programming languages (Python and R), XML and REST APIs.• Experience creating, modifying and tuning SQL queries.• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.• Ability in using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.• Ability to effectively participate in multiple major projects or project roles or lead a variety of project team activities/tasks.• Work experience in ecommerce or travel industry preferred.• Excellent organization, planning and prioritization skills.Cultural Fit• Thrives working in a technology and KPI driven organization.• Able to thrive in an entrepreneurial environment.• Highly functional in a fast paced, constantly changing workplace - building plans through iterations from learning on what’s working and not working.• Ability to build trust and work through conflict both upwards and downward.We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.