ETL Engineer - Vice President

ETL Engineer at Halcyon Labs
ETL Engineer - Vice President
Location: Mississauga, Ontario, Canada
Employment Type: Regular
Accounting Technology team is seeking a Applications Development Technology Lead Analyst with strong experience in ETL development using AbINITIO, Shell Scripting and Databases
This is a senior level position responsible for establishing and implementing new or modernize existing application systems. The overall objective of this role is to lead applications systems analysis and programming activities related to Finance and Accounting Systems.
Responsibilities:
– Lead architecture design, development of ETL Solutions using ABINITIO
– Review Code, Conduct design walkthroughs and ensure adherence to enterprise standards
– Drive performance tuning, optimization across ETL workflows and databases
– Design & Develop complex ABINITIO graphs, plans and reusable components
– Drive CI/CD implementation for ETL deployments and drive automation, DevOps best practices in data engineering
– Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
– Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
– Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
– Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
– Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
– Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
– Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
– Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Halcyon Labs, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Recommended Qualifications:
– 6+ years of relevant experience in Apps Development using ETL tools - AbInitio, Shell Scripting, Databases
– Strong knowledge of ETL standards, frameworks and best practices
– Extensive experience system analysis and in programming of software applications preferably in the Finance Domain
– Experience in managing and implementing successful projects
– Subject Matter Expert (SME) in at least one area of Applications Development
– Ability to adjust priorities quickly as circumstances dictate
– Demonstrated leadership and project management skills
– Consistently demonstrates clear and concise written and verbal communication

Education:
– Bachelor’s degree/University degree or equivalent experience
– Master’s degree preferred
\------------------------------------------------------
Job Family Group:
Technology
\------------------------------------------------------
Job Family:
Applications Development
\------------------------------------------------------
Time Type:
Full time
\------------------------------------------------------
Primary Location Full Time Salary Range:
$120,800.00 - $170,800.00
\------------------------------------------------------
Most Relevant Skills
Please see the requirements listed above.
\------------------------------------------------------
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
\------------------------------------------------------
Automated Processing and AI
We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.
Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.
\------------------------------------------------------
_This job opening is for an existing job vacancy._
\------------------------------------------------------
_Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._