Business Intelligence (BI) Analyst

Apiphani is a technology-enabled managed services company dedicated to redefining what it means to support mission-critical enterprise workloads. We’re a small but rapidly growing company, which means there’s lots of room for growth and learning opportunities abound! Apiphani is dedicated to creating a diverse and inclusive work environment for all as a fundamental component of our business. Diversity and inclusion are the bedrock of creativity and innovation. Without diversity of experience and thought, we would fail to progress as a company and as a team. Apiphani strives to foster an environment of belonging, where every employee feels respected, valued, and empowered. We embrace the unique experiences, perspective, and cultural background, which only you can bring to the table. Job Summary We are seeking a data-driven Business Intelligence (BI) Analyst to join our team. You will bridge the gap between raw data and strategic business decisions. Your primary focus will be gathering deeply detailed business requirements to design, develop, and maintain high-quality dashboards. The ideal candidate has extensive hands-on experience building scalable reporting solutions using both Amazon QuickSight and Microsoft Power BI. Key Responsibilities Requirement Gathering & KPI Definition 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.Dashboard Development & Analytics 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.Data Governance & Collaboration Validate data accuracy and consistency across all published reports.Document dashboard metadata, metric definitions, and data lineage within Atlan to ensure unified data governance.Train business users on how to navigate dashboards and interpret data insights.Partner with data engineers to optimize underlying data structures and pipelines. Required Qualifications Experience 3+ years of professional experience as a BI Analyst, Data Analyst, or similar role.Proven track record of leading requirement-gathering workshops with executives.Technical Skills Power BI: Advanced knowledge of DAX, Power Query, and premium capacity management.AWS QuickSight: Deep expertise in SPICE ingestion, calculated fields, and AWS ecosystems.SQL: Strong ability to write complex queries, joins, and aggregations for data validation.Data Modeling: Solid understanding of star schemas, snowflake schemas, and normalization.Soft Skills Analytical Mindset: Exceptional ability to dissect vague requests into structured logic.Communication: Clear verbal and written skills to explain data to non-technical peers.Detail-Oriented: Obsessive focus on data accuracy and formatting consistency.Preferred Qualifications 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. Base Salary $60,000—$70,000 USD Company Benefits* Medical/dental/vision - 100% paid for employees, 50% paid for dependentsLife and disability - 100% paid for employees401K - 3% contribution, no employee contribution necessary Education and tuition reimbursementAccident, critical illness, hospital indemnity benefits offered through our providersEmployee Assistance Program Legal assistancePaid Time Off - up to 6 weeks per year Sick Leave - up to 2 weeks per yearParental Leave - up to 12 weeks *Benefits listed in the job description apply to employees working in the United States. For international employees, Apiphani partners with an Employer of Record, Deel, and provides all statutory benefits required under local law; certain U.S.-specific programs (such as EAP, legal assistance, etc.) may not be available outside the United States. The specific benefits package will be outlined in the local employment agreement issued through Deel.