Database Developer/Analyst

New!

Canaccord Genuity Corp. Vancouver , BC 98685

Posted Today

Database Developer/Analyst, IT
Vancouver Job #7017Who we are:Canaccord Genuity (CG) is a leading independent full-service financial services firm, with operations in two principal segments of the securities industry: wealth management and capital markets. CG is driven by an unwavering commitment to build lasting client relationships we achieve this by generating value for our individual, institutional, and corporate clients through comprehensive wealth management solutions and investment banking services. We are a leading independent wealth management firm in Canada, and the leading mid-market provider of investment banking advisory, equity research, sales and trading services for corporations and institutions.We pride ourselves on understanding our clients needs and finding innovative, bespoke solutions. Our entrepreneurial and friendly team will challenge you to learn and grow every day. We value great work and collaboration and strive to eliminate bureaucratic thinking. Were looking for talented people who thrive in a fast-paced environment and want to have an impact with innovative ideas and best practices.Come be a part of our Canadian success story and help deliver superior experiences for our clients. At CG, we recognize that diversity across our business strengthens our client relationships and enables more innovative solutions. We strongly encourage applications from all qualified individuals regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. CG provides an accessible candidate experience. If you need any accommodations throughout the interview process and beyond, please let us know.Our Canadian operation, Canaccord Genuity Corp., is currently looking for a Database Developer/Analyst to join our IT Enterprise Development team based in Vancouver. Working in a fast-paced, multi-tasking environment, this role will work directly with business units to envision and develop solutions such as data integration, automation of manual processes, data reconciliation, and creation of reports.Responsibilities:
  • Analyze data-related business problems and propose solutions;
  • Design and develop database components for small/medium to large sized projects;
  • Troubleshoot and resolve data-related issues;
  • Develop a deep understanding of business processes;
  • Provide a positive experience of IT services and support being delivered to customers and business stakeholders;
  • Participate in the change management process by communicating technical impacts of changes;
  • Provide assistance to project teams as required.
Skills & Qualifications:
  • B.Sc. in Computer Science or a similar program with database administration and development experience;
  • 3-5 years of related experience working in a complex environment;
  • Strong verbal and written communication skills;
  • Experience using Azure SQL/MI and SQL Server 2014/2016/2017;
  • Strong T-SQL development skills;
  • ETL development using SSIS (Azure Data Factory & LogicApps is required);
  • Experience with SSRS, SSAS, Power BI is a plus;
  • An understanding of brokerage accounting is a strong asset;
  • Familiarity with cloud technologies and infrastructure is an asset;
  • Excellent system analysis and troubleshooting skills;
  • Ability to work effectively independently and within a team environment;
  • Effective interpersonal skills.
#INDHP
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Administrator/Analyst
New!

Canaccord Genuity Corp.

Posted Today

VIEW JOBS 9/26/2022 12:00:00 AM 2022-12-25T00:00 <strong>Database Administrator/Analyst, ITVancouver – Job #7418Who we are:Canaccord Genuity (CG)</strong> is a leading independent full-service financial services firm, with operations in two principal segments of the securities industry:  wealth management and capital markets.  CG is driven by an unwavering commitment to build lasting client relationships – we achieve this by generating value for our individual, institutional, and corporate clients through comprehensive wealth management solutions and investment banking services.  We are a leading independent wealth management firm in Canada, and the leading mid-market provider of investment banking advisory, equity research, sales and trading services for corporations and institutions.We pride ourselves on understanding our clients’ needs and finding innovative, bespoke solutions.  Our entrepreneurial and friendly team will challenge you to learn and grow every day.  We value great work and collaboration and strive to eliminate bureaucratic thinking.  We’re looking for talented people who thrive in a fast-paced environment and want to have an impact with innovative ideas and best practices.Come be a part of our Canadian success story and help deliver superior experiences for our clients. At CG, we recognize that diversity across our business strengthens our client relationships and enables more innovative solutions.  We strongly encourage applications from all qualified individuals regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. CG provides an accessible candidate experience. If you need any accommodations throughout the interview process and beyond, please let us know.Our Canadian operation, Canaccord Genuity Corp., is currently looking for a Database Administrator/Analyst to join our IT Enterprise Development team based in Vancouver. Working in a fast-paced, multi-tasking environment, this role will work directly with business units to envision and develop solutions such as data integration, automation of manual processes, data reconciliation, and administration of core data platform. <strong>Responsibilities:</strong><ul><li style="padding: 0; margin: 0;">Based on a support schedule: </li><li style="padding: 0; margin: 0;">Monitor overnight production data processes (ETL) on weeknights by responding to database-related alerts and escalations ;</li><li style="padding: 0; margin: 0;">Provide database-related support on weekends as required ;</li><li style="padding: 0; margin: 0;">Assist Business Analysts and Data Stewards on data inquiries and data analysis; </li><li style="padding: 0; margin: 0;">Collaborate with the Infrastructure Group in designing, building, operating, and optimizing the SQL environment in various regions;</li><li style="padding: 0; margin: 0;">Own, track, and resolve database-related incidents within SLAs;</li><li style="padding: 0; margin: 0;">Participate in the change management processes by communicating technical impacts of database changes;</li><li style="padding: 0; margin: 0;">Manage security and access to databases; </li><li style="padding: 0; margin: 0;">Develop enhancements and break-fixes to existing database processes; </li><li style="padding: 0; margin: 0;">Provide assistance to project teams as assigned by the Manager.</li></ul><strong>Skills & Qualifications:</strong><ul><li style="padding: 0; margin: 0;">Completion of a recognized technical degree or program with focus on database administration and development;</li><li style="padding: 0; margin: 0;">2 to 5 years of database administration experience for MS SQL Server 2014/2016/2017/2019 and Azure SQL in a professional setting; </li><li style="padding: 0; margin: 0;">Experience with ETL technologies and automation tools: Microsoft SQL Server Integration Services (SSIS) or a similar ETL Tool, PowerShell Scripting, XML, JSON; </li><li style="padding: 0; margin: 0;">Experience with Azure Data Factory and Logic Apps is a strong asset;</li><li style="padding: 0; margin: 0;">Knowledge of Oracle is an asset; </li><li style="padding: 0; margin: 0;">Strong experience in database performance tuning, optimization, and analysis of MS SQL processes and queries; </li><li style="padding: 0; margin: 0;">Thorough understanding of database performance monitoring and analysis tools; </li><li style="padding: 0; margin: 0;">Competency in database server specification, performance tuning and analysis; </li><li style="padding: 0; margin: 0;">Strong experience in database disaster recovery planning and recovery; </li><li style="padding: 0; margin: 0;">Demonstrated ability to solve complex database administration problems; </li><li style="padding: 0; margin: 0;">Ability to work with developers to analyze and resolve database performance issues; </li><li style="padding: 0; margin: 0;">Team-player, flexible and able to work independently in a fast-paced and multi-tasking environment; </li><li style="padding: 0; margin: 0;">Strong interpersonal, written and verbal communication skills; </li><li style="padding: 0; margin: 0;">Strong time management skills, detail-oriented with the ability to manage tasks with varying priorities; </li><li style="padding: 0; margin: 0;">Excellent interpersonal skills.</li></ul>#INDHP Canaccord Genuity Corp. Vancouver BC

Database Developer/Analyst

Canaccord Genuity Corp.