Job Description

Address: 100 King Street West

Job Family Group: Technology

At BMO our work options encourage flexibility around when and where you work, and a focus on personal wellness and work-life boundaries.

AWS Cloud Developers are responsible for the implementation, configuration, maintenance and performance of both development within the AWS cloud environment and DBA responsibilities. Their main goal is to ensure the availability and consistent performance of various applications.

We are looking for an experienced ETL developer that is seasoned in both the AWS suite of development tools and as a SQL Server Developer to handle database creation and load activities! As AWS Cloud developer you will be responsible for the implementation, configuration, maintenance, and performance of the AWS cloud environment and the SQL server configurations within it.

To be successful , you MUST have AWS Cloud experience, and 5+ years on AWS Glue, S3, Redshift, Data warehouse knowledge, ETL processing, SQL querying.

****This is a Virtual/REMOTE role, you MUST physically reside in Toronto.

You may be asked to work at a BMO office on an exception basis which can be discussed with the hiring leader.

Key responsibilities:

• Developing and implementing best practices for AWS applications.
• Create ETL jobs to ingest and move data within the AWS environment using Glue
• Automation scripting within the environment using either Glue or CloudWatch
• Manage Redshift databases
• Configure and maintain database servers and processes
• Participate and contribute in the full project life cycle, including gathering requirements, system design, implementation, testing, deployment, and support of applications.
• Follow standard software development methodologies and SDLC practices to produce high quality applications in an efficient manner.
• Participate in estimating assigned work effort and be accountable for completion dates
• Document code and support release management as needed
• Reverse engineering of existing code and perform impact analysis of the changes done with regard to earlier written documentation
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours

KEY Skills and Experience:

• MUST HAVE AWS Cloud Experience: 5+ years of developing experience in the Amazon Cloud services AWS (S3, Lamba, AWS Glue, Amazon Redshift, Data Lake, etc.)
• MUST Have worked and led at least 1 data migration project into Redshift (AWS Glue)
• 2+ years experience with Python and
• 2+ years of ETL development and Migration experience
• Nice to have 2 years of experience with AIX/Linux shell scripting.
• Worked on at least 1 data migration project into Redshift (AWS Glue)
• Ability to perform data manipulations, load, extract from several sources of data into another schema.
• Understanding of core AWS services, and basic AWS architecture best practices.
• Proficiency in developing, deploying, and debugging cloud-based data assets.
• Proficiency in SQL and ability to design schemas to meet the requirements.

Understands that the success of a developer is to understand the core business processes of the business unit and business requirements as well as the architecture patterns and technology strategy (e.g., Transformation, SmartCore, DevOps). Conceive and write detailed software implementations/code while ensuring that their code/configurations adhere to the security, logging, error handling, and performance standards and non-functional requirements. Writes, configures, and integrates code to create the software that aligns with architecture patterns and technology strategy. Understands the implications of various components (including technology strategy & architecture) to the overall design of a program, system, or eco-system. Evaluates new technologies for fit with the program/system/eco-system and the associated upstream and downstream impacts on process, data, risk (e.g., security). Works toward the objective of defect free software. Ensures that systems functionally meet requirements, align with architecture and promote the development of common assets. Supports the resolution of production issues and problems. Makes recommendations to improve BMO processes & systems.

• Assesses impact of design decisions to the computer solution/product/service being developed (i.e. performance, schedule, budget, downstream component/system impact, quality, etc.) and recommends alternate/creative solutions for mitigation/optimization if required.
• Recommends and implements solutions based on analysis of issues and implications for the business.
• Identifies emerging issues and trends to inform decision-making.
• Leads and implements initiatives as required to deliver business objectives.
• Conducts independent analysis and assessment to resolve strategic issues.
• Builds effective relationships with internal/external stakeholders and ensures alignment.
• Monitors and tracks performance, and addresses any issues.
• Leads/conducts detailed code-reviews and provides feedback in a constructive manner.
• Decomposes business requirements and translates them into detailed design specifications and code.
• Interacts with key business & technology stakeholders to define, analyze, and deliver requirements that reflect the needs of both the business and end-customers.
• Assesses the costs and benefits for different solutions and recommend/decide on appropriate designs.
• Designs solutions, writes code, performs unit testing, develops appropriate artefacts / documentation, and facilitates final delivery.
• Supports production issues, includes independently completing root-cause analysis and diagnosis.
• Devises new algorithms and data structures for target environment and platform attributes in alignment with architectural patterns.
• Builds solutions that are supportable, scalable and achieve our aspiration of common assets.
• Recommends or automates approaches to streamline and integrate technological processes and/or systems to improve operational efficiency and effectiveness.
• Supports the management of specific project deliverables & outcomes.
• Identifies opportunities to strengthen the development capability, such as: sharing expertise to promote technical development, mentoring employees, building communities of practice and networks.
• Stays abreast of industry technical and business trends through participation in professional associations, practice communities & individual learning.
• Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
• Provides specialized consulting, analytical and technical support.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works independently and regularly handles non-routine situations.
• Broader work or accountabilities may be assigned as needed.

Qualifications:

• Typically between 5 - 7 years of relevant experience and/or certification in related field of study or an equivalent combination of education and experience.
• Advanced level of knowledge in domain.
• Knowledge of software development practices, concepts, and technology obtained through formal training and/or work experience.
• Knowledge of required programming languages and can code with little oversight.
• Knowledge of technical/business environment and processes.
• Understand functional aspects and technical behavior of the underlying operating system, development environment, and deployment practices.
• Have facility with and understanding of the ecosystem that code operates in.
• Deep knowledge and technical proficiency gained through extensive education and business experience.
• Verbal & written communication skills - In-depth.
• Collaboration & team skills - In-depth.
• Analytical and problem solving skills - In-depth.
• Influence skills - In-depth.
• Data driven decision making - In-depth.

We're here to help

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one - for yourself and our customers. We'll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we'll help you gain valuable experience, and broaden your skillset.

To find out more visit us at .

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other's differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.