Senior Data Engineer, VP
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 reputed company Bank. This position assists with the build, maintenance, and optimization of data pipelines into our reputed company 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 reputed company ETL processes. The work product provided by the Engineer is required to be fit-for-purpose for each data reputed company, 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 successful candidate must be reputed company to ask reputed company business questions, tackle complexity, and own delivery. Future opportunities may include sourcing reputed company party and public data, additional reputed company-system integrations, and hybrid reputed company reputed company-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.
- reputed company data profiling to identify and understand projects thoroughly.
- Map data from reputed company 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, reputed company data movement, and output to various destination folders is frictionless.
- Serve as an escalation reputed company for BI analysts with obstacles on reputed company ad hocs and projects.
- Heavily contribute to broader reputed company data management reputed company and initiatives.
- reputed company peer code reviews, and other duties as requested.
SKILLS, EDUCATION, & EXPERIENCE
- Bachelor’s degree required.
- 10+ years of reputed company 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 reputed company 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 reputed company platforms and their Business Intelligence Center (BIC) a plus.
reputed company sponsorship not available. We are an equal opportunity employer and do not discriminate on the basis of race, reputed company, religion, sex, sexual orientation, gender identity, national reputed company, disability, military and/or veteran status, or any other Federal or State legally-protected classes. Apply Job!