Consultant, Business Intelligence

The role

You will gather business requirements to design, develop, and maintain dashboards. You will bridge the gap between raw data and strategic business decisions using Amazon QuickSight and Microsoft Power BI.

What you will do

• Collaborate with cross-functional stakeholders to extract complex business requirements.
• Translate vague business needs into detailed, technical data specifications.
• Define clear, measurable Key Performance Indicators (KPIs) aligned with business goals.
• Document data dictionaries, metric definitions, and source-to-target mappings.
• Design intuitive, interactive, and visually compelling dashboards in Power BI and QuickSight.
• Build robust data models, calculated measures, and row-level security (RLS) features.
• Optimize dashboard performance to ensure fast load times for end-users.
• Migrate or replicate reports across AWS and Azure environments when necessary.
• Validate data accuracy and consistency across all published reports.
• Document dashboard metadata, metric definitions, and data lineage within Atlan.

Required qualifications

• 3+ years of professional experience as a BI Analyst, Data Analyst, or similar role.
• Proven track record of leading requirement-gathering workshops with executives.
• Advanced knowledge of DAX, Power Query, and premium capacity management.
• Deep expertise in SPICE ingestion, calculated fields, and AWS ecosystems.
• Strong ability to write complex queries, joins, and aggregations for data validation.
• Solid understanding of star schemas, snowflake schemas, and normalization.
• Exceptional ability to dissect vague requests into structured logic.
• Clear verbal and written skills to explain data to non-technical peers.
• Obsessive focus on data accuracy and formatting consistency.

Nice to have

• Certifications in AWS (e.g., AWS Certified Data Analytics) or Microsoft (e.g., PL-300).
• Experience with cloud data warehouses like Amazon Redshift, Snowflake, or Google BigQuery.

Before you apply

• Not eligible for company-sponsored employee benefits.

About the company

Apiphani is a technology-enabled managed services company dedicated to redefining what it means to support mission-critical enterprise workloads. It is a small but rapidly growing company.