- Collaborate with team members and department heads to ensure functional and business specifications are converted into flexible, scalable, and maintainable solution designs
- Develop and implement software to support internal data initiatives and system integration strategies that enhance business processes and manage business intelligence.
- Design and manage data models for applications, metadata tables, and views, ensuring system, data and reporting standards, security, performance, robustness and reliability
- Implement, maintain and support Markit EDM enterprise data management solution
- Develop data quality metrics that identify gaps and ensure compliance with Investment and enterprise-wide standards
- Active role in quality assurance (QA) and user acceptance testing (UAT) for data and solution initiatives by providing test plans and testing support, attending team meetings, and documentation.
Qualifications:
- Bachelor's Degree
- Ability to write complex SQL Code on MS SQL Server
- Experience building ETL pipelines for in-bound and out-bound system feeds (e.g., FactSet, IDC, Refinitiv, etc.)
- Experience with Enterprise Data Management Tools (e.g. Markit EDM) is highly preferred
- Experience with BI Systems (e.g. Power BI, Tableau, SSRS)
- Strong knowledge of Excel
- Knowledge of C# and .NET platform
- Relational Database Design and Development
- Data analyses and refactoring
- Strong analytical and communication skills
Competencies:
- Diligence & Attention to Detail-demonstrate accuracy and thoroughness, monitor own work to ensure quality control of all work product
- Planning & Organizing-prioritize and plan work activities proactively and independently, use time efficiently and maintain high level of organization
- Interpersonal Skills & Teamwork-a collaborative team player who is highly professional, respectful and honest, open to ideas and exhibits willingness to try new things and roll up their sleeves with the team to do what it takes to get the job done well.
- Communication-speak, write and present clearly and professionally, and create polished and complete documents, ensures top quality work product, present data effectively
- Dependability-consistently a productive and positive team member, respond to direction and developmental feedback and solicit feedback to improve performance
- Initiative -take ownership and accountability, seek out and/or accept additional responsibilities, able to works towards goals independently with little need for supervision, and motivated
- Results Oriented - understand and analyze work product, apply critical thinking to ensure accuracy of deliverables
- Problem Solving- ability to identify the cause and effects of issues and analyze existing and external information to come up with appropriate solutions