Job Summary
On behalf of our client, one of Canada’s largest aviation companies, we are looking for a Sr. Data Developer. This position is a key implementer of designing, developing and expanding the use of data using ETL and DI processes, data warehousing and big data techniques. Data is one of the key contributors in driving efficiencies, performance and growth. If you enjoy collecting, transforming and making data available for analysis and business goals you are the ideal candidate.
Skills & Responsibilities:
- Prototype and develop new and innovative ideas with big data, real-time data collection and data analysis.
- Work with business groups to define and document requirements.
- Document the structure, business processes and requirements for the data processes, databases and data warehouse.
- Design, develop and maintain ETL and data integration processes for internal and external systems.
- Mentoring junior team members on best practices for data processes and the data warehouse.
- Design, develop and maintain subject areas in the data warehouse.
- Maintain and support multiple projects and deadlines, working with project managers to establish timelines and effort.
- Analyze the strengths and weaknesses of data processes and provide recommendations for improvement.
- Responsible for analyzing and improving data quality and integrity in the data warehouse.
- Provide occasional support for data processes after hours and weekends.
- Any other duties as requested by the Director.
- 5 + years of experience developing and maintaining data integration (ETL) processes using tools such as Microsoft SSIS, Pentaho, Matillion or other open source products.
- 5 + years of experience using open source programming languages such as Python.
- 5 + years of experience using SQL Server, PostgreSQL, MySQL or similar databases.
- 2 + years designing and developing data pipelines.
- Experience with Amazon Web Services (AWS) products and services, especially. Redshift, Kinesis, Lambda, EMR, RDS or other cloud services.
Qualifications:
- 7+ years of experience developing data integration and ETL processes.
- 7+ years of experience designing and developing data and data warehouse solutions.
- Exceptional analytical and problem solving skills.
- Post-secondary degree in Computer Science, Mathematics, Engineering or similar degree preferred.
- Expert knowledge of database design, data warehouse methodologies and data techniques.
- Excellent SQL experience with multiple database systems such as SQL Server, MySQL, PostgreSQL , Redshift or similar
- Excellent written and verbal communication skills, to communicate with business stakeholders, project teams and project managers
- Experience with various SDLC methodologies and requirements gathering
- Experience with distribute data systems
- Experience in the airline industry is an asset
Benefits:
- Flexible working hours
- Work from home 1-2 days a week.
- Discounted travel options.