As a member of the Data Engineering team, you’ll have access to the research, knowledge, and tools to create leading-edge solutions across Avanade’s Business Intelligence practice. The role of Senior Engineer is perfect for ambitious technologists passionate about working with the latest Microsoft cloud technology and Microsoft experts. Our clients look to us for innovation, which means you’ll have early access to the newest Microsoft technologies so you can master them and stay ahead of the curve.
Together we do what matters.
Analytics Data & BI Engineer Sr Consultant
Role overview
As an Analytics Data & BI Engineer Sr Consultant, you will contribute to the design, analysis and evolution of enterprise data and analytics platforms.
While many projects leverage modern cloud technologies, this role also requires the ability to work with complex legacy analytical environments, understanding how information flows across systems and how business logic is implemented.
You will combine strong data engineering capabilities with an analytical and consulting mindset, acting as a “data detective” to help clients evolve their platforms in a structured, safe and pragmatic way.
What you’ll do
- Design and deliver data and analytics solutions in complex enterprise environments.
Analyse end ‑ to ‑ end data flows: application layers core data structures processing- consumption.
- Work across modern and legacy environments, identifying integrations, dependencies and technical risks.
- Perform reverse engineering and analysis to uncover business rules embedded in legacy systems (either by reading legacy code or by intercepting and analysing real system behaviour).
- Execute advanced diagnostics and profiling using monitoring tools (e.g., SQL Profiler, Extended Events, DMVs or equivalent) to understand performance, bottlenecks and real usage patterns.
- Design the semantic transition, mapping and translating classic multidimensional architectures (Cubes/MDX) into modern semantic models (Tabular/DAX) within the Microsoft ecosystem.
- Assess current models: KPI/measure inventory, security model review (e.g., roles/RLS), and scalability/performance analysis.
- Support evolution strategies towards hybrid or cloud architectures (Azure, Microsoft Fabric, Databricks, etc.) without locking into a single technology too early.
- Mentor junior team members and promote delivery quality and best practices.
Skills and experience
Required
- Strong experience with relational database engines, including advanced SQL and query optimisation concepts (execution plans, indexing, partitioning or equivalent).
- Strong understanding of semantic/dimensional modelling (star/snowflake, hierarchies, KPIs/measures) and Data Warehousing fundamentals.
- A reverse ‑ engineering mindset: ability to interpret, document and explain data flows and legacy logic with minimal documentation.
- Understanding of software engineering and integration fundamentals (components, services, middleware, dependencies, traceability).
- Strong communication skills and consulting mindset: ability to present technical findings clearly and propose pragmatic options.
Nice to have
- Experience modernising SSAS Multidimensional (MDX) into SSAS Tabular / Power BI / modern semantic models (DAX).
- Experience with metadata extraction and automation tools (e.g., XMLA, TOM, Tabular Editor, ALM Toolkit, DAX Studio).
- Ability to read and understand legacy languages/scripts (VB, C#, ASP, etc.) to extract business logic (no need to develop in them).
- Experience in batch ‑ heavy environments with deeply embedded business logic, with focus on diagnostics and stability.
- Experience with modern data platforms (ADF/Synapse/Fabric/Databricks, Lakehouse architectures, CI/CD, DataOps).
About you
- Analytical, structured, curious, with a technology detective mindset.
- High tolerance for ambiguity: able to make progress in opaque systems with limited documentation.
- Autonomous and proactive: can prioritise, test hypotheses, and turn evidence into conclusions.
- Collaborative and client ‑ focused, delivering tangible value (not theory).
- Genuine interest in understanding existing systems as a necessary step before modernising them
Enjoy your career
Some of the best things about working at Avanade
Find out more about some of our benefits here .
A great place to work
As you bring your skills and abilities to Avanade, you’ll get distinctive experiences, limitless learning, and ambitious growth in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and our communities. You’ll join a community of smart, supportive collaborators to lift, mentor, and guide you, and lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live. It’s all here, so take a closer look!
We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our Inclusion & Diversity page.
Create a future for our people that focuses on
• Expanding your thinking • Experimenting courageously • Learning and pivoting
Inspire greatness in our people by
• Empowering every voice • Encouraging boldness • Celebrating progress
Accelerate the impact of our people by
• Amazing the client • Prioritizing what matters • Acting as one
Learn more
To learn more about the types of projects our Data Engineering team works on check out these case studies:
Interested in knowing what’s going on inside Avanade? Check out our blogs:
