Senior Director, Enterprise Data Enablement Data Engineer Business Intelligence

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 Ankuras client facing business groups. All of Ankuras 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 Ankuras ABS groups work in harmony to Protect Create and Recover Value for our clients.

Role Overview:

Ankura is seeking a seasoned Data Engineer / Business Intelligenceprofessional 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 firms 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 viaPower BI Fabric dashboards Excel and PowerPoint.

Requirements:

• Bachelors 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 proficiencywith Power BI (DAX M) SQL Alteryx / KNIME and Microsoft Fabric.

• Strong background inETL design large data model development and BI dashboarding.

• Experience with WorkdayERP 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 or call toll-free 1.. 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.