Data Engineer

<strong>Your next workplace is the sky<br /></strong><br />You love to travel, and you love fair, friendly and frequent flights. We&rsquo;re a new airline with deep roots in the industry, and we&rsquo;re looking for people like you! <br /><br /><strong>Join our crew.</strong>

Calgary, AB

Lynx Air

<p>You love to travel, and you love fair, friendly and frequent flights.</p> <p>We're a new airline with deep roots in the industry, and we're looking for people like you!&nbsp;<br /><br />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 passengers 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.<br /><br />Join our team and be part of the changing skies of Canadian aviation!</p> http://www.flylynx.com

keywords: organization,join,engineering,teamwork,develop,performance,full-stack,build,design,implementation,create,etl,experience,skills,degree,analysis,communication

Mid Level

Overview: <p>Are you excited about the prospect of joining a startup organization?</p> <p>Interested in being a part of the changing skies in Canada and beyond?</p> <p>Want to work with world-class leaders who have extensive industry know-how?</p> <p>Curious about how it feels to contribute and join Canada&rsquo;s newest airline while redefining affordable air travel?</p> <p>If so, we have an exciting opportunity for you!</p> <p>We are seeking a Data Engineer for our IT Department to join our rapidly expanding, dynamic team!</p> <p>&nbsp;</p>
Responsibilities: <ul> <li>Design, build, and maintain data warehousing systems using Microsoft SQL Server and Azure Data Warehouse to store, process, and analyze large amounts of data.</li> <li>Develop and maintain ETL processes to extract, transform, and load data from various sources</li> <li>Build and maintain dimensional data models and star schema designs</li> <li>Create and maintain data integration and data migration processes</li> <li>Work with cross-functional teams to understand data requirements and design solutions</li> <li>Implement data governance and security measures using Azure Active Directory and Azure Data Security to ensure data integrity and confidentiality for Power BI reports.</li> <li>Collaborate with cross-functional teams to integrate Power BI reports with other software applications using Microsoft API.</li> <li>Troubleshoot and resolve data warehousing and ETL issues</li> <li>Develop and implement interactive data visualization tools using Power BI to provide insights into business data.</li> <li>Stay up-to-date with new technologies and tools related to data warehousing, full-stack development, and Power BI in the Microsoft ecosystem.</li> <li>Monitor and optimize data warehousing performance</li> </ul>
Requirements: <ul> <li>Bachelor's degree in Computer Science, Information Systems, or a related field</li> <li>5+ years of experience in data warehousing and ETL development</li> <li>Strong SQL skills and experience with relational databases such as Oracle, SQL Server, and MySQL</li> <li>Experience with ETL tools such as Informatica, Talend, or Alteryx</li> <li>Experience with data warehousing platforms such as AWS Redshift, Snowflake, or Azure Synapse Analytics</li> <li>Experience with data modelling and star schema design</li> <li>Strong experience with scripting languages such as Python or JavaScript</li> <li>Experience with BI and reporting tools such as Power BI and/or Tableau</li> <li>Strong problem-solving and analytical skills</li> <li>Excellent communication and collaboration skills</li> </ul>