PromptCare is seeking a Business Intelligence and Reporting Analyst to join our dynamic data team. This role will play a key part in supporting company-wide decision-making through reporting, dashboard development, and BI platform administration. Under the guidance of the Senior Analytics Engineer, the Business Intelligence and Reporting Analyst will be responsible for maintaining Tableau Cloud, fulfilling ad-hoc data requests, and supporting our dbt data models. The ideal candidate will ensure our BI environment is reliable, well-documented, and optimized for business users. 

Reports to: Senior Analytics Engineer 

Job Type: Full-Time, Exempt 

Location: Hybrid out of New Providence, NJ or Lenexa, KS ( open to remote as well)

• Bachelor’s degree in Business Analytics, Information Systems, Data Science, or a related field, or equivalent work experience

• 2–4 years of experience in business intelligence, data analysis, or BI administration 

• Advanced proficiency in Tableau (dashboard development, calculations, data source management); Tableau Administrator experience is a strong plus 

• Strong SQL skills for querying, data analysis, and implementing updates to existing data models 

• Experience with modern data stack tools such as dbt, Snowflake, or similar platforms; hands-on experience maintaining dbt models is preferred 

• Familiarity with data modeling concepts (star schema, dimensional modeling) and experience implementing changes to existing models 

• Service-oriented mindset with a focus on user support and platform reliability 

• Excellent attention to detail and commitment to data accuracy 

• Strong communication skills with the ability to clearly explain technical concepts to both technical and non-technical stakeholders 

• Ability to work independently while also collaborating effectively with team members 

• Proactive problem-solving mindset and a drive to continuously improve data processes and systems 

Job Responsibilities, included but not limited to: 

Tableau Reporting & Analysis:

• Develop, maintain, and optimize Tableau dashboards and reports to meet business needs

• Fulfill ad-hoc data requests and provide analytical support to business stakeholders

• Train and support business users on Tableau best practices and self-service analytics

BI Platform Administration:

• Administer Tableau Cloud: manage users, permissions, groups, and data source connections

• Monitor and maintain data refreshes, subscriptions, and alerts

• Ensure platform performance, security, and adherence to best practices

Data Model Maintenance & Support:

• Under the guidance of the Senior Analytics Engineer, implement well-defined updates to dbt models (e.g., adding fields, creating CTEs, maintaining crosswalk mappings)

• Support data quality checks and validation within existing transformation pipelines

• Document data models, reporting logic, and platform processes

Collaboration & Documentation:

• Work closely with the Senior Analytics Engineer to align reporting needs with data model enhancements

• Collaborate with business teams to gather requirements and deliver actionable insights

• Create and maintain documentation for reports, dashboards, and administrative procedures

Physical Demands  

The physical requirements outlined here are indicative of what an employee must meet to effectively carry out the essential functions of this role. While performing job duties, the employee is frequently required to communicate verbally and listen attentively. The role necessitates the ability to lift files, open filing cabinets, and bend or stand as needed. Additionally, the position occasionally requires lifting office products and supplies weighing between 20 and 30 pounds.

Benefits & Perks:

• Comprehensive Medical, Dental, and Vision Package
• 401(k) Plan with Company Match
• Generous PTO: Vacation, Sick Time, Personal Days, and Paid Holidays
• Life Insurance: Standard coverage with optional enhancements
• Employee Assistance Program: Free counseling and coaching sessions
• Emotional Well-being and Work-Life Balance Resources
• Short & Long-Term Disability: Company-paid with optional supplements
• Accidental Death and Dismemberment Insurance
• FSA and HSA: Manage healthcare expenses
• Commuter Spending Programs
• Volunteer and Engagement Opportunities
• Employee Referral Bonuses
• Exclusive Discounts on entertainment, travel and various other supplemental and cellphone plans

Equal Employment Opportunity 

The PromptCare Companies is committed to Equal Employment Opportunity (EEO) and prohibits employment discrimination on the basis of race, color, age, national origin, religion, gender, gender identity, sexual orientation, pregnancy, marital status, genetic disposition, disability, veteran's status or any other characteristic or classification protected by State/Federal/Local laws. We foster a work environment in which diversity and inclusion are embraced, people are hired and advanced on their merits, and employees are treated with mutual respect and dignity.