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.