Data Engineer II

SchoolsFirst Federal Credit Union•Sacramento, CA

7d•Hybrid

About The Position

We’re always looking for diverse, talented, service-oriented people to join our exceptional team. Data Engineer II The pay range for this position is listed below. Our pay ranges are built to allow for candidates with various levels of skill and experience to be considered, as well as for room for growth and tenure achieved in a role over time. Typical new hire salary offers fall within the minimum to midpoint of a pay range for many candidates. Any offer extended to a candidate will be based upon their unique set of knowledge, skills, education, and experience as well as internal equity. Pay Range: $96,110.00 - $153,777.00 Scheduled Weekly Hours: 40 What You’ll Be Doing Designs, implements, and maintains moderately complex data pipelines. Responsibilities include maintenance of database dictionaries, database design, and data integration solutions. Define requirements based on independent analysis of applications of medium complexity and working with BSA’s and end users. Design architecture, database schemas and database systems of medium complexity. Develop department and process standards and best practices. Develop data integration and process requirements based on business process analysis. Create and maintain data models and data dictionaries. Identify hardware requirements and work with infrastructural resources for implementation and maintenance. Determine and forecast needs and allocate resources for upcoming projects. Design and develop complex multi-chain data integration processes. Review submitted database requests to ensure code quality. Coach application developers on best practices for SQL Development balancing performance and total cost of ownership. Provide essential data warehouse architecture, design, development and support. Provide on-call support as necessary on a rotating schedule. Additional Job Functions Performs other duties as assigned Complies with regulatory compliance and assigned training requirements including but not limited to BSA regulations corresponding to their specific job duties. Failure to do so may result in disciplinary and other employment related actions Qualifications Bachelor's Degree or equivalent years of experience required 5-7 years of experience in data engineering 7-10 years of experience with ETL/ELT and data integration tools Knowledge, Skills, and Abilities Comprehensive working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of non-relational database technologies. Intermediate in developing Extraction/Transformation/Loading processes for System Integration and Data Intermediate in SQL Server Integration Services, SQL 2012 and above, C# or Java, JavaScript, and Python Experience with Snowflake, Boomi, QLIK Replicate Functional knowledge of ERwin Data Modeling Suite Comprehensive knowledge in Restful and SOAP API creation and consumption Comprehensive knowledge of database design and development Understanding of TSQL and stored procedure development Strong analytical, problem solving and conceptual skills Proven and successful accomplishments of manipulating, processing and extracting value from large and disconnected datasets. Intermediate knowledge in TFS source control and experience with Azure DevOps Experienced in Information Technology Service Management: Data Quality ,Meta Data Management, Master Data Management, Agile Methodology, SCRUM SchoolsFirst FCU is committed to Diverse, Equitable, and Inclusive Hiring At SchoolsFirst FCU we are dedicated to building and growing a diverse, inclusive, and authentic Dream Team, so if you’re excited about a position or wanting to make a career change but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. Many skills are transferrable and you may be just the right candidate for the position, or for other roles we are working on. SchoolsFirst Federal Credit Union is committed to fostering, cultivating, and preserving a culture of diversity and inclusion. SchoolsFirst FCU is an equal opportunity employer and prohibits discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibits discrimination against all individuals based on their race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, political affiliation, or genetic information. This organization participates in E-Verify. We're passionate about living our mission of providing Members with World-Class Personal Service and financial security. There's a reason we love coming to work every day. We have the privilege of serving those who build the future: school employees, and the families who make their work possible. Our success is built on our relationships with each other, our Members and the community. We value teamwork and face-to-face interactions and believe we’re at our best when we’re collaborating in-person. We also know the flexibility to work remotely benefits the wellbeing of our team. View the work location information below on the job listing that interests you. 100% on-site, 0% remote. Including those serving Members in-person at our branches. Three days a week in the office and up to two days remote. Hybrid teams coordinate on-site days to collaborate in-person. Up to 100% remote. Select individual contributor roles may be given the option to work fully remote. Not finding the right fit? Let us know you're interested in a future opportunity below, or create an account by clicking 'Sign In' at the top of the page to set up email alerts as new job postings become available that meet your interest!

Requirements

Bachelor's Degree or equivalent years of experience required
5-7 years of experience in data engineering
7-10 years of experience with ETL/ELT and data integration tools
Comprehensive working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of non-relational database technologies.
Intermediate in developing Extraction/Transformation/Loading processes for System Integration and Data
Intermediate in SQL Server Integration Services, SQL 2012 and above, C# or Java, JavaScript, and Python
Experience with Snowflake, Boomi, QLIK Replicate
Functional knowledge of ERwin Data Modeling Suite
Comprehensive knowledge in Restful and SOAP API creation and consumption
Comprehensive knowledge of database design and development
Understanding of TSQL and stored procedure development
Strong analytical, problem solving and conceptual skills
Proven and successful accomplishments of manipulating, processing and extracting value from large and disconnected datasets.
Intermediate knowledge in TFS source control and experience with Azure DevOps
Experienced in Information Technology Service Management: Data Quality ,Meta Data Management, Master Data Management, Agile Methodology, SCRUM

Responsibilities

Designs, implements, and maintains moderately complex data pipelines.
Responsibilities include maintenance of database dictionaries, database design, and data integration solutions.
Define requirements based on independent analysis of applications of medium complexity and working with BSA’s and end users.
Design architecture, database schemas and database systems of medium complexity.
Develop department and process standards and best practices.
Develop data integration and process requirements based on business process analysis.
Create and maintain data models and data dictionaries.
Identify hardware requirements and work with infrastructural resources for implementation and maintenance.
Determine and forecast needs and allocate resources for upcoming projects.
Design and develop complex multi-chain data integration processes.
Review submitted database requests to ensure code quality.
Coach application developers on best practices for SQL Development balancing performance and total cost of ownership.
Provide essential data warehouse architecture, design, development and support.
Provide on-call support as necessary on a rotating schedule.
Performs other duties as assigned
Complies with regulatory compliance and assigned training requirements including but not limited to BSA regulations corresponding to their specific job duties. Failure to do so may result in disciplinary and other employment related actions