Job
Description
Description Join our growing Data & Analytics practice as a Data Analytics & Visualization Consultant and play a key role in designing, building, and governing enterprise-grade dashboards and low-code solutions that enable datadriven decision-making across the firm and for our clients. We’re looking for a hands-on, results-driven individual with proven expertise in Power BI, Power Apps, and SQL, along with exposure to modern cloud data ecosystems. Familiarity with Snowflake, Microsoft Fabric best practices, and Finance domain knowledge will be considered valuable assets. This role spans the full delivery lifecycle—including requirements gathering, data modelling, solution design, development, testing, deployment, and support. Collaborate with business stakeholders to gather and translate business requirements into technical solutions. Design and develop end-to-end Power BI dashboards including data models, DAX calculations, row level security, and performance optimization. Build and deploy Power Apps solutions to automate workflows and integrate with Microsoft 365 and data platforms. Write and optimize complex SQL queries to transform, clean, and extract data from Snowflake or Azure-based data platforms. Connect Power BI to Snowflake using best practices (ODBC, DirectQuery, Import modes). Author views and stored procedures on Azure SQL/Synapse to enable scalable and governed reporting. Understand and apply Microsoft Fabric concepts and infrastructure best practices for scalable BI and data integration. Develop workflows using Alteryx or similar data-prep tools as needed. Build data ingestion and transformation pipelines using Azure Data Factory or Synapse pipelines. Collaborate with data engineers to ensure data quality, integrity, and availability. Monitor and troubleshoot solutions, ensuring performance and reliability. Mentor junior team members and support internal knowledge-sharing initiatives Qualifications Bachelor’s degree in computer science, Information Systems, Data Analytics, or a related field. Master’s degree preferred. 5–7 years of experience in Business Intelligence or Analytics roles. Expertise in: Power BI (data modelling, DAX, visuals, optimization) Power Apps (canvas apps, connectors, integration) SQL (query performance, views, procedures) Hands-on experience with: Azure Data Factory / Synapse Pipelines Data prep tools like Alteryx or equivalent Strong communication skills, with the ability to present technical concepts to business stakeholders. Practical, solution-oriented mindset with strong problem-solving skills. Experience with Snowflake (architecture, best practices, optimization) Exposure to Finance domain (e.g., FP&A, P&L dashboards, financial metrics) Experience with other BI tools like Tableau or QlikView is a plus Familiarity with Microsoft Fabric and its infrastructure components Inclusive Diversity A&M’s entrepreneurial culture celebrates independent thinkers and doers who can positively impact our clients and shape our industry. The collaborative environment and engaging work—guided by A&M’s core values of Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity—are the main reasons our people love working at A&M. Inclusive Diversity means we embrace diversity, and we foster inclusiveness, encouraging everyone to bring their whole self to work each day. It runs through how we recruit, develop employees, conduct business, support clients, and partner with vendors. It is the A&M way. Equal Opportunity Employer It is Alvarez & Marsal’s practice to provide and promote equal opportunity in employment, compensation, and other terms and conditions of employment without discrimination because of race, color, creed, religion, national origin, ancestry, citizenship status, sex or gender, gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, family medical history, genetic information or other protected medical condition, political affiliation, or any other characteristic protected by and in accordance with applicable laws. Employees and Applicants can find A&M policy statements and additional information by region here. Unsolicited Resumes from Third-Party Recruiters Please note that as per A&M policy, we do not accept unsolicited resumes from third-party recruiters unless such recruiters are engaged to provide candidates for a specified opening. Any employment agency, person or entity that submits an unsolicited resume does so with the understanding that A&M will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity. Show more Show less
