Data Engineer

What you'll do Responsibilities What You'll DoSystem Knowledge and Expertise: Develop and maintain functional knowledge and technical expertise of in-house Analytics systems and financial system integration. Ensure analytics systems and financial system integrations are available, secure, and performing satisfactorily, in compliance with defined Service Level Agreements (SLAs).Documentation and Specifications: Lead the creation and maintenance of all system documentation, including BI Requirements, Report Specifications, Data Warehousing Requirements, Interface Specifications, and Data Mapping Specifications.Project and Release Planning: Provide accurate assessments and estimates for project and release plans.Data Integration and Visualization: Lead the development of data integration, application integration, exposing data to users, reports, dashboards, and data visualization that comply with corporate standards of Quality, Operations, and Security.Support and Training: Provide secondary application support to business users and offer training and knowledge transfer to the applicable primary support departments What you'll need Qualifications Education and Experience:At least three years of progressive experience in BI application development, application integration, data integration, data pipelining, and ETL development, with a focus on informing and empowering product teams.Hands-on experience in principled data warehouse design, data visualization and data pipeline design and developmentUniversity degree, community college technology diploma, professional certification or membership in computer sciences, Information Management, or related field.Technical data integration and data analysis skills.Two years' experience with Oracle PL-SQL/ODI or Microsoft TSQL/SSIS.Must be 19 years of age or older to apply.Must reside in Atlantic Canada.Professional Skills:Proven experience working in a team-oriented, collaborative environment is essential.Experience in working independently and driving projects end to end.Must possess strong technical data integration and data analysis skills.Ability to document/maintain report specifications, develop, and test reports/dashboards.Must possess strong written and oral skills.Excellent communication skills, with the ability to engage directly with senior business leaders, integrate with business teams, and present solutions to stakeholders.Ability to exercise discretion and judgment.Analytical and problem-solving abilities.Assets:Experience integrating with financial systems, particularly Oracle E-Business Suite.Experience using scripting technologies such as Python or PowerShell.Experience using Data Lakes.Application Deadline: Posting will remain open until the position is filled or interviews begin.Salary Band: $75,200 - $122,200 - A reasonable estimate of the pay range for this role is $76,000 - $90,000 at the time of this posting. (Individual pay is determined by factors such as job-related skills, market conditions, relevant experience, education, training and internal equity).Work Location: Office or Hybrid option working from Moncton.Onboarding/Probation: Full-time in-office for the first 6 months, based in Moncton, NB preferred.After Probation: You can choose to either continue working full-time in the office or switch to a hybrid model, coming into the office 2-3 times a week.AL Benefits:Extended health coverage that includes medical, dental, and vision.Basic life insurance and disability.Defined Benefit Pension Plan.Three weeks of vacation annually (pro-rated) and 13 paid statutory holidays. Plus, we have a vacation purchasing program.Wellness Support: Wellness programs focused on physical and nutritional health (and more), 3 paid personal care days and a 24/7 Employee & Family Assistance Program.Two volunteer days per year.Career advancement opportunities.Recruitment Process: Over the past few years, we have embraced meaningful changes in our workplace, including enhancements to our hiring practices. Our typical recruitment process includes two in-person interviews, an assignment and/or scenario-based questions to assess your knowledge, behavioral or cognitive assessments, and verification of relevant certifications, where applicable. All interviews are conducted in English, our primary working language, unless otherwise specified.We appreciate the interest of all applicants; however, only those selected for an interview will be contacted. Please note that the successful candidate will be required to undergo reference checks and a mandatory criminal background check. Depending on the role, financial, educational, and credential verifications may also be conducted as part of our comprehensive hiring process.Internal Employees: Internal employees interested in this opportunity must be in 'good standing,' which includes meeting expectations on their last performance review. Performance improvement plans, disciplinary action, attendance, mandatory training, and other performance-related items will also be taken into consideration when determining the applicant's 'good standing' status. Please note that the Predictive Index (PI) assessment will be conducted or, if already completed, provided to the hiring managers.Eligibility to Work in Canada: As applicable, candidates must have acquired all required work permits/visas and other authorizations and otherwise be eligible to work in Canada at the time any offer of employment is made by AL. It is the sole responsibility of the candidate to obtain all required work permits/visas and other authorizations.