Data Analyst

Job Category: Technology and IT
Job Type: Full Time
Job Location: USA
Company Name: MAI Capital Management

Company Overview

Established in 1973 through a handshake between golf legend Arnold Palmer and renowned sports agent Mark McCormack, MAI Capital Management was founded with a clear mission: to make our clients’ lives easier. Over the past 50 years, while the financial landscape has evolved, our commitment as a registered investment adviser has remained steadfast—we empower clients to simplify, protect, and grow their wealth.

MAI specializes in wealth management and sports & entertainment financial services, offering tailored solutions to meet the unique needs of each client. We uphold a fiduciary duty to act in the best interests of those we serve, delivering comprehensive financial strategies that align with their goals.

Our expertise includes:
Financial & Estate Planning – Securing your legacy with personalized strategies.
Investment Management – Building and preserving wealth through strategic asset allocation.
Tax Planning & Preparation – Maximizing tax efficiency for long-term financial success.
Insurance & Risk Management – Protecting assets with tailored coverage solutions.
Accounting & Bill Pay – Ensuring financial clarity and organization.
Philanthropy Advisory – Guiding charitable giving to align with your values.
Boutique Services – Including family office support and specialized financial solutions for athletes, entertainers, and industry professionals.

Senior Data Analyst – Key Responsibilities & Qualifications

Major Duties & Responsibilities

  • Database Development & Querying: Design and develop databases while writing advanced SQL queries within Azure Data Environments (Azure Data Lake, Azure SQL Managed Instance, Azure Purview, Azure Data Factory).

  • Data Strategy & Optimization: Implement data collection strategies to enhance data quality and improve operational efficiency.

  • Data Acquisition & Automation: Gather data from multiple sources, filter and clean datasets, and automate processes to maintain data integrity.

  • Trend Analysis & Interpretation: Analyze complex datasets to identify trends, patterns, and insights that drive business decisions.

  • Cross-Team Collaboration: Partner with business and technical teams to gain in-depth knowledge of business domains and align data solutions with organizational needs.

  • Requirement Documentation: Translate business needs into data requirements for improved decision-making and process optimization.

  • Continuous Improvement: Research and implement new tools and methodologies to enhance efficiency, performance, and cost-effectiveness.


Qualifications & Experience

  • Education: Bachelor’s degree in Mathematics, Economics, Computer Science, Information Management, Engineering, Statistics, or a related field.

  • Experience: Minimum 5+ years of experience as a Data Analyst with expertise in Azure Data Lake, SQL Managed Instance, Data Factory, and Purview.

  • Technical Skills:

    • Advanced proficiency in SQL with the ability to write complex queries for extracting and analyzing large datasets.

    • Strong analytical skills with a keen ability to interpret data and translate insights into actionable strategies.

    • Hands-on experience with data management, ETL processes, and automation.

  • Competencies:

    • Strong technical expertise, analytical mindset, and problem-solving abilities.

    • Excellent organizational and interpersonal skills with a focus on collaboration and teamwork.

    • Ability to prioritize multiple tasks in a fast-paced environment while maintaining attention to detail.

    • High standards of confidentiality, integrity, and professionalism in handling sensitive data.


Featured Benefits

  • Competitive Compensation: Performance-based discretionary bonus

  • Health & Wellness: Comprehensive medical, dental, and vision insurance

  • Retirement Planning: 401(k) plan with employer contributions

  • Work-Life Balance:

    • Paid maternity & parental leave

    • Health Savings Account (HSA)

    • Tuition reimbursement for continued education

APPLY

Apply for this position

Allowed Type(s): .pdf, .doc, .docx