Talent.com
Data Engineer II
Data Engineer IISchoolsFirst Federal Credit Union • Tustin, CA
[error_messages.no_longer_accepting]
Data Engineer II

Data Engineer II

SchoolsFirst Federal Credit Union • Tustin, CA
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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
  • [job_alerts.create_a_job]

    Data Engineer Ii • Tustin, CA

    [internal_linking.similar_jobs]
    Associate Data Architect II

    Associate Data Architect II

    Axelon Services Corporation • Aliso Viejo, CA, US
    [job_card.full_time]
    Title : ETL Developer / Data Integration Professional (Hybrid).Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.Pe...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Integration Engineer

    Integration Engineer

    Emerald Services • San Juan Capistrano, CA, United States
    [job_card.full_time]
    We are seeking a highly motivated and technically proficient.This role focuses on building and maintaining robust, scalable integrations between internal systems, third-party APIs, and Databricks.Y...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Engineer II, R&D

    Engineer II, R&D

    Edwards Lifesciences • Irvine, CA, United States
    [job_card.full_time]
    Innovation starts from the heart.At Edwards, we put patients first.We invest a significant proportion of our revenue towards research and development to drive and develop groundbreaking medical inn...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data / AI Engineer

    Senior Data / AI Engineer

    Mantek Solutions • Irvine, CA, United States
    [job_card.full_time] +1
    [filters_job_card.quick_apply]
    Senior Data / AI Engineer Remote 6 months Contract to Hire Those authorized to work in the U.We are not able to sponsor at this time.Our clien...[show_more]
    [last_updated.last_updated_30]
    Systems Engineer II or III

    Systems Engineer II or III

    Iris Technology • Irvine, CA, United States
    [job_card.full_time]
    Position Title : Systems Engineer.Reports To : Director of Engineering.At Iris Technology, we strive to provide innovative solutions and an agile responsiveness to customers from a broad range of ind...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Big Data Engineer

    Senior Big Data Engineer

    TP-Link Systems Inc. • Irvine, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Headquartered in the United States,.The company is committed to delivering innovative products that enhance people’s lives through faster, more reliable connectivity. With a commitment to excellence...[show_more]
    [last_updated.last_updated_30]
    Engineer II, R&D

    Engineer II, R&D

    MicroVention • Aliso Viejo, CA, United States
    [job_card.full_time]
    Support development of medical device products with work including writing or verifying specifications; designing new products and fixtures. testing processes and equipment; and specifying raw mate...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    R&D Engineer III

    R&D Engineer III

    Kasmo Global • Irvine, CA, United States
    [job_card.full_time]
    Employment Type : Contract / Onsite.Design and development of combination products and medical devices, ensuring compliance with industry standards and regulations. Apply knowledge of system engineeri...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Engineer II

    Data Engineer II

    Playstation Global • Aliso Viejo, California, United States
    [job_card.full_time]
    PlayStation isn’t just the Best Place to Play — it’s also the Best Place to Work.Today, we’re recognized as a global leader in entertainment producing The PlayStation family of products and service...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Infrastructure Engineer

    Data Infrastructure Engineer

    Heygen • Lake Forest, California, United States
    [job_card.full_time]
    At HeyGen, our mission is to make visual storytelling accessible to all.Over the last decade, visual content has become the preferred method of information creation, consumption, and retention.But ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Big Data Engineer

    Senior Big Data Engineer

    TP-Link North America, Inc. • Irvine, CA, United States
    [job_card.full_time]
    Headquartered in the United States, TP-Link Systems Inc.The company is committed to delivering innovative products that enhance people’s lives through faster, more reliable connectivity.With a comm...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Cloud Data & AI Engineer

    Cloud Data & AI Engineer

    OSI Digital • Irvine, CA, United States
    [job_card.full_time]
    Job Title : Cloud Data & AI Engineer.At OSI Digital Inc, we accelerate our client’s digital transformation journey by delivering modern data solutions, enabling them to unlock the full potential of ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Engineer II

    Data Engineer II

    VirtualVocations • Ontario, California, United States
    [job_card.full_time]
    A company is looking for a Data Engineer II (Data Stage).Key Responsibilities Lead system enhancement efforts to improve department systems, processes, and applications Provide technical support...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Associate Data Architect II

    Associate Data Architect II

    Compunnel • Aliso Viejo, CA, United States
    [job_card.full_time]
    The Data Engineering Associate III is responsible for delivering high-quality data solutions across the Microsoft databases technical stack (mandatory). This role focuses on building and optimizing ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Staff Engineer I - Software Engineer, Data Services

    Staff Engineer I - Software Engineer, Data Services

    Western Alliance Bank • Irvine, CA, United States
    [job_card.full_time]
    Staff Engineer I - Software Engineer, Data Services.Come join the AmeriHome's team, a Western Alliance Bank company, as a Staff Engineer I of the Data Services team. We're building a cutting-edge pl...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Principal Data Engineer

    Principal Data Engineer

    Americor • Irvine, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Americor is a leading provider of debt relief solutions for people of all backgrounds.We offer various services to help our clients achieve financial freedom, including debt consolidation loans, de...[show_more]
    [last_updated.last_updated_30]
    Senior Engineer V

    Senior Engineer V

    Tekwissen • Pomona, CA, United States
    [job_card.temporary]
    TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients worldwide. Job Type : Temporary Assignment.Management an...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Engineer II

    Data Engineer II

    Glidewell Dental • Irvine, California, United States
    [job_card.full_time]
    Creates and debugs ETL / ELT packages using SQL Server Integration Services (SSIS), Pentaho, or other open-source programs. Creates, debugs, and optimizes stored procedures, views, and functions.Colla...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]