Data Engineer



Job Description:Are you excited about the prospect of joining a startup organization? Interested in being a part of the changing skies in Canada and beyond? Want to work with world-class leaders who have extensive industry know-how? Curious about how it feels to contribute and join Canada’s newest airline while redefining affordable air travel? If so, we have an exciting opportunity for you! We are seeking a Data Engineer for our IT Department to join our rapidly expanding, dynamic team! WHO WE ARE: Let your career fly with Lynx Air, Canada’s newest ultra-affordable airline. Our mission is to make air travel accessible for all, by offering low-cost, safe and customer-first flying experiences. With airfares sky-high in Canada, we’re here to change the game! Our brand-new fleet of Boeing 737 MAX planes will take Canadians to select Canadian and USA destinations at an ultra-affordable price point and we’re excited to be building our team that will help us get there. With backing from prominent investors, we’re poised to revolutionize the Canadian airline industry. Join our team and be part of the changing skies of Canadian aviation! WHAT YOU WILL BE DOING: * Design, build, and maintain data warehousing systems using Microsoft SQL Server and Azure Data Warehouse to store, process, and analyze large amounts of data. * Develop and maintain ETL processes to extract, transform, and load data from various sources * Build and maintain dimensional data models and star schema designs * Create and maintain data integration and data migration processes * Work with cross-functional teams to understand data requirements and design solutions * Implement data governance and security measures using Azure Active Directory and Azure Data Security to ensure data integrity and confidentiality for Power BI reports. * Collaborate with cross-functional teams to integrate Power BI reports with other software applications using Microsoft API. * Troubleshoot and resolve data warehousing and ETL issues * Develop and implement interactive data visualization tools using Power BI to provide insights into business data. * Stay up-to-date with new technologies and tools related to data warehousing, full-stack development, and Power BI in the Microsoft ecosystem. * Monitor and optimize data warehousing performance WHAT YOU BRING TO THE ROLE: * Bachelor’s degree in Computer Science, Information Systems, or a related field * 5+ years of experience in data warehousing and ETL development * Strong SQL skills and experience with relational databases such as Oracle, SQL Server, and MySQL * Experience with ETL tools such as Informatica, Talend, or Alteryx * Experience with data warehousing platforms such as AWS Redshift, Snowflake, or Azure Synapse Analytics * Experience with data modelling and star schema design * Strong experience with scripting languages such as Python or JavaScript * Experience with BI and reporting tools such as Power BI and/or Tableau * Strong problem-solving and analytical skills * Excellent communication and collaboration skills WHAT YOU WILL GET FROM US: * Industry competitive salary * The chance to be part of building something from the ground up. Aggressive growth plans of the organization mean there is no limit to how far you can grow your career with the organization * An environment that promotes a healthy work-life balance * Open and collaborative work environment. You bring your great ideas, and we will put them to action * Comprehensive benefits plan * The opportunity to travel where we fly We’re an Equal Employment Opportunity employer that places value on the strength that diversity brings to the workplace and that prohibits discrimination or harassment of any kind. Our employment decisions are based on business needs, job requirements, and individual qualifications without regard to race, colour, religion, gender, sexual orientation, marital status, gender identity or expression, national origin, age, disability status, or any other characteristic protected by applicable law. We encourage all applicants who meet the requirements for the role to apply. Interviews will be commencing right away, so don’t hesitate and apply today to be part of Canada’s changing aviation landscape! Cover letters are not required. Powered by JazzHR MDnx0hRbFt Job ID: 4249400
Lynx Air

View original article here Source