Data Analyst, Data Transformation

Citco; Charlotte (NC); On-site; USD 90,000 - 135,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

Annual discretionary bonus pool

Retirement savings plan

Tuition reimbursement

Mental health and wellness support

Parental leave

Job summary

Citco is seeking a data transformation professional to analyze requirements, design integrations, and partner with product and technology teams in Charlotte. The role focuses on understanding system data, coordinating delivery, and building analytics solutions using SQL, Python, C++, VBA, and BI tools.

You will maintain documentation, refine backlogs, and drive initiatives aligned to business objectives while staying current with market trends and best practices in data integration.

Qualifications

• Bachelor’s degree in a quantitative discipline is required.
• Strong knowledge of SQL, Python, C++, VBA, Qlik, Tableau, and/or Power BI.
• Project management skills with attention to detail and ability to multi-task.
• Excellent written and verbal communication skills; ability to translate business concepts to tech teams.
• Scrum Master or Product Owner certification is a plus; AWS familiarity is a plus.

Responsibilities

• Partner with Citco platform owners to understand system data, architecture, and capabilities.
• Collaborate with business groups to identify data needs.
• Create and mock up data integration solutions using system data.
• Maintain a documentation repository for data integration projects.
• Coordinate with technology groups for planning, implementation, and deployment.
• Build data and analytics solutions for business teams using available platforms.
• Define, sponsor, and steer development initiatives with business partners.
• Create and refine a backlog of user stories aligned to business objectives.
• Influence technology, project management, and operations during delivery.
• Contribute to product vision and align roadmap to strategic goals.
• Stay current with market trends and competitor activity.
• Collaborate with other product teams on prioritization and reuse.
• Work with Product Manager to prioritize product enhancements.

Skills

SQL

Python

C++

VBA

Qlik

Tableau

Power BI

Project management

Education

Bachelor’s degree in a quantitative discipline

Tools

SQL tools

PowerPoint

Visio

Atlassian products

AWS

Scrum certifications

Job description

Support data transformation efforts by analyzing requirements, designing integrations, and partnering across product and technology teams.

Responsibilities

• Partner with Citco platform owners to understand system data, architecture, and available capabilities
• Collaborate with business groups to identify tactical and strategic data needs
• Use system data to mock up point to point integration solutions
• Create and maintain a documentation repository for data integration projects
• Coordinate with technology groups for planning, implementation, and deployment
• Build data and analytics solutions for business teams using platforms available to the team
• Through business partnership, define, sponsor, and steer development initiatives
• Create and refine a backlog of user stories aligned to business objectives
• Influence and guide technology, project management, and operations teams during solution delivery
• Contribute to product vision and align the roadmap to strategic goals
• Maintain and develop expertise by staying current with market trends, direction, and competitor activity
• Collaborate with other product teams on prioritization and reuse of functionality
• Work with the Product Manager and stakeholders to prioritize product enhancements

Requirements

• Bachelor’s degree in a quantitative discipline
• Strong knowledge of SQL, Python, C++, VBA, Qlik, Tableau, and/or Power BI
• Project management skills with attention to detail and proven ability to multi-task
• Excellent communication skills for translating business concepts to technology teams
• Strong written and verbal communication skills
• Strong visual communication skills using PowerPoint and Visio
• Atlassian products knowledge is a plus
• Certified Scrum Master or Certified Scrum Product Owner is a plus
• AWS familiarity is a plus

Technologies

• SQL
• Python
• C++
• VBA
• Qlik
• Tableau
• Power BI
• Atlassian products
• PowerPoint
• Visio
• AWS

Benefits

• Comprehensive and competitive total rewards package
• Annual discretionary bonus pool based on company profitability and individual contributions
• Medical, dental, and vision coverage
• Short-term and long-term disability benefits
• Retirement savings plan
• Tuition reimbursement
• Mental health and wellness support
• Parental leave

Location: Charlotte, NC (onsite)

Education: Bachelor’s degree in a quantitative discipline