Enterprise Data Tech Services Data Engineer

Columbia Bank • Fair Lawn, NJ

51d • Hybrid

About The Position

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.

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.

Nice To Haves

• Financial Services and Banking Background.

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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed
• Number of Employees: 1,001-5,000 employees