Ankura is seeking a seasoned Data Engineer / Business Intelligence professional to build and maintain the firm’s reporting infrastructure, integrate disparate data sources, and develop intuitive dashboards that enable informed operational decision-making.
Requirements
- 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.
- Leverage statistical tools (Python, R, Alteryx, KNIME) to model and forecast business performance metrics.
- Support reporting and data integration from Workday PSA and Financials, including API usage and data migration.
Responsibilities
- 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).
- Lead the design and development of executive-level dashboards and reports in Power BI and Microsoft Fabric, ensuring outputs are intuitive, scalable, and actionable.
- Architect and optimize large-scale data models, applying best practices in normalization, schema design, and performance tuning for analytics and reporting.
- Identify opportunities to streamline and automate data workflows, reduce manual reporting, and increase the speed and reliability of business insights.
- Apply statistical and predictive analytics techniques (Python, R, or Alteryx) to analyze large datasets, forecast trends, and generate meaningful operational insights.
- 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.
- Create scalable ETL pipelines using SQL, Alteryx, and Fabric Data Factory, integrating structured and unstructured data sources.
Other
- 12+ years of experience in data engineering, BI, or analytics roles (experience in Professional Services industry preferred).
- 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.
- Candidates must demonstrate a disciplined approach to data governance, confidentiality, and security, as they will be handling sensitive operational and financial information.
