Previous Job
Previous
Finance Data Integration Developer
Ref No.: 17-00024
Location: New York, New York
The Data Integration Developer will work as a hands-on developer working directly on data warehouse and back office data management systems. Reporting directly to the Enterprise Data Architect, the successful candidate will be comfortable working directly with front, middle and back office teams to deliver back end data centric solutions. He or she will also be expected to work collaboratively with others in IT to realize the full life cycle of system development projects: from requirements gathering through white-boarding, application design, system design, data modeling, ETL/application coding, data delivery, support and enhancements.

DETAILED DESCRIPTION:


The successful candidate will have strong experience in the design and development of new data integration capabilities, n-tier front- and back-office applications for financial services companies, such as asset managers, hedge funds and/or broker/dealers. Candidates with strong technology qualifications outside of financial services will be considered, but we have a strong bias toward hiring someone with a proven track record in finance. Working with the Sr. Architects and other team members, he or she will work to translate logical designs into physical databases, optimize existing databases, and to understand/manage the flow of data from data sources to our clients various end user systems and reports.
In particular, he or she will be involved in onboarding new sources of data into our new data warehouse system as well as work across the organization to migrate existing processes onto the data warehouse system.

This role must lead by example and work collaboratively to:
  • Data Architecture Planning
    • Design and develop systems with a constant eye toward our clients long-term data architecture vision, utilizing agreed upon standards
    • Participate in the high level design of processes for governing the identification, collection, and use of firm metadata; take steps to assure metadata accuracy and validity
    • Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement
    • Work with Architects to analyze data sources and determine process/approach for managing them in a central data warehouse and data marts
  • Design and Development
    • Coordinate with the all business units to understand reporting requirements, translating them into Database design
    • Design and develop ETL to load the data warehouse and data marts, utilizing reusable design components
    • Tune ETL code for efficiency
    • Support custom metadata driven ETL solution for onboarding data sources
    • Map data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
    • Analyze data sources, cleaning data as necessary
    • Coordinate with BI and database team to support multiple data delivery methods based on use cases (i.e. BI tools, Stored Procedures, Views, Web Service calls)
    • Tune queries to meet SLA requirements
    • Review and recommend any necessary changes in code written by other database developers
    • Work with Investment team to integrate their custom models with data stored in the data warehouse and data marts
  • Testing/Implementation
    • Perform unit and integration testing of code to meet requirements and make corrective changes as necessary
    • Coordinate with IT Operations team to implement code changes/new systems, including providing proper documentation and procedures
    • Manage releases/versions of code
    • Train production system support personnel on maintenance procedures and troubleshooting methods
Some of the projects/systems that this role will be working with include, but are not limited to:
  • Data Warehouse System
  • Market Data System
  • Manager Selection System
  • Research and Trading System
  • Quant models

Technical tools and platforms currently used or planned for use include:
  • SQL Server 2008R2/2012/2016
  • Talend Integration Studio
  • Embarcadero ER/Studio
  • Hadoop Ecosystem
  • Active Batch

Primary responsibilities estimated percentage allocation:
  • 10% Technology leadership: design, mentoring, requirements gathering, data architecture planning
  • 20% Relationship building: requirements gathering, brainstorming with end users
  • 70% Heads down development
KNOWLEDGE AND SKILLS REQUIRED:
  • Business Knowledge/Quantitative Skills
    • Experience working with financial data warehouse systems including Master Data Repositories, Performance Analytics, and data warehousing systems
    • Working knowledge of financial instruments including fixed income, equities, and currency derivatives; experience with alternative investments preferable
    • Ability to understand complex financial analytics; quantitative analysis skills
  • Communications
    • Excellent interpersonal and communication skills are essential to interact with all levels of management, end users, quant developers, and IT team members
    • Proven technical writing skills, the ability to summarize and clearly articulate complex issues/technical documents utilizing the Microsoft Office suite
  • IT Knowledge/Experience
    • Demonstrated experience working on data warehouse systems
    • Strong knowledge of ETL processes/design as well as data modeling, both relational and dimensional
    • Strong MS SQL Server development skills; experience writing T-SQL scripts, dynamic SQL, complex stored procedures and functions
    • Extensive experience in ETL design/development, SSIS, Talend and Stored Procedures or other related ETL tools
    • Understanding of business intelligence tools , dimensional modeling
    • Data handling across different data sources – SQL Server, Redis, Excel, etc.
    • Strong knowledge of SQL Server 2008R2/2012/2016 Database Engine
    • Experience using database design tool tools such as ERStudio
    • Optional, but preferred: Strong understanding of metadata and data quality concepts; experience working with a metadata repository
    • Optional, but preferred: Application development any of Python, .NET, Java
  • Business Analysis
    • Ability to understand core business processes, analyze business problems and translate business needs into detailed technical requirements
    • Demonstrated ability to partner with internal clients (business groups) to gather detailed requirements in order to plan, develop, install, test, and maintain high-quality, effective data driven systems
  • Leadership
    • Ability to build supportive relationships and commitment of both end user and IT team members to team goals and objectives in fast-paced environments
  • Decision Making/Problem Solving
    • Demonstrated clear, analytical thinking and sound judgment
    • Ability and desire to make timely decisions based on analysis
    • Demonstrated strong problem solving capabilities
  • Initiative and Teamwork
    • Ability to direct oneself with minimal supervision and work together with multiple stakeholders and IT team members to successfully deliver projects
    • Desire to work in a relatively level working environment where reporting lines are not necessarily hierarchical
    • Willingness to take responsibility for getting things done
    • Ability to multi-task
    • Strong work ethic
BACKGROUND AND TRAINING:
  • A minimum of a Bachelors degree in Management Information Systems, Computer Science or other related discipline (although strong experience with a less directly related degree will be considered)
  • A minimum of 5 years relevant technical experience as a Database/ETL Developer or related position. A minimum of 3 years' experience working in the finance industry (alternative asset management industry is ideal).
  • Formal problem solving and/or analytical training/experience a plus, as is experience working with management consultants