Hybrid Database Engineer/Developer - Bc Pension Corporation

Determine approaches, processes, and procedures for integrating new technology into the existing and new application infrastructure

Why choose us?
There is more to Pension Corporation than you might think. We are an award-winning organization with meaningful purpose-driven work, where staff have impact and create peace of mind for those we serve. We have cultivated an outstanding community rooted in respect, where employees are inspired to have courage, take action, and be at their best every day.
Our new nine-year strategic plan, Plan 20|30: Our Future is Insight , will guide us from 2021 to 2030. To learn about our aspirations and objectives and how you can be a part of a people-focused organization that is grounded in operational excellence, visit bcpensioncorp.ca .

What we offer:

• Flexible work options (modified workweek, on-campus work, or a hybrid of home/on-campus)
• Comprehensive extended health and dental benefits for you and your family
• Defined benefit pension program
• Health & wellness programs - lunchtime seminars, community activities and a comprehensive Employee & Family Assistance Program
• Incredible campus with collaboration spaces, sit/stand desks, and lots of natural light
• Ongoing training, professional development opportunities, and scholarship programs
• Opportunities to give back to the community and support not-for-profits
• Seasonal events and socials
• A robust awards/recognition program
• Discounts on BC Transit passes, travel and accommodation, cell phones and plans, and more

Hybrid Work Model
This position is located in our Victoria, BC office. You will have the opportunity to work part of the time on-campus and part of the time off-campus. Guidelines and requirements for in-office presence are determined by operational need and vary according to the unique needs of each business area.??

The opportunity
We are seeking a Hybrid Database Engineer/Developer to join our team in VICTORIA, British Columbia, Canada
The Hybrid Database Engineer/Developer is part of the Data Warehouse Services team within the IT Engineering (ITE) Branch. This team determines approaches, process, and procedures for integrating new technology into the existing and new application infrastructure(s); implements and maintains core application infrastructure; and manages DevOps solutions that automate processes and enable product teams to deliver quality applications.
The Hybrid Database Engineer/Developer plays a pivotal role in building and operationalizing the data necessary for the enterprise data and analytics initiatives following industry standard practices and tools. The bulk of the position's work is building, managing, and optimizing data pipelines, moving them into production for key data and analytics consumers (such as business/data analysts, data scientists or any persona that needs curated data) for data and analytics use cases across the enterprise.
The position collaborates with other data professionals to optimize the quality, security and governance of data models and algorithms, putting them into production for large productivity gains .

What do you need to succeed?
Must-have

• University degree in Computer Science or related discipline and five years of related experience; OR Diploma in Computer Science or related discipline and six years of related experience; OR Certificate in Computer Science or related discipline, or program completion, and seven years of related experience; OR an equivalent combination of education, training and related experience.
• Related experience must include strong experience in two or more of the following:
• Working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies. These should include ETL/ELT, message-oriented data movement, API design and access and upcoming data ingestion and integration technologies such as stream data integration.
• Experience with Azure Data Lake, Data Factory, Databricks , Azure SQL Database , Azure SQL Datawarehouse etc. is required.
• Working with data governance/data quality and data security teams and specifically information stewards and privacy and security officers in moving data pipelines into production with appropriate data quality, governance and security standards and certification.
• Popular database programming languages including SQL, PL/SQL, T-SQL for relational databases and upcoming NoSQL databases like MongoDB, Cosmos, PostgreSQL, and others for nonrelational databases.
• Working with both open-source and commercial message queuing technologies such as Azure Service Bus, stream data integration and stream analytics technologies.
• Various Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance, Metadata Management.
• Basic experience working with popular data discovery, analytics and PowerBI software and others for semantic-layer-based data discovery.
• Basic experience working with DevOps capabilities like version control, automated builds, testing and release management capabilities using tools like GitHub, Jenkins, Ansible.

Preference may be given for those with

• Experience in working with cloud-native systems following IaC and DataOps principles (GitHub, CI/CD, orchestration, actions)
• Expertise and knowledge of SQL, Python, Azure Data Bricks, Synapse, ADF and PowerBI
• Experience with data-integration/ETL code in an enterprise data-warehouse environment
• Demonstrated success in working with both IT and business while integrating analytics and data science output into business processes and workflows.
• Experience in agile methodologies and capable of applying DevOps and increasingly DataOps principles to data pipelines to improve the communication, integration, reuse and automation of data flows between data managers and consumers across an organization.

Application requirements
Cover letter: Please do not submit a cover letter; it will not be reviewed.
Resume: A resume is required as part of your application. Ensure your resume includes your education, the start and end dates (month and year) of your employment, and any relevant information that relates to the job requirements.
Questionnaire: As part of the application process, you will be prompted to complete an online questionnaire to demonstrate how you meet the job requirements. Responses will be used to shortlist applicants against the job requirements. Please allow approximately 40 minutes to complete this questionnaire.
Please submit your application through the Apply Now feature on this page.
Applications will be accepted until 11:59pm PST on the closing date referenced above. Late applications will not be considered.

Diversity & Inclusion
BC Pension Corporation is an equal opportunity employer committed to establishing an inclusive, equitable, and accessible environment for all. All qualified applicants will receive consideration for employment without regard to race, national origin, age, religion, disability, sexual orientation, gender identity or expression, marital status or any other basis protected by applicable law.
We are committed to ensuring that reasonable accommodations are made available to persons with disabilities during the recruitment, assessment and selection processes and will provide reasonable accommodations upon request. If you require assistance or accommodation due to a disability, please email us at jobs@pensionsbc.ca .
Thank you for your interest in working with us. We will let you know about your status in this competition as soon as possible. If you have questions about this opportunity, please email us at jobs@pensionsbc.ca .
Apply here!
Images
Additional Info
Job Type : Full-Time
Location : Victoria, BC
Experience Level : Senior Level

Category

Software and Programming