Talent.com
Enterprise Data Tech Services Data Engineer

Enterprise Data Tech Services Data Engineer

Columbia BankFair Lawn, NJ, US
5 days ago
Job type
  • Full-time
Job description

Job Description

Job Description

Summary :

The Enterprise Data Technology Services Data Engineer assists in the design, implementation, and maintenance of enterprise data platforms, infrastructure, and integration solutions. They contribute to initiatives involving data warehouses, data lakes, reporting environments, data pipelines, and emerging technologies such as AI and machine learning. Their role includes supporting the architecture of frameworks to manage data inflows and outflows, aiding in the onboarding of third-party integrated data warehouses, and collaborating with Data Quality and BI teams to enhance the accuracy, consistency, and usability of enterprise data. They help create curated, pre-aggregated datasets to enable persistent analytics and insights for reporting and dashboards, minimizing runtime processing. Throughout the development process, they document and catalog their work in alignment with the Software Development Life Cycle, while demonstrating strong teamwork, organization, communication, and time management skills. The ideal candidate is adaptable, accountable, and capable of managing multiple priorities while working effectively with development teams, technology groups, and key stakeholders.

Job Responsibilities :

Data Platform Engineering

  • Assist in building and maintaining enterprise data assets across data lakes, warehouses, and reporting environments.
  • Ensure platforms are scalable, secure, and performant through collaboration with infrastructure and architecture teams.
  • Support the development, documentation, validation, and deployment of curated, pre-aggregated datasets to improve dashboard and reporting efficiency.
  • Help maintain and optimize SSIS packages for reliable and efficient data ingestion and transformation.
  • Create and manage access to datasets and content packs so business users can execute self-service reporting against these datasets.
  • Work with users and team members at all levels for performance improvement and suggestions.
  • Develop and maintain effective and productive working relationships with other departments and senior managers.
  • Troubleshoot data issues to identify root causes and fixes.
  • Perform validation to ensure the data's accuracy, quality, and completeness using SQL Server Management Studio, Oracle Developer Studio, Excel, Etc.
  • Remain current in emerging technology trends, primarily related to the financial services industry.
  • Identify, communicate, and resolve data quality and data reconciliation issues.

Data Integration and Pipeline

  • Help architect and implement data inflow and outflow processes from various internal and external sources.
  • Contribute to the development and optimization of ETL / ELT pipelines for structured and unstructured data.
  • Collaborate on data transformation strategies to support analytics and operational use cases.
  • Create simple SSIS packages to import data from Access, Excel, XML, OLE DB Source, and flat files to import and transform data between databases and external data sources.
  • Use SQL Server Integration Services (SSIS) to load and transform flat files and other structured data sources into enterprise data platforms.
  • Have working knowledge to modify and create tables, views, stored procedures, and user-defined functions to update / insert data.
  • Database tables and view creation (DDL, DML, DQL), database tuning, SQL tuning, and performance planning.
  • Transform raw data by writing complex SELECT (DQL) statements in SQL with JOINs to update data sets through insert, update, and delete statements (DDL & DML).
  • Cloud and Infrastructure Management

  • Support the management of cloud-based data platforms, including third-party integrated data warehouse solutions.
  • Assist in provisioning, monitoring, and maintaining cloud infrastructure for data services.
  • Participate in efforts to modernize legacy systems and migrate workloads to cloud environments.
  • Participate in evaluating and implementing emerging technologies such as data mesh, AI / ML platforms, and real-time analytics.
  • Data Governance & Quality Enablement

  • Collaborate with the Data Governance team to enforce data standards and policies.
  • Assist in implementing tools for data lineage, cataloging, and quality monitoring.
  • Provide infrastructure support to Data Quality and BI teams to improve data accuracy and consistency.
  • Self-Service Enablement

  • Help build semantic layers, curated datasets, and data marts to empower business users with self-service analytics.
  • Support the development of frameworks and tools that enable secure and scalable data access.
  • Collaborate with organizational stakeholders to understand business requirements, needs, gaps, and issues to design and create relevant curated datasets and data marts.
  • Contribute to modernization efforts by supporting the transition from legacy systems to modern data architectures.
  • Help stakeholders define business terms and descriptions to catalog key business terms and calculations to add to the Enterprise Data Office's Data Handbook.
  • General Responsibilities

  • Understand business requirements and convert them into technical specifications for datasets, data marts, or instructions to communicate with third parties.
  • Follow and conform to the Software Development Life Cycle, such as requirements gathering, development, documentation, and deployment to various environments.
  • Use the workflow management and prioritization tool to catalog status, stakeholder approvals, and communication of current deliverables.
  • Create and maintain business requirement documents and gain stakeholder approvals.
  • Maintain version control by tracking changes for reports and dashboards.
  • Job Requirements :

  • Degree or technical accreditation or relevant self-paced training courses.
  • Minimum 2 years’ experience.
  • Microsoft SQL Server, SSIS, SQL Developer (Oracle and Microsoft), Mulesoft.
  • Proficient in SQL Programming (DDL, DML) and API Configuration.
  • Skilled in stakeholder management and gathering user requirements.
  • Ability to communicate with internal and external stakeholders.
  • Familiarity with Relational Database Models.
  • Preferred

  • Financial Services and Banking Background.
  • Columbia Bank offers the following benefits :

  • Medical, Dental, Vision and Rx which are contributory.
  • Bonus programs.
  • Employee Stock Option Program (ESOP).
  • Life Insurance, Long Term Disability and Accidental Death and Dismemberment (LTD&AD&D).
  • Paid Time Off (PTO) which includes Personal and Vacation Time.
  • Paid Sick Time.
  • Bank Holidays.
  • Employees may participate in the 401k program.
  • Schedule :

    This role is eligible for a hybrid schedule; 3 days in the office and 2 days' work from home based on business need.

    Columbia Bank and its affiliates is an Equal Opportunity Employer, including individuals with disabilities and veterans.

    Create a job alert for this search

    Data Engineer • Fair Lawn, NJ, US

    Related jobs
    • Promoted
    Data Engineer Manager

    Data Engineer Manager

    WavestoneNew York, NY, US
    Full-time
    Be part of a global consulting powerhouse, partnering with clients on their most critical strategic transformations.Energetic, solution-driven experts who focus as much on people as on performance ...Show moreLast updated: 7 days ago
    eCom Data Engineer Specialist

    eCom Data Engineer Specialist

    PepsiCoUSA, New York, Purchase
    Full-time
    PepsiCo operates in an environment undergoing immense and rapid change.Big data and digital technologies are driving business transformation that is unlocking new capabilities and business innovati...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer

    Data Engineer

    Zone IT SolutionsNew York, NY, US
    Permanent
    We are actively looking for Data Engineer for a permanent position.This exciting opportunity is with a well-established global IT service provider known for its excellence in the industry.Designing...Show moreLast updated: 25 days ago
    • Promoted
    • New!
    Data Tech Support Engineer

    Data Tech Support Engineer

    IPC Systems, Inc.New York, NY, United States
    Full-time
    IPC is a global provider of mission-critical network services and trading communication technology to the financial markets community. With complete focus on this sector and over 40 years of experti...Show moreLast updated: 2 hours ago
    • Promoted
    • New!
    C++ Market Data Engineer (USA)

    C++ Market Data Engineer (USA)

    Trexquant InvestmentStamford, CT, United States
    Full-time
    Trexquant is a growing systematic fund at the forefront of quantitative finance, with a core team of highly accomplished researchers and engineers. To keep pace with our expanding global trading ope...Show moreLast updated: 2 hours ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Tiger AnalyticsJersey City, NJ, US
    Full-time
    Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several F...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer

    Data Engineer

    Interactive BrokersGreenwich, CT, US
    Full-time
    Interactive Brokers Group, Inc.Nasdaq : IBKR) is a global financial services company headquartered in Greenwich, CT, USA, with offices in over 15 countries. We have been at the forefront of financial...Show moreLast updated: 30+ days ago
    • Promoted
    Lead Data Engineer

    Lead Data Engineer

    Capital OneNew York City, NY, United States
    Full-time +1
    Lead Data Engineer Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery envi...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Integration Data Engineer

    Integration Data Engineer

    Mizuho Bank LtdIselin, NJ, United States
    Full-time
    Join Mizuho as an Integration Data Engineer!.We are seeking an Integration Data Engineer with a background in SQL and data warehousing for enterprise level systems. The ideal candidate is comfortabl...Show moreLast updated: 2 hours ago
    • Promoted
    Data Engineer

    Data Engineer

    Palantir TechnologiesNew York, NY, US
    Full-time
    Palantir builds the world’s leading software for data-driven decisions and operations.By bringing the right data to the people who need it, our platforms empower our partners to develop lifes...Show moreLast updated: 24 days ago
    • Promoted
    Engineer, Data & Technology

    Engineer, Data & Technology

    Crossmedia IncNew York, NY, US
    Permanent
    Crossmedia is the global media independent.We're committed to doing media and business the right way, guided by the principles of TRUST, REASON and the pursuit of HAPPINESS.Crossmedia US was fo...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Databricks Engineers

    Senior Databricks Engineers

    InterSourcesIselin, NJ, United States
    Full-time
    This individual will have great communication.Someone who has led and executed deep enterprise level solutioning in conversation with CTO / MD level leadership. Should be able to be consultative / a...Show moreLast updated: 7 days ago
    • Promoted
    Data Engineer

    Data Engineer

    WhatnotNew York, NY, US
    Full-time
    Join the Future of Commerce with Whatnot!.Whatnot is the largest live shopping platform in North America and Europe to buy, sell, and discover the things you love. We’re re-defining e-commerce...Show moreLast updated: 19 days ago
    • Promoted
    Data Engineer

    Data Engineer

    Innovative Rocket Technologies Inc.New Hyde Park, NY, US
    Full-time
    Data is pivotal to our goal of frequent launch and rapid iteration.We’re recruiting a Data Engineer at iRocket to build pipelines, analytics, and tools that support propulsion test, launch op...Show moreLast updated: 20 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Garner HealthNew York, NY, US
    Full-time
    Healthcare quality is declining and soaring costs are crushing American families and businesses.At Garner, we've developed a revolutionary approach to evaluating doctor performance and a unique...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Lead Data Engineer

    Senior Lead Data Engineer

    Capital OneNew York City, NY, United States
    Full-time +1
    Senior Lead Data Engineer Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delive...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Engineer - Data Platforms

    Senior Engineer - Data Platforms

    CoreWeaveLivingston, NJ, US
    Permanent
    CoreWeave is The Essential Cloud for AI™.Built for pioneers by pioneers, CoreWeave delivers a platform of technology, tools, and teams that enables innovators to build and scale AI with confi...Show moreLast updated: 30+ days ago
    Databricks & Azure Data Platform Principal Engineer

    Databricks & Azure Data Platform Principal Engineer

    Axiom Software Solutions LimitedJersey City, NJ, US
    Full-time
    Quick Apply
    A senior technical expert responsible for designing, building, and optimizing data solutions using Databricks and Azure Data technologies. This principal engineer oversees the architecture, integrat...Show moreLast updated: 30+ days ago