Enterprise Data Tech Services Data Engineer
hace 2 días
Fair Lawn
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., • 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., • 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., • Collaborate with the Data Governance team to enforce data standards and policies., • Assist in implementing tools for data lineage, cataloging, and quality monitoring., • 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., • 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., • 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., • 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. 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.