apiphani Logo

apiphani

Consultant, Business Intelligence

Posted 10 Days Ago
Remote
Hiring Remotely in USA
2K-5K Annually
Mid level
Remote
Hiring Remotely in USA
2K-5K Annually
Mid level
Provides business intelligence consulting by gathering requirements, defining KPIs, and designing dashboards in Power BI and Amazon QuickSight. Builds data models, calculated measures, row-level security, and scalable reporting solutions; validates data quality and performance; documents metadata and lineage in Atlan; trains users; and collaborates with data engineers on data structures and pipelines.
The summary above was generated by AI

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 consultant to support our team in a Business Intelligence (BI) Analyst capacity.

In this role 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

  • 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.

 

This is a part-time consulting opportunity requiring 20 hours per week and is not eligible for company-sponsored employee benefits. Compensation is expected to range from USD $2,000 to $5,000 per month and may be paid hourly or as a fixed monthly consulting fee, as agreed upon at the start of the engagement. Final compensation will be based on experience, scope of work, and location.

Base Salary
$2,000—$5,000 USD
Company Benefits*
  • Medical/dental/vision - 100% paid for employees, 50% paid for dependents
  • Life and disability - 100% paid for employees
  • 401K - 3% contribution, no employee contribution necessary 
  • Education and tuition reimbursement
  • Accident, critical illness, hospital indemnity benefits offered through our providers
  • Employee Assistance Program 
  • Legal assistance
  • Paid Time Off - up to 6 weeks per year 
  • Sick Leave - up to 2 weeks per year
  • Parental 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.

Similar Jobs

8 Hours Ago
Remote
US
Senior level
Senior level
Information Technology
Leads end-to-end Power BI consulting engagements, from discovery and solution architecture through development, deployment, governance, enablement, and adoption. Designs scalable semantic models, reports, dashboards, and analytics products while advising executives and technical stakeholders. Manages delivery planning, risks, budgets, proposals, and client expectations; mentors consultants; and develops reusable Power BI accelerators and enterprise adoption practices.
Top Skills: AlteryxCloud Data WarehousesCoalesceCopilot StudioData MartsDataikuDaxDimensional ModelingKnimeLakehousesMatillionPower AppsPower AutomatePower BIPower Bi ServicePower QuerySemantic ModelingSigmaSnowflakeSQLTableau
26 Minutes Ago
Easy Apply
Remote
United States
Easy Apply
165K-165K Annually
Senior level
165K-165K Annually
Senior level
Information Technology • Security • Cybersecurity
Researches IT and OT vulnerabilities, evaluates CVE and vendor disclosures, maps affected assets and versions, develops vulnerability checks and detections, writes technical reports, analyzes attack exposure, and mentors analysts. The role combines original vulnerability research with cybersecurity content development for critical infrastructure environments.
Top Skills: Active DirectoryCi/CdCisaCpeCveCvssCweDnp3EpssEthernet/IpGitGoHmisKevLinuxModbusNvdPlcsPythonRegular ExpressionsRtusRubyScadaSQLWindows
27 Minutes Ago
Remote
United States
120K-130K Annually
Senior level
120K-130K Annually
Senior level
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead technical execution of experimentation and personalization initiatives using Adobe Target, JavaScript, HTML, and CSS. Build, launch, debug, and validate A/B tests and targeted experiences across responsive websites and modern JavaScript frameworks. Collaborate with strategists, designers, product managers, and analytics teams to assess feasibility, implement reliable test experiences, validate tracking, and establish reusable development standards. Promote information security practices and ensure compliance with data privacy requirements.
Top Skills: Adobe TargetAlloy.JsAngularAt.JsCSS3HTML5JavaScriptReactVueWeb Sdk

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account