Programmer Analyst

BFL Canada - Vancouver, BC (30+ days ago)

Apply Now

Job Details

Founded in 1987 by Barry F. Lorenzetti, BFL CANADA is one of the largest employee-owned and operated Risk Management, Insurance Brokerage, and Employee Benefits consulting services firms in Canada. The firm has a team of over 700 professionals located in eighteen offices across the country. BFL CANADA is a founding Partner of Lockton Global LLP, a Partnership of independent insurance brokers who provide Risk Management, Insurance and Benefits Consulting services in over 130 countries around the world.

Here at BFL our employees have the freedom to demonstrate their own creativity, leadership and entrepreneurship because we strongly believe in them. We are a national collaborative team that thrives in a fast-paced environment.


Plan phases of the software development life cycle (SDLC) for a variety of projects.
Assist in the preparation and documentation of software requirements and specifications.
Research and document requirements of software users.
Consistently write, translate, and code software programs and applications according to specifications.
Run and monitor software performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging.
Assist in the development and maintenance of user manuals and guidelines.
Liaise with network administrators, systems analysts, and software engineers to assist in resolving problems with software products or company software systems.
Collaborate with analysts and designers in the development and initiation of new software programs and applications.
Oversee the quality assurance of program logic, data processing, and error resolution.
Develop an awareness of programming and design alternatives.
Take an active role in cross-departmental projects when needed.
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
Monitor, optimize, and allocate physical data storage for database systems.
Plan and coordinate data migrations between systems.
Develop, implement, and maintain change control and testing processes for modifications to databases.
Establish appropriate end-user database access control levels.
Plan, execute, and manage the integration of new applications into existing systems and software throughout the enterprise.
Ensure that integration projects meet business requirements and goals, fulfill end-user requirements, and identify and resolve systems issues.
Ensure that integration planning and practices are aligned with strategic business goals and the company’s overall strategic vision.
Develop standards and processes to support and facilitate integration projects and initiatives.


Strong time management, communication and organizational skills
Work well under pressure
Follow procedures accurately
Work well with others throughout the organization, independently and as part of a team
SQL Server: Stored procedures, table designs and triggers, Jobs
MS Office (Excel, Word, Access)
Exposure to Object Oriented design
Experience working with third party software like Infragistics Netadvantage, vendor API’s
SSRS (SQL Reporting Services – client side)

Reports to: Solutions Development Manager


You will be working in a thriving, progressive and well-established insurance brokerage company
Competitive salary, group insurance benefits, and RRSP matching plans from your first day
A culture that encourages and supports continued education

Let’s stay in touch: follow us on LinkedIn to see what we are up to and check out our other job openings.

To apply visit our website: