Data Analyst

The Cynosure Group; Salt Lake City (UT); On-site; USD 70,000 - 100,000; Full time

Job summary

The Cynosure Group seeks a Data Analyst to modernize and maintain its internal data infrastructure in Salt Lake City. You will lead the migration of an Access database to Azure, ensure data quality, and support MSCI Barra implementation for risk management. You will own data feeds and improve data workflows across teams.

Expect to build dashboards in Power BI and work closely with risk, front/back office, and client experience teams to enhance data-driven decision making.

Qualifications

• Bachelor's degree in Mathematics, Computer Science, Engineering, or a related quantitative field.
• 2–5 years of relevant professional experience.
• Proficiency in Python for data analysis and automation.
• Strong SQL skills, including querying, joins, and optimization.
• Experience with Microsoft Access, including database structure, queries, and forms/reports.
• Experience building reports and dashboards in Power BI.
• Proficiency in Excel, including formulas, pivot tables, and data analysis.
• Comfort working with large datasets and a strong attention to detail.
• Strong problem-solving skills and the ability to work independently.

Responsibilities

• Maintain and support the team's internal database, currently built on Microsoft Access.
• Lead and support the ongoing migration of the database from Access to Azure.
• Identify, investigate, and resolve data quality issues through data cleaning and validation.
• Support the Risk Management team with the implementation of MSCI Barra, including ongoing maintenance, enhancement, and support following go-live.
• Own and maintain all data feeds, ensuring accuracy, timeliness, and reliability.
• Propose and implement process improvements to streamline data workflows and reporting.
• Build and maintain dashboards and reports using Power BI.
• Serve as a bridge between back office and front office teams on data needs and workflows.
• Partner with the Client Experience Team to develop and implement improved long-term approaches for retrieving data from the database.
• Write and optimize SQL queries to support data extraction, transformation, and analysis.

Skills

Python

SQL

Power BI

Excel

Microsoft Access

Education

Bachelor's degree in Mathematics, Computer Science, Engineering, or a related quantitative field

Tools

Azure

MSCI Barra

Job description

The Cynosure Group is a multi-strategy investment management and wealth advisory firm with offices in Salt Lake City,UT and New York City, NY. Founded in 2014, Cynosure currently has more than $11.5 billion of AuM (RegulatedAssets Under Management as of June 2026).

About Cynosure Capital Management

Cynosure Capital Management (CCM), a subsidiary of The Cynosure Group, is an Outsourced Chief Investment Office(OCIO) with approximately $6 billion in Regulated AUM (as of June 2026). CCM partners primarily with privatefoundations and endowments that outsource investment management and operational oversight.

Position Overview

We are seeking a Data Analyst to help modernize and maintain the firm's internal data infrastructure. In this role, youwill lead the transition of our legacy Microsoft Access database to Azure, safeguard data quality across the organization,and support our risk management team through the implementation and ongoing use of MSCI Barra. This is an excellentopportunity for a detail-oriented professional who wants to own data processes end-to-end and drive meaningfulimprovements to how the firm works with data.

Key Responsibilities

• Maintain and support the team's internal database, currently built on Microsoft Access.
• Lead and support the ongoing migration of the database from Access to Azure.
• Identify, investigate, and resolve data quality issues through data cleaning and validation.
• Support the Risk Management team with the implementation of MSCI Barra, including ongoing maintenance,enhancement, and support following go-live.
• Own and maintain all data feeds, ensuring accuracy, timeliness, and reliability.
• Propose and implement process improvements to streamline data workflows and reporting.
• Build and maintain dashboards and reports using Power BI.
• Serve as a bridge between back office and front office teams on data needs and workflows.
• Partner with the Client Experience Team to develop and implement improved long-term approaches for retrievingdata from the database.
• Write and optimize SQL queries to support data extraction, transformation, and analysis.

Qualifications

• Bachelor's degree in Mathematics, Computer Science, Engineering, or a related quantitative field.
• 2–5 years of relevant professional experience.
• Proficiency in Python for data analysis and automation.
• Strong SQL skills, including querying, joins, and optimization.
• Experience with Microsoft Access, including database structure, queries, and forms/reports.
• Experience building reports and dashboards in Power BI.
• Proficiency in Excel, including formulas, pivot tables, and data analysis.
• Comfort working with large datasets and a strong attention to detail.
• Strong problem-solving skills and the ability to work independently.

Preferred Qualifications

• Familiarity with MSCI Barra or other risk analytics platforms.
• Experience in financial services, investment management, or risk management.
• Experience with database migration projects.