Enterprise Data Tech Services Data Engineer

Enterprise Data Tech Services Data Engineer

Join to apply for the Enterprise Data Tech Services Data Engineer role at Columbia Bank New Jersey.

This range is provided by Columbia Bank New Jersey. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$80,808.00/yr - $/yr

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.

• 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 optimise 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.

• Help architect and implement data inflow and outflow processes from various internal and external sources.
• Contribute to the development and optimisation 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).

• 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 modernise legacy systems and migrate workloads to cloud environments.
• Partici…