Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Bilingual Customer Service - French and Part Time Sales Service In-Home Usage Tester Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Product Tester at Home Sales Representative Sales Representative Line Cook Sales Representative Product Tester at Home In-Home Usage Tester Product Tester at Home Service Service Customer Service - Work from Home Service In-Home Usage Tester Sales Representative Senior Accountant Marchandiseurs en Vente Bilingual Customer Service - French and Product Tester at Home Customer Service - Work from Home Customer Service - Work from Home Service Product Tester at Home Product Tester at Home Product Tester at Home Service client Product Tester at Home Sales Representative Product Tester at Home Product Tester at Home Bilingual Customer Service - French and Product Tester at Home Service Customer Service - Work from Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Customer Service - Work from Home In-Home Usage Tester Customer Service - Work from Home In-Home Usage Tester Product Tester at Home Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Two Sigma WeWork Aecom Exact Media Aerotek Jane Street First Convenience Bank Doordash AsteroidX AT&T Shopify Insight Global Creative Circle Hatchways Clickworker Borrowell Square Vector Marketing Amazon Flex LowCostWebDesignFirm.com Walgreens Recovhub Instacart American Income Life Scotiabank 51talk TD Bank Akira Microsoft Paylocity UnitedHealth Group Top Hat CI&T mappedin Desjardins Checkout 51 Mobeewave The Youth Connection GoParkr Peel Regional Police Hootsuite autoTRADER.ca ScribbleLive SnapTravel Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Senior SQL Developer At BMO Financial Group

Location: Chicago, Illinois

Job Description

Description

The Senior Sql Developer is responsible for the completion of project deliverables and may be asked to be accountable for the overall analysis, design, development, implementation and support of applications to ensure and/or maintain alignment with the Lines Of Business (LOBs) within the Wealth Management area. The Senior SQL Developer typically deals at a high level of complexity and scope.
_____________________________________________________________________________________

Accountabilities

  • Performs in-depth analyses on production problems, identifies root causes, and recommends solutions to resolve application malfunctions and prevent recurrence
  • Assumes the role of Support / Systems Analyst interacting and collaborating with team members and other departments, as appropriate, in order to gain knowledge relevant to application support (such as understanding new functionalities, what parts of the system is being changed, and required environmental changes) to ensure Service Level Agreement (SLA) initiatives are supported
  • Writes code according to accepted standards based on user requirements, which are included in the delivery of the application solution, to meet the business need
  • Participates in the planning, estimating, development, testing and implementation of initiatives of any size and any level of complexity to meet the functional and non-functional requirements of the application. The resulting artifacts will be used to better understand, communicate, and provide specifications during the coding and Quality Assurance activities
  • Participates in project and team meetings interacting and collaborating with team members and other departments when appropriate, to provide a developer’s perspective in the meetings and to contribute to the timely delivery, design, and quality of various work artifacts adhering to standards
  • Involved in process and application improvement opportunities to improve the reliability and extensibility of the application and to improve the overall Service Level Agreement (SLA).
  • Liaises with third party vendors, when appropriate, to ensure that the integration of third party products and existing applications and systems is practical and feasible given the underlining technologies
  • Collaborates with Development Technology Services (DTS) in the requirements definition and analysis and to select development, testing, and implementation tools for the Application Software Development staff
  • Participates in software development Process Action Teams and contributes to the continuous improvement of the Software Development Life Cycle (SDLC) processes for the overall effectiveness of the development
  • Participates in Disaster Recovery exercises, as a member of the technical recovery team or control center and contribute to the success of the Disaster Recovery tests



Qualifications

Qualifications

Knowledge
  • Possesses a university degree/college diploma in applied technologies and/or 7+ years systems analysis and programming experience with extensive business knowledge
  • Exhibits solid analytic ability for complex problem solving
  • Exhibits solid knowledge of databases
  • Possesses expert knowledge of design and analysis methodology and application development processes from both an industry and BMO perspective
  • Demonstrates expert understanding of the Software Development Life Cycle (SDLC), Quality Assurance requirements and software development control and release procedures.

Technical Skills
  • Development experience with SQL - Stored Procedures, SSIS, SSRS, reporting queries required
  • Previous MS SQL Server development experience in a support/maintenance role required
  • Experience with SQL scripting, database development, highly preferred
  • PowerShell or other scripting preferred
  • Development experience in a Microsoft Windows C# environment preferred
  • Is able adapt and quickly develop in-depth technical understanding of new/different applications
  • Demonstrates solid organizational skills
  • Exhibits solid communication skills, both written and verbal
  • Possesses expert understanding of relevant technologies
Technical Skills – additional (nice to haves)
  • Windows command line scripting and batch file automation
  • Code (debugging) analysis utilizing Visual Studio preferred
  • Scheduling and batch job sequencing logic
  • Basic Windows server OS troubleshooting
  • Technical specification documentation development/writing skills
Desirable Skills
  • Asset Management experience – technical support or otherwise
  • Wealth Management and/or Capital Markets exposure
  • Enterprise banking environment development and/or support experience

We’re here to help

At BMO Harris Bank we have a shared purpose; we put the customer at the center of everything we do – helping people is in our DNA. For 200 years we have thought about the future—the future of our customers, our communities and our people. We help our customers and our communities by working together, innovating and pushing boundaries to bring them our very best every day. Together we’re changing the way people think about a bank.
As a member of the BMO Harris Bank 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 https://bmoharriscareers.com/

BMO Harris Bank 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. BMO Harris Bank is an Equal Opportunity Employer for all, inclusive of Minorities, Women, Veterans, and Persons with Disabilities.

Job

Information Technology

Primary Location

United States-Illinois-Chicago

Organisation

Technology-X000068

Schedule

full-time

Job Posting

11/19/18

Unposting Date

Ongoing