Hybrid/Manhattan, NY Pay Range: $170,000 - $240,000 The Senior Data Engineer plays a key role in the design, development, and expansion of databases, data orchestrations, and business intelligence for Apple Bank. This position assists with the build, maintenance, and optimization of data pipelines into our Enterprise Data Warehouse (EDW) and creates extracts for vendors and partners. The Senior Engineer also develops stage tables, operational data store (ODS) databases and tables, data marts, and all ETL processes. The work product provided by the Engineer is required to be fit-for-pupose for each data source, repeatable, and automatable, which involves stored procedures, functions, data analyses, cleansing, validations, and reporting. The role collaborates closely with IT infrastructure colleagues, database administrators, business stakeholders, data operations teammates, project managers, vendors, and analysts embedded in our businesses. The sucessful candidate must be able to ask incisive business questions, tackle complexity, and own delivery. Future opportunities may include sourcing third party and public data, additional source-system integrations, and hybrid cloud proof-of-concepts. ESSENTIAL DUTIES & RESPONSIBILITIES Establish solution architecture, SQL Server databases, and schemas. Design and build corresponding SSIS ETLs, solving business needs and seizing opportunities. Perform data profiling to identify and understand projects thoroughly. Map data from source to repository. Build and automate data extracts for vendors and partners to specifications. Understand and coordinate the granting of permissions to service and proxy accounts to ensure inbound files, all data movement, and output to various destination folders is frictionless. Serve as an escalation point for BI analysts with obstacles on complex ad hocs and projects. Heavily contribute to broader enterprise data management decisions and initiatives. Perform peer code reviews, and other duties as requested. SKILLS, EDUCATION, & EXPERIENCE Bachelor’s degree required. 10 years of progressive experience. Proficiency in MS SQL Server, SSIS, Visual Studio, SSMS, and database administration. At least 6 years of experience as an ETL developer, specifically into MS SQL Server. 8 years overall experience in ETL design, implementation, and maintenance, including for full and incremental loads, and slowly changing dimensions. Some experience with cloud database platforms. Experience developing with C# and (desirable) Python. Experience combining and de-duping data sources. Domain knowledge and experience in banking services. Experience with FIS Global platforms and their Business Intelligence Center (BIC) a plus. Visa sponsorship not available. We are an equal opportunity employer and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, military and/or veteran status, or any other Federal or State legally-protected classes. Since 1863, Apple Bank has been a stable banking presence in New York City and its surrounding communities. We seek to put the best interests of our customers first and to manage our company prudently and responsibly. When you join the Apple Bank team, you’ll be working with a group of dedicated and talented professionals focused on delivery of an outstanding customer experience. For more than 160 years, Apple Bank has been invested in our customers and communities, striving always to put their best interests first. Along the way, our employees have been the key to our success. Whether you’re just beginning, continuing or changing your career, Apple Bank offers a range of career opportunities. We’ll support you in developing your potential to the fullest, while you contribute to our growth and success. Apple Bank’s employment policy is to provide equal opportunity to all persons. We have made a commitment to equal employment opportunity through a positive and continuing affirmative action program. No employee or applicant for employment will be discriminated against because of race, color, citizenship status, religion, sex, sexual orientation, creed, national origin, age, physical or mental disability, veteran status, political affiliation, domestic violence victim status, predisposing genetic characteristic, or any other Federal or State legally-protected classes. Apple Bank will make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodation would impose an undue hardship on the operation of our business. If you are interested in applying for an employment opportunity and feel you need a reasonable accommodation pursuant to the ADA, please contact us at talentacquisition@applebank.com. EEO is the Law poster: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf EEO is the Law Supplement: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf The Pay Transparency Notice: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_ English_formattedESQA508c.pdf Know Your Rights: https://www.dol.gov/sites/dolgov/files/OFCCP/regs/compliance/posters/pdf/22-088_EEOC_KnowYourRights.pdf