Data Engineer

The Data Engineer is responsible for designing, developing, and maintaining critical data infrastructure, including data warehouse solutions, ETL processes, and data governance practices. This role involves optimizing and managing data pipelines to ensure scalability, efficiency, and adherence to CNB's data governance and security standards. As a subject matter expert (SME) in data engineering, the position contributes to the modernization of data warehouse operations and the implementation of data quality initiatives. The role requires collaboration with cross-functional teams, including data analysts, data governance, and other stakeholders, to ensure data solutions align with organizational needs and strategic objectives. Additionally, the Data Engineer oversees data processing workflows, resolves complex data issues, and manages data-related projects in both on-prem and Azure hybrid ecosystems.

Principal Duties & Responsibilities:

Lead the design and development of data warehouse solutions that drive advanced reporting and analytics. Ensure data architectures meet the evolving needs of the organization, with a focus on scalability, reliability, and performance.
• Spearhead the creation, implementation, and optimization of ETL processes to efficiently extract, transform, and load data from various sources into centralized data repositories, leveraging both on-premises and cloud (Azure) environments.
• Drive the modernization of data warehouse operations by adopting emerging technologies and industry best practices. Independently lead the integration of new tools and systems to enhance data processing, storage, and access capabilities.
• Take ownership of data quality initiatives by designing, implementing, and managing processes that ensure data integrity, accuracy, and reliability. Proactively monitor and resolve data issues, refining workflows to maintain high-quality data assets.
• Establish systems for continuous monitoring and quality assurance of data pipelines, ensuring production data is consistently accurate, reliable, and accessible for key business operations and stakeholders.
• Evaluate and manage the end-to-end lifecycle of data assets, ensuring they are effectively maintained, secured, and aligned with broader enterprise data management strategies.
• Ensure compliance with data governance, security, and privacy regulations, proactively leading efforts to mitigate risks and ensure that data processing adheres to organizational standards and legal requirements.
• Drive continuous improvement initiatives related to data infrastructure and analytics capabilities, independently identifying opportunities to optimize processes, reduce costs, and enhance overall business growth.
• Provide expert-level data analysis and troubleshooting to resolve complex issues with data workflows, ensuring data quality, and supporting data-driven decision-making across the organization.
• Lead the implementation of data management processes to ensure compliance with security and privacy policies, addressing any issues that arise and maintaining a strong data governance framework.
• Collaborate with cross-functional teams to manage dependencies, ensuring that data assets align with business objectives and are utilized securely and effectively to meet organizational goals.
• Serve as a subject matter expert (SME) in data engineering, offering strategic direction on optimizing data workflows for both performance and cost-efficiency. Contribute to the development and refinement of enterprise-wide data strategies and policies.

• Bachelor's Degree in Computer Science, Information Systems, Data Management, or a related field (or equivalent experience).

• Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
• Please view Equal Employment Opportunity Posters provided by OFCCP here.
• The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
• Reasonable accommodation may be made to assist individuals with disabilities to complete the online application process. Please contact our Human Resources Department at 305-577-7680 or by e-mail at employment@citynational.com.