Specialist, Data & Analytics - Jobs in Dorval, QC

Job Description

DescriptionBeing part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.Air Canada seeks technically experienced Specialist, Data & Analytics (DevOps) who is highly motivated and who will be responsible for helping to define and build the future state of Air Canada’s data integration and data lake platform. You will be working closely with a team of skilled data engineers as well as our management team and other stakeholders to develop the strategy, technical solution and implementation roadmap.Successful candidate should be able to execute and automate operational processes with utmost quality, accuracy and security.This position will be reporting to the Manager, Data & Analytics.Key Responsibilities & ActivitiesResponsible for design and build-out of data models, codification of business rules, mapping of data sources to the data models (structured and unstructured), engineering of scalable ETL pipelines, development of data quality solutions, and continuous evaluation of technologies to continue to enhance the capabilities of the Data Engineering team and broader Product and Analytics teamsMake sure data engineering initiatives are properly supported at the infrastructure and architecture levelsAutomate the build and release of multiple projects by implementing automation tools and frameworks (CI/CD pipelines).Maintain code branches along with integrations of code across multiple branches.Configure complex installations and quickly resolve all defects or script issues found within the installation.Collaborate with cross-functional teams to solve development constraints and deployment issuesApply effective coding practices for error-free timely release.Maintain and update technical documents and procedures accompanied by configuration and design of database models relative to the requirements of the organizationMaintain data standard and security measures through the implementation of information technology plans, policies, and standards.Conduct metadata management, data cleansing and conformingUse sound agile development practices (code reviews, testing, etc) to develop and deliver data pipelinesProvide day-to-day support and technical expertise to both technical and non-technical teamsFollow DevOps delivery model and recommend adjustments based on results, when needed.Help implement guidelines, standards, and procedures and provide recommendations for improvements.Understand the various application architectures and ensure development of supportable automation processes.Coordinate with Architecture and Quality teams to ensure timely delivery of projects, features, bugfixes, and infrastructure improvements into multiple production environmentsLead and coordinate the go-live activities essential to the execution of the deployment plans/checklistsQualificationsA relevant University degree/technical certification, and/or relevant experience commensurate to the role9-12 years of IT technology, operations and people leadership experience in a large company4+ years of DevOps or related experience with gradually increasing responsibilities and a demonstrated understanding of DevOps and technical quality control processes, artifacts and tools.Certifications in core programming languages, agile methodologies (CSPO, PMI-ACP, etc.)Proficiency in Scala, Python, Java or Javascript, and relational databases (Oracle, DB2, SQL Server, etc.)Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) and familiarity with NoSQL databases such as Cassandra and MongoExperience with data warehousing, and cloud computing platforms like Microsoft Azure, AWS or Google Cloud.AWS certification is preferred.Experience with cloud-based monitoring logging, cost analysis toolsSolid experience as a DevOps Engineer, including automation experience with configuration management tools.Track record working with data from multiple sourcesStrong project management and organizational skillsAPI development experience an assetExperience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvementKnowledge of the tooling for deployment, monitoring and site reliabilityDemonstrated experience working with Agile Ops/DevOps teams, including KPI development for efficiency tracking.Experience supporting and working with cross-functional teams in a dynamic environment.Experience with Big Data technologies (e.g Hadoop, Hive, HBase, Spark, Kafka, Storm, Cassandra, Columnar Databases or Graph Databases) and with ETL technologies (e.g SSIS, Informatica or Datastage)Strong scripting (e.g. Python) and automation skills.Experience and proficiency with Linux system administration.Experience with version control repositories like GIT Knowledge of containerization tools (e.g. Docker)Understanding network topologies and common network protocols and services.Effective and professional oral and written communication skills, interfacing with internal peers, upper management, and customers.Team player and ability to function effectively in a fast paced, team-oriented work environment with a bias toward action.Ability to understand and affect decisions strategically for the interest of Air Canada first and foremostLinguistic RequirementsBased on equal qualifications, preference will be given to bilingual candidates.Diversity and InclusionAir Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees’ unique contributions to our company’s success.As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.