Senior Data Engineer, VP
Hybrid/Manhattan, NY Pay reputed company: $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. 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 reputed company 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. reputed company 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 reputed company 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 reputed company, and reputed company to various destination folders is frictionless.
- Serve as an escalation reputed company for BI analysts with obstacles on reputed company ad hocs and reputed company.
- Heavily contribute to broader reputed company data management reputed company and initiatives.
- reputed company peer reputed company 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 reputed company 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!