Previous Job
Sr. Data Integration Developer
Ref No.: 17-00022
Location: New York, New York
 The Sr. Data Integration Developer will work as a hands-on developer working directly on projects that improve the data integration capabilities, experience, efficiency and performance of our clients investment team. 

Reporting directly to the Front-Office Sr. Architect, the successful
candidate will be comfortable working directly with traders, portfolio managers, and risk managers to deliver front-to-back solutions while balancing the short- and long-term requirements of these users.  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. 


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 the development of systems that provide the Investment team data from our Accounting, Risk, Market Data systems as well as other external data feeds. This position will provide the opportunity to add new source data to our data warehouse and build data marts for the Investment team.
This role must lead by example and work collaboratively to:
  • Data Architecture Planning
    • Design and develop systems with a constant eye toward MIO's 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 Investment team to understand reporting requirements, translating them into Database design
    • Develop and maintain  Data Access Layer APIs expose via a webservices (eg. Python REST APIs)
    • Design and develop ETL to load the data warehouse and data marts, utilizing reusable design components  
    • Tune ETL code for efficiency
    • Support our clients 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
    • 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
Some of the projects/systems that this role will be working with include, but are not limited to:
  • Manager Selection System
  • Research and Trading System
  • Quant models
  • Data Warehouse System
  • Market Data System
Technical tools and platforms currently used or planned for use include:
  • SQL Server 2008R2/2012/2016
  • Data Access Layer using Python and/or C#
  • SQL Server Integration Services (SSIS) 2008R2
  • Talend Integration Studio
  • Embarcadero ER/Studio
  • Excel
  • Python
Primary responsibilities estimated percentage allocation:
  • 20% Technology leadership: design, mentoring, requirements gathering, data architecture planning
  • 20% Relationship building: requirements gathering, brainstorming with end users
  • 60% Heads down development
The successful candidate needs to hit the ground running, balancing very short term tactical needs and longer-term in-flight projects needed by our clients Front-Office team.  During the first six to twelve months the Senior Integration Developer - Investments will have learned enough about our clients business, processes and applications that he or she should have accomplished the following:
  • Taken ownership of some key front office projects, data integration needs, ETL logic, datamarts, and systems that are being built as part of our Investments IT roadmap to facilitate our investment selection, trading and/or risk management activities
  • Demonstrated a high level understanding of the various Investment business processes at our client and the accompanying data needs, as well as the business reasons behind the processes.
  • Managed a small team of in-house and outsource developers, taking responsibility for their productivity and code quality; as well as personally made hands-on contributions to the progress of that project portfolio
  • Forged solid relationships with key partners in the front office and developed a vocabulary that demonstrates a strong understanding of our products and services
  • Contributed to the broader client IT conversation, considering how our data architecture, data warehouse, data access layer, systems architecture and technology choices need to evolve to provide the best experience to our decision makers
  • 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
    • Experience using .Net framework and C# for ETL processes
    • Experience using conventional programming languages (Python/C#) as for programs for data access layer
    • 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
    • Strong leadership skills
    • Ability to build supportive relationships and commitment of both end user and IT team members to team goals and objectives in fast-paced environments
    • Experience in influencing user groups as a thought leader with respect to processes and systems
  • 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
  • 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 10 years relevant technical experience as a Database/ETL Developer or related position.  A minimum of 7 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
  • CFA or FRM a plus