Senior Director, Data Analytics

Choreo; United States; Remote; USD 150,000 - 180,000; Full time

Job summary

Choreo is on the lookout for a Senior Director of Data Analytics, a pivotal role within our Technology team. This leader will drive data-driven decision-making and collaborate across departments to optimize our analytics capabilities, ensuring data governance and quality assurance while mentoring a team of analysts. Join us to influence our firm’s growth with actionable insights derived from comprehensive data strategies.

Benefits

Competitive salary and bonus plan

401(k) matching program

Unlimited, discretionary time off

Paid parental leave

Qualifications

• 10+ years in enterprise information development in financial services preferred.
• Experience with SDLC methodologies like Waterfall and Agile.
• Strong analytical and communication skills.

Responsibilities

• Lead a BI/ETL developers team for reporting data visualization.
• Define data governance program and architecture deliverables.
• Collaborate with multiple departments for analytics solutions.

Skills

Data governance

Business intelligence solutions

Data analysis

Visualization

Critical thinking

Collaboration

Education

Undergraduate Degree in Computer Science or related field

Tools

PowerBI

SQL

T-SQL

Azure Fabric

GitHub

Job description

Choreo is a wealth management firm built on an interconnected network of financial advisors with a shared vision servicing entrepreneurs, CPAs, and individuals with a forward-thinking approach to financial planning to translate wealth into fulfillment. With over 200 employees and 40+ locations across the country, we are here to serve our clients beyond what is expected.

Choreo is seeking a Senior Director of Data Analytics as a leader on the Technology team reporting to the Chief Information Officer. This role will lead data-driven decision-making and strategic thought leadership with both internal and external stakeholders. By leveraging your vast knowledge in data analytics, you will provide strategic recommendations that influence key business decisions. This role will bridge collaborations between multiple departments and our analytics team, ensuring our firm’s needs are met with innovative and effective solutions.

The Senior Director of Data Analytics will be a key member of the Technology leadership team and will be a trusted advisor to senior leadership by delivering actionable insights and enabling the Firm’s strategies with data that will drive profitable growth. The Senior Director will partner with the Chief Information Officer, Senior Director of Information Security and Managing Director of Platform Technology on a day-to-day basis.

This role will be responsible for leading an analytics team to define a formal data governance program, architecture deliverables, success criteria, performance measurements, and operational processes that will be critical to successful delivery. The Senior Director will cultivate a culture of growth, mentorship, and excellence within the team while ultimately making a significant impact on Choreo's financial targets. They will be responsible for data governance, operations, accuracy, and quality assurance processes, and must ensure the data within our Azure environment is secure and corporate data in the SQL data warehouse remains up to date with automated feeds from multiple source systems.

A successful candidate will have the ability to transform data into insights, collaborate as part of an analytics center of excellence, exchange knowledge, and be a rigorous critical thinker with a unique combination of proactiveness, curiosity, and business acumen.

Primary Responsibilities:

• Lead a team of BI/ETL developers responsible for the design, development, and delivery of intuitive, engaging, and informative reporting data visualization assets
• Design, develop, deliver, and maintain data architecture assets, governance plan, deliverables, and documentation
• Stay current on all upcoming features and capabilities of relevant technology solutions including Microsoft Fabric, SQL databases, Copilot and PowerBI reports
• Provide detailed documentation including process guidance, training, and solution descriptions to departmental and technical stakeholders
• Lead efforts to conduct requirements analysis, document technical specifications, and helps write, review, and debug ETL and PowerBI code
• Recommend revisions or enhancements to available reports based on user feedback
• Develop and maintain documentation, conduct training, and build user manuals for reporting solutions.
• Provides support in the event of problems related to reporting results, data accuracy, and troubleshooting issues that arise with data warehouse processes

Technical Requirements:

• 10+ years experience designing developing business intelligence solutions using PowerBI or similar tools
• 10+ years experience architecting various data models, including relational and star schema
• 10+ years experience implementing various semantic models, including Tabular, Multidimensional, Security Models, Dimensional Structures, and hierarchies
• 10+ years experience developing queries and stored procedures using T-SQL, Python, and Data Analysis Expressions (DAX)
• Experience developing ETL solutions utilizing SSIS, Azure Fabric, Data Factory, or other enterprise platforms
• Experience in utilizing Azure DevOps or TFS for issue tracking and Github for code versioning
• Experience with Microsoft’s Technology Ecosystem (Azure, Dynamics365, Office365, Copilot, and Power platforms)
• Experience designing and developing solutions using Visual Studio\SSDT\DAX Studio\Tabular Editor
• Skilled in preparing and delivering documentation such as, but not limited to, business and functional requirements, data flow, logical, and physical diagrams

Basic Qualifications:

• Undergraduate Degree, preferably in Computer Science (CS), Management Information Systems (MIS), or another Information Technology related field of study
• Minimum of 10 years in a corporate environment designing, developing and supporting enterprise information assets, with 3 years of experience in Financial Services/Wealth Management preferred
• Strong analytical skills and experience with the SDLC methodologies such as Waterfall and Agile.
• Strong communication, presentation and interpersonal skills amongst key stakeholders
• Ability to work efficiently, effectively, and independently as well as in a team environment to see projects through to conclusion
• Excellent organizational skills with the ability to prioritize multiple tasks, projects, and assignments with the ability to float between multiple projects
• Adheres to industry best practices, quality, standards, framework, and approach for designing and deployment of enterprise digital and reporting assets

Expected annual salary ranges from $150,000 to $180,000 plus incentive compensation. Salary is negotiable based on location, experience, and qualifications.

Employee Benefits

At Choreo, we provide a holistic, total reward offering to empower our teams in their professional and personal lives. We seek to provide employees with benefits that place an emphasis on health, happiness, and financial security. Here is what we offer:

• Competitive salary and bonus plan
• Competitive medical, dental, and vision plans
• Basic life and disability coverage
• 401(k) matching program
• Financial support for approved designations and courses
• Technical, leadership, sales training opportunities
• Unlimited, discretionary time off
• Paid parental leave

Choreo is an equal opportunity employer. We are committed to fostering, cultivating, and preserving a culture of diversity, equity, and inclusion.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

What are your salary expectations?

Please provide a range.

Are you authorized to work in the U.S.? * Select...

Will you require visa sponsorship in the future? * Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Choreo’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305

Page 1 of 1

OMB Control Number 1250-0005

Expires 04/30/2026

Voluntary Self-Identification of Disability

Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Intellectual or developmental disability
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
• Short stature (dwarfism)
• Traumatic brain injury

Disability Status Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.