Data Engineer II

Overview

This is a remote role that may only be hired in the following locations: North Carolina, Georgia, and Arizona.

Responsible for designing, building, and maintaining data platform that supports data integrations for Enterprise Data Warehouse, Operational Data Store or Data Marts etc. with appropriate data access, data security, data privacy and data governance. Establish enterprise-scale data integration procedures, data pipelines and frameworks across the data development life cycle. Suggest and implement appropriate technologies to deliver resilient, scalable, and future-proof data solutions. Create high performing data ingestion pipelines. Create scheduled as well as trigger-based ingestion patterns using scheduling tools. Create performance optimized DDLs for any row-based or columnar databases. Conduct performance tuning of complex data pipelines and SQL queries. Perform impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions. Enhance data processing systems and procedures through system analysis, python coding, testing, and other activities that facilitate technical business objectives. Oversee data deliverables and coordinate design reviews and release management activities. Estimate and provide timelines for project activities. Identify, document, and communicate technical risks, issues and alternative solutions discovered during project. Drive automation, identify inefficiencies, optimize processes and data flows, and recommend improvements. Use agile engineering practices and various data development technologies to rapidly develop and implement efficient data products. Collaborate with Product Owners to understand PI goals, PI planning, requirement clarification, and delivery coordination. Provide technical support for production incidents and failures. This is a remote role that may be hired in the States of North Carolina, Georgia and Arizona.

Qualifications

Position requires a Bachelor's degree in Computer Science, Information Science, or a related field plus five (5) years of experience in the job offered or five (5) years of experience as a Systems Engineer, Business Intelligence Engineer, ETL Developer, or related occupation. Or a Master's degree in Computer Science, Information Science, or a related field plus three (3) years of experience in the job offered or three (3) years as a Systems Engineer, Business Intelligence Engineer, ETL Developer, or related occupation.

Requires experience writing and optimizing using SQL queries in a business environment with large datasets. Requires experience with big data systems with distributed storage and serverless compute technologies (AWS or Hadoop). Requires programming proficiency in modern programming language, Python or PySpark. Requires experience designing data schema. Requires experience operating internal data warehouses and SQL/NoSQL database systems. Requires experience with traditional ETL, and cloud based ETL tools, Informatica Intelligent Cloud Services or Streamsets. Requires experience with scheduling tools (Control-M, Redwood or Autosys). Requires experience with reporting tools (Tableau or MicroStrategy). Requires experience with traditional and cloud based databases (Oracle, Sqlserver, Teradata and Hive). Requires experience with Tortoise SVN or similar code repository system. Requires knowledge of System Life Cycle Development methodology (Waterfall and Agile). This is a remote role that may be hired in the States of North Carolina, Georgia and Arizona.

The base pay for this position is generally between $143,250 to $187,070 per year. Actual starting base pay will be determined based on skills, experience, location, and other non-discriminatory factors permitted by law. For some roles, total compensation may also include variable incentives, bonuses, benefits, and/or other awards as outlined in the offer of employment.

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits

This job posting is expected to remain active for 31 days from the initial posting date listed above. If it is necessary to extend this deadline, the posting will remain active as appropriate. Job postings may come down early due to business need or a high volume of applicants. #EJC and #LI-DNI