Software Engineer II: Data Engineer

Experteer Overview In this role you will design, build, and operate trusted data pipelines and architectures to enable secure, scalable analytics for Consumer & Community Banking. You will work in an agile team to deliver high-quality data solutions across multiple domains, collaborating with cross-functional partners to advance the firm’s strategic data objectives. You will leverage AI-assisted development tools and cutting-edge tech to improve code quality, performance, and data insights, while upholding security and reliability. This is a hands-on role with a strong impact on data-driven decision making and software delivery at scale. Compensation / Benefits * Review controls to protect enterprise data * Design, develop, test, and troubleshoot data pipelines and architectures across domains * Produce secure, production-grade code and maintain data algorithms * Create architecture and design artifacts ensuring constraints are met * Analyze and visualize large, diverse data sets for continuous software improvement * Identify data patterns to drive improvements in code hygiene and system architecture * Contribute to software engineering communities of practice and adopt emerging technologies * Update logical/physical data models based on new use cases Tasks * Formal training or certification in Software Engineering plus 2+ years experience * Working understanding of NoSQL databases and advanced SQL * Experience with statistical data analysis to guide tool/pattern choices * ETL process/advanced concepts experience * Hands-on system design, development, testing, and operations * Experience with AWS; building data pipelines using Python and PySpark (Java as alternative) * Performance tuning to avoid bottlenecks * Unix scripting; data serialization formats (JSON, AVRO, Protobuf); big-data formats (Parquet, Iceberg) and data modeling techniques (Dimensional, Data Vault, Kimball, Inmon); Agile, TDD/BDD, CI/CD * Experience with enterprise AI-assisted development tools and ensuring safe, effective outputs * Understanding of responsible AI use in engineering workflows * Proficiency with data processing methodologies (batch, micro-batching, streaming) Key requirements * comprehensive health care coverage * retirement savings plan * backup childcare * tuition reimbursement * mental health support * financial coaching

_ continuous software improvement * Identify data patterns to drive improvements in code hygiene and system architecture * Contribute to software engineering communities of practice and adopt emerging technologies * Update logical/physical data models based on new use cases Tasks * Formal training or certification in Software Engineering plus 2+ years experience * Working understanding of NoSQL databases and advanced SQL * Experience with statistical data analysis to guide tool/pattern choices * ETL process/advanced concepts experience * Hands-on system design, development, testing, and operations * Experience with AWS; building data pipelines using Python and PySpark (Java as alternative) * Performance tuning to avoid bottlenecks * Unix scripting; data serialization formats (JSON, AVRO, Protobuf); big-data formats (Parquet, Iceberg) and data modeling techniques (Dimensional, Data Vault, Kimball, Inmon); Agile, TDD/BDD, CI/CD * Experience with enterprise AI-assisted development tools and ensuring safe, effective outputs * Understanding of responsible AI use in engineering workflows * Proficiency with data processing methodologies (batch, micro-batching, streaming) Key requirements * comprehensive health care coverage * retirement savings plan * backup childcare * tuition reimbursement * mental health support * financial coaching