Data Engineer

First West Credit Union

  • Langley City, BC
  • Permanent
  • Temps-plein
  • Il y a 2 mois
Job Category: Information TechnologyJob Description:We are currently seeking a Data Engineer to join our team.The Data Engineer is responsible for designing, building, and managing assets and pipelines for data collection, storage, and analysis within Microsoft and Oracle environments. This role involves integrating large datasets from multiple sources to ensure that data is accessible, consistent, and of high quality for reporting/dashboards, insights, and analytics. Experience is required with Microsoft Azure cloud services, SQL Server, Oracle Database, and Oracle Cloud Infrastructure to develop scalable data solutions. Additionally, responsibilities include ensuring our data pipelines are robust and secure, supporting data-driven decision-making across the organization.We are open to filling this role across Canada, however, please note preference will be given to those that are located in BC due to the proximity of our office locations. To be considered for this role, when applying, you must be eligible to work in Canada.Here's what would be included as a part of your typical day * Design and Develop Data Pipelines: Creates scalable data pipelines and ETL processes to extract, transform, and load (ETL) data from Microsoft and Oracle systems into centralized repositories. Use Fabric, Azure Data Factory and Oracle Data Integrator for efficient data extraction and transformation.
  • Data Storage & Management: Create and manage databases, data warehouses, and data lakes on Microsoft SQL Server/Azure and Oracle. Ensure high performance and reliability by designing, indexing, and partitioning relational databases. Monitor and tune database health to meet business needs.
  • Ensure Data Quality, Security, and Governance: Implement data quality controls, validation rules, and cleansing processes to maintain the integrity and accuracy of data within pipelines. Adhere to data governance standards and security protocols across both platforms, incorporating data masking or encryption where necessary, to ensure compliance with industry regulations and corporate policies.
  • Develop and Optimize Data Models: Design efficient data models and schemas for analytics and reporting on Azure and Oracle. Structure databases and data warehouses to support querying and BI reporting, and update architecture as needed.
  • Data Insights Support: Work with analytics teams to ensure that data is available and appropriately structured for BI tools. Provide curated datasets or views for reporting and assist in the creation of dashboards and reports, particularly with Microsoft Power BI, to convert raw data into actionable insights.
  • Performance Monitoring & Troubleshooting: Monitor data pipeline and database performance and quickly resolve any issues. Use monitoring tools and logs to identify anomalies or bottlenecks. Optimize SQL queries, ETL jobs, and storage designs to improve throughput and reduce latency or cost.
  • Reporting and Dashboarding: Design and develop efficient reports and dashboards in Power Bi-Microsoft Fabric and Oracle Analytics Cloud Platforms
Required Skills, Experience & Qualifications
  • Bachelor's degree in computer science, Information Systems, or a related field required.
  • 5 years of professional experience in data engineering, data platform management or related roles, or a combination of education and experience
  • Exceptional problem-solving and analytical skills to troubleshoot complex data issues and devise efficient solutions.
  • Excellent communication skills, with the ability to translate complex technical information into business terms for non-technical stakeholders.
  • Ability to work under pressure and manage multiple projects and deadlines efficiently.
  • Meticulous attention to detail and a commitment to data accuracy and quality.
  • A growth mindset and eagerness to stay updated with new technologies and industry best practices.
  • Expertise in data engineering, data management and data integration tools and technology stack
  • Expertise in data modeling, database design, and data integration.
  • Proficiency in SQL, Python, and other relevant programming languages.
  • Displays an understanding of risk and risk ownership by being able to demonstrate adherence to policies and procedures.
About Us:What's in it for you:First, we strive to make our team members feel genuinely rewarded. You'll have:
  • Mental health coverage and resources
  • Customizable health benefits, as well as topped-up parental leave
  • Performance-based compensation, employee banking advantages and group RRSP matching
  • Vacation time and flexible work arrangements to support your lifestyle
We are committed to providing a fair, equitable, and competitive rewards package that reflects the value an individual brings to our organization. The compensation mentioned in this job posting should serve as a guide. The total cash compensation earned may vary based on a variety of factors including bonuses and/or incentives, an individual's skills and experience, and may correlate with performance in the role.We also provide and encourage opportunities for our employees to make a meaningful impact. After all, as a credit union we're powered by giving back-in big ways and through small gestures. That's why we offer employees paid time off to volunteer, partner with thousands of local charities, build long-lasting relationships that help our members get ahead and commit to environmental, social and governance (ESG) practices.By joining our team, you'll be able to elevate your potential. Wherever your own purpose leads, we're here to support you with award-winning in-house training programs, access to LinkedIn Learning, and reimbursement for external courses to help you get ahead.Take the next step in your career as part of our team. Apply for this opportunity!Candidates, please note: if you are being considered for this role, you will be required to complete a background check, such as employment verification, credit check and criminal record check.Diversity, Equity, Inclusion & BelongingAt First West Credit Union, we embrace diversity regardless of gender identity or expression, sexual orientation, religion, race, ethnicity, age, diverse ability, and any aspect that makes someone unique. Inclusion is woven through our organization, from our employee-led network groups, hiring practices and education programs that address barriers and continually grow our equitable, diverse and inclusive culture.We encourage people who are from equity-deserving groups to apply for a career with us, including women or non-binary people, persons with diverse abilities, Black, Indigenous Peoples, People of Colour and members of 2SLGBTQIA+ communities.If an accommodation would help you during the process of applying or interviewing for a career with us, please let us know how we can assist you, whether it's preparing materials in an alternate format, booking an accessible meeting room or other arrangement.Your individuality is welcome here.About UsWe're a financial cooperative that does things differently. We provide time-tested advice that helps our members feel optimistic about their future, and we offer comprehensive banking solutions that enable people to confidently reach their goals. With the financial strength and extended branch network of a large financial institution, we maintain local connections to our communities and take a unique grassroots approach to service. Our more than 250,000 members and approximately 1,250 employees operate from 45 branches throughout the province of BC, under the Envision Financial, Valley First, Island Savings and Enderby & District Financial brands. Visit firstwestcu.ca for more information on First West Credit Union.Please know we appreciate your interest in us but only candidates selected for an interview will be contacted.

First West Credit Union