Enterprise Data Management Analyst

Conning & Company; Hartford (CT); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Retirement plan

Job summary

Conning & Company is seeking a data management professional to maintain enterprise data quality across security master data, corporate actions, valuations, and classifications. You will partner with Risk, Portfolio, and Operations teams to support data governance and integrity throughout the investment life cycle.

You will analyze SMF investment data, cleanse and enrich data, and collaborate with internal and external stakeholders to meet data requirements and ensure accurate reporting.

Qualifications

• Bachelor's degree in Business or a related field.
• Minimum 3 years of data management experience in finance/investment management preferred.
• Strong communication and organizational skills; detail-oriented and analytical.

Responsibilities

• Create, implement, and maintain master data management solutions.
• Analyze and reconcile investment data across sources and internal systems.
• Ensure data integrity and quality across enterprise data elements.

Skills

Data quality

Communication (verbal)

Communication (written)

Analytical thinking

Time management

Independent work

Team collaboration

Agile methodologies

Problem solving

Education

Bachelor's degree in Business or related field

Tools

Excel

Microsoft Teams

Microsoft SQL Query

Bloomberg data

Oracle SQL

Power BI

ETL tools

Job description

Conning is a leading global investment management firm with a long history of serving the insurance industry. We develop customized investment strategies that address our clients’ unique objectives, requirements and tolerance for risk. We develop solutions by leveraging Conning’s risk management tools and utilizing a highly disciplined investment process that relies on fundamental analysis.

Summary: Maintain data quality at an enterprise level for various market data elements including but not limited to security master, corporate actions, security valuations, asset classifications, and quality ratings for fixed income and equity securities. Work closely with both data providers and consumers to address issues and concerns regarding data accuracy, consistency, and completeness. The position also provides exposure to all aspects of the security life cycle, including but not limited to trading, new issue set up, credit and quality ratings, portfolio compliance, corporate actions, and pricing.

Essential Responsibilities:

• Create, implement, and maintain master data management solutions that enable users to optimize system capabilities.
• Analyze and research SMF investment data, reconciling data between various sources and internal systems.
• Apply knowledge of end-to-end data processes to analyze, cleanse, and enrich master data elements, ensuring data flows efficiently and consistently between users and stakeholders.
• Partner with Risk Management, Portfolio Management, Performance Management, Clients, Investment Operations, 3rd party consultants and external auditors to support a wide range of production related issues.
• Liaison with all front office departments to identify data requirements and appropriate data source(s) to meet the need.
• Collaborate among internal teams to create and maintain standard taxonomies for critical enterprise-wide investment data such as asset classifications and quality ratings.
• Provide data governance and ensure data integrity by coordinating data management efforts across the organization.
• Troubleshoot issues related to master data management and identify opportunities for improving data management processes.
• Collaborate with IT when modifications to existing configuration are deemed necessary in the Enterprise Data Management tool.
• Support all vendor management related processes as needed.

Requirements:

• Bachelor's degree in Business or a related field
• Minimum of 3 years of data management experience, preferably in financial or investment management industry
• Ability to contribute to moderately complex aspects of a project
• High level of interaction with internal & external customers
• Strong organizational, verbal and written communication skills
• Detail oriented, analytical mentality with problem solving, research, and follow-up skills
• Ability to meet tight deadlines and multi-task
• Ability to work independently and collaboratively in a team environment
• Advanced prioritization skills and experience with agile methodology
• Advanced knowledge of finance/accounting data and systems
• Experience with straight-through process management and project management is a plus

Technical Skills:

• Advanced experience working with Microsoft Excel, Microsoft Teams and Microsoft SQL Query
• Intermediate knowledge of database architecture and design
• Intermediate experience with Bloomberg data is a plus
• Intermediate experience writing Oracle SQL code is a plus
• Basic experience using visualization tools (Power BI) is a plus
• Basic experience using Extract Transform Loads (ETL’s) is a plus

Base Compensation: The anticipated base salary range for this position is $70,000 to $100,000 per year. This range was established in good faith based on factors that may include the position’s responsibilities, required experience and qualifications, internal compensation structure, compensation for comparable positions, geographic considerations, and the approved budget. The actual compensation offered will be determined based on lawful, job-related factors and may vary within the stated range. This is not a commission-based position.

Benefits and Other Compensation: Subject to applicable eligibility requirements and the terms of the governing plans and policies, benefits offered with this position generally include medical coverage, dental coverage, vision coverage, retirement plan and employer contribution, paid time off, paid holidays, paid sick leave, life and disability coverage, and other applicable fringe benefits. This position is also eligible for incentive awards, if applicable. The benefit descriptions in this posting are summaries only. Eligibility, coverage, benefit levels, and other terms are governed by the applicable plan documents, policies, and applicable law.

Conning is an equal opportunity employer. Our company embraces the principles of inclusion; our employees can bring the best version of themselves to work every day. We thrive in an environment where everyone’s voice is heard, every idea counts, and the differences of our employees are valued. We provide reasonable accommodations to those who need them. If you are unable to complete this application due to a disability, contact us to ask for an accommodation or an alternative application process. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. Applicants must exhibit a strong commitment to meet compliance obligations reflecting Conning's core values of honesty and integrity; must accept responsibility for compliance in each role and comply with all applicable rules, regulations, and legal requirements.

Conning is a leading global investment management firm with a long history of serving the insurance industry. We develop customized investment strategies that address our clients’ unique objectives, requirements and tolerance for risk. We develop solutions by leveraging Conning’s risk management tools and utilizing a highly disciplined investment process that relies on fundamental analysis.