Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

Ankura is seeking a Data Engineer / Business Intelligence professional to build and maintain the firm's reporting infrastructure, integrate disparate data sources, and develop intuitive dashboards to 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.
• Create scalable ETL pipelines using SQL, Alteryx, and Fabric Data Factory, integrating structured and unstructured data sources.
• Use tools such as Alteryx, Power Query, or Python to automate repetitive tasks and improve reporting efficiency.

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.
• 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.
• Workday ERP Integration: Support reporting and data integration from Workday PSA and Financials, including API usage and data migration.

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.