Senior Director, Data Analytics

Summary

Join Choreo, a wealth management firm, as their Senior Director of Data Analytics! Lead the data-driven decision-making and strategic thought leadership for both internal and external stakeholders. Leverage your expertise to provide strategic recommendations influencing key business decisions. Collaborate across departments and with the analytics team to deliver innovative solutions. As a key member of the Technology leadership team, you will advise senior leadership, enabling the firm's strategies with data to drive profitable growth. You will lead an analytics team, define a formal data governance program, and ensure data security and quality within the Azure environment. This role requires a unique combination of proactiveness, curiosity, and business acumen.

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
• 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

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

Benefits

• 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