About the role
Title: Data Analyst/SQL developer
Location: Vancouver - Hybrid (3 days onsite)
Contract Length: 12 Months.
Must haves:
• 9 -11 years of IT Experience
• 9 years of exp in SQL Ecosystems-SSRS/SSIS/SSAS
• Unix experience
• Expertise in SQL development and database management.
Nice to have:
• Python
• Previous Banking/Financial/wealth management
Responsibilities:
Design, develop, and maintain stored procedures that support business reporting needs.
Optimize queries and database operations to ensure performance and reliability.
Collaborate with business to translate reporting requirements into data flows/ Queries
Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
Ensure data quality, integrity, and security throughout the data flow process.
Work closely with data engineering and data architects to understand and implement best practices for data integration.
Troubleshoot and resolve issues related to job execution and data flow interruptions.
Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
Assist with audits and implement improvements based on audit findings.
About the role
Title: Data Analyst/SQL developer
Location: Vancouver - Hybrid (3 days onsite)
Contract Length: 12 Months.
Must haves:
• 9 -11 years of IT Experience
• 9 years of exp in SQL Ecosystems-SSRS/SSIS/SSAS
• Unix experience
• Expertise in SQL development and database management.
Nice to have:
• Python
• Previous Banking/Financial/wealth management
Responsibilities:
Design, develop, and maintain stored procedures that support business reporting needs.
Optimize queries and database operations to ensure performance and reliability.
Collaborate with business to translate reporting requirements into data flows/ Queries
Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
Ensure data quality, integrity, and security throughout the data flow process.
Work closely with data engineering and data architects to understand and implement best practices for data integration.
Troubleshoot and resolve issues related to job execution and data flow interruptions.
Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
Assist with audits and implement improvements based on audit findings.