Senior Director, Enterprise Data Enablement Data Engineer / Business Intelligence

Job description

Ankura is a team of excellence founded on innovation and growth.




Ankura Corporate Overview:

The goal of Ankura Business Services (ABS) is to provide support and assistance to Ankura’s client facing business groups.

All of Ankura’s ABS groups work together to achieve a common goal, which is to create innovative solutions for our clients.

ABS includes Finance, Legal, IT Services, Marketing and Communications, Real Estate, Conflict Check, Operations & Workplace Services, and the People Office.

Collaborative lateral thinking, hard-earned experience, expertise, and multidisciplinary capabilities drive results.

Together, Ankura’s ABS groups work in harmony to Protect, Create, and Recover Value for our clients.


Role Overview:

Ankura is seeking a seasoned Data Engineer / Business Intelligence professional with strong technical acumen and demonstrated experience in dashboarding, data modeling, and workflow automation to join the Operations team.

This position will play a pivotal role in building and maintaining the firm’s reporting infrastructure, integrating disparate data sources, and developing intuitive dashboards that enable informed operational decision-making.

The ideal candidate has extensive experience designing and scaling data pipelines, optimizing reporting outputs, and applying advanced analytics to improve business performance.

Candidates must demonstrate a disciplined approach to data governance, confidentiality, and security, as they will be handling sensitive operational and financial information.

Prior experience within the Professional Services sector is a plus.

The role will be filled at the Senior Director level.

This position is ideally hybrid based for a candidate located near an Ankura office in the eastern or central time zone but there is potential to be remote based (in the eastern or central time zone).


Responsibilities:

Core Responsibilities
+ Data Engineering & ETL: Design, build, and maintain efficient data pipelines using SQL, Alteryx, Microsoft Fabric, and other ETL tools to integrate and transform data from multiple systems (e.g., Workday ERP, Salesforce CRM, Intapp).
+ Dashboard Development: Lead the design and development of executive-level dashboards and reports in Power BI and Microsoft Fabric, ensuring outputs are intuitive, scalable, and actionable.
+ Advanced Data Modeling: Architect and optimize large-scale data models, applying best practices in normalization, schema design, and performance tuning for analytics and reporting.
+ Automation & Optimization: Identify opportunities to streamline and automate data workflows, reduce manual reporting, and increase the speed and reliability of business insights.
+ Analytics & Insights: Apply statistical and predictive analytics techniques (Python, R, or Alteryx) to analyze large datasets, forecast trends, and generate meaningful operational insights.
+ Collaboration: Partner with IT, Finance, and business leadership to ensure reporting solutions meet stakeholder needs and align with firm-wide operational excellence priorities.
+ Governance & Security: Uphold rigorous standards around data governance, security, and confidentiality in handling sensitive compensation, financial, and client information.



Technical Responsibilities
+ Power BI & Fabric Expertise: Develop complex dashboards, write advanced DAX formulas, use M language for data transformations, and leverage Microsoft Fabric for end-to-end data management, including data lakes, pipelines, and governance.
+ Data Engineering Skills: Create scalable ETL pipelines using SQL, Alteryx, and Fabric Data Factory, integrating structured and unstructured data sources.
+ Workflow Automation: Use tools such as Alteryx, Power Query, or Python to automate repetitive tasks and improve reporting efficiency.
+ Predictive Analytics: Leverage statistical tools (Python, R, Alteryx, KNIME) to model and forecast business performance metrics.
+ Workday ERP Integration: Support reporting and data integration from Workday PSA and Financials, including API usage and data migration.
+ Visualization: Deliver compelling, executive-ready reports and presentations via Power BI, Fabric dashboards, Excel, and PowerPoint.



Requirements:
+ Bachelor’s degree in Data Engineering, Computer Science, Business Analytics, or related field.

Advanced degree preferred.
+ 12+ years of experience in data engineering, BI, or analytics roles (experience in Professional Services industry preferred).
+ Expert proficiency with Power BI (DAX, M), SQL, Alteryx / KNIME, and Microsoft Fabric.
+ Strong background in ETL design, large data model development, and BI dashboarding.
+ Experience with Workday ERP and integrating ERP data with BI tools.
+ Proficiency with Excel (advanced functions, VBA), Power Query, Power Pivot, and PowerPoint.
+ Preferred skills include Python, R, Tableau, Salesforce CRM, and Workday Adaptive Planning.
+ Excellent analytical, problem-solving, and communication skills, with the ability to translate technical outputs into business insights.
+ Experience managing cross-functional data projects, with proven ability to deliver under tight deadlines.
+ Strong organizational skills and the ability to manage multiple priorities across stakeholders.





#LI-MJ1

#LI-Hybrid




*


Ankura is an Affirmative Action and Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.

Equal Employment Opportunity Posters, if you have a disability and believe you need a reasonable accommodation to search for a job opening, submit an online application, or participate in an interview/assessment, please email accommodations@ankura.com or call toll-free +1.312-583-2122.

This email and phone number are created exclusively to assist disabled job seekers whose disability prevents them from being able to apply online.

Only messages left for this purpose will be returned.

Messages left for other purposes, such as following up on an application or technical issues unrelated to a disability, will not receive a response.


Ankura Consulting Group, LLC is an independent global expert services and advisory firm that delivers services and end-to-end solutions to help clients at critical inflection points related to conflict, crisis, performance, risk, strategy, and transformation.

The Ankura team consists of more than 2000 professionals serving 3,000+ clients across 55 countries who are leaders in their respective fields and areas of expertise.

Collaborative Lateral Thinking That Deliversᵀᴹ, hard-earned experience, expertise, and multidisciplinary capabilities drive results and Ankura is unrivalled in its ability to assist clients to Protect, Create, and Recover Valueᵀᴹ.

For more information, please visit, ankura.com.

Required Skill Profession

Other General