Posted at: 12 December

BI Architect

Company

RxSense

RxSense is a Boston-based healthcare technology company offering SaaS solutions for prescription management and pharmacy benefits, serving both B2B and B2C markets across the United States.

Remote Hiring Policy:

RxSense operates a hybrid work model, requiring candidates within a commutable distance to offices in Boston, Princeton, New York City, and West Palm Beach to work in-office as part of their role.

Job Type

Full-time

Allowed Applicant Locations

United States

Salary

$120,000 to $137,000 per year

Job Description

We are a healthcare technology company that provides platforms and solutions to improve the management and access of cost-effective pharmacy benefits. Our technology helps enterprise and partnership clients simplify their businesses and helps consumers save on prescriptions.

As a leader in SaaS technology for healthcare, we offer innovative solutions with integrated intelligence on a single enterprise platform that connects the pharmacy ecosystem.  With our expertise and modern, modular platform, our partners use real-time data to transform their business performance and optimize their innovative models in the marketplace.

Position Overview:

We are seeking a BI Architect with strong experience in Qlik Sense and a modern data engineering mindset. The ideal candidate will have at least 5 years of hands-on experience in designing, implementing, and optimizing BI solutions using Qlik Sense.  While Qlik Sense will remain the primary BI platform, we are looking for someone who also brings experience with Snowflake, DataOps practices, and dbt to help mature our analytics ecosystem. This role focuses on BI architecture, data modeling, platform optimization, and guiding the evolution of enterprise reporting and analytics.

Key Responsibilities:

BI Architecture and Solution Design:

  • Design, implement, and maintain scalable and high-performing BI architectures using Qlik Sense and NPrinting to support organizational reporting and analytics
  • Develop data models, dashboards, and reports in Qlik Sense, ensuring they meet business requirements and performance standards.
  • Design BI solutions that integrate with Snowflake, dbt, and cloud-based data pipelines.

Platform Optimization and Best Practices:

  • Establish and enforce best practices for Qlik Sense and NPrinting, including data modeling, dashboard design, security, and performance tuning.
  • Optimize data structures, load scripts, and queries to enhance the efficiency and speed of Qlik Sense applications.
  • Proactively identify system/app performance issues and resolve by working with the BI developers.
  • Maintain security and access controls within Qlik Sense and NPrinting to ensure data integrity and compliance with company
  • Partner with Data Engineering and DataOps teams to optimize Snowflake schemas, dbt models, and ELT workflows supporting BI consumption.

Required Qualifications:

  • 5 + years of hands-on experience with Qlik Sense and NPrinting. Experience working in Data Warehouse environments, like Snowflake and cloud-based technologies like MS Azure, AWS.
  • Bachelor’s degree in computer science, Information Technology, Data Science, or a related field.
  • Excellent communication and interpersonal skills with the ability to work effectively with cross-functional teams.
  • Strong proficiency in data modeling, scripting, and dashboard design within Qlik Sense. Advanced knowledge of NPrinting for report generation and
  • Proven ability to design and implement scalable BI solutions and data models that meet business objectives.
  • Should have used AWS data sources.
  • Advanced ability to utilize SQL to link disparate data sources, flat files with core data.
  • Deep understanding of the overall architecture of BI platforms such as Qlik, on both single and multi-node platforms.
  • Qlik Sense and NPrinting certifications are preferred
  • Snowflake and dbt certifications or training desired
  • PBM-specific knowledge and experience with transforming various healthcare data is a plus but not required.
  • Experience with Microsoft SQL Server and/or Snowflake is Experience working in Data Warehouse environments, like Snowflake and cloud-based technologies like MS Azure, AWS.

Salary Range: 120,000 - 137,000

RxSense believes that a diverse workforce is a more talented and productive workforce. As such, we are an Equal Opportunity and Affirmative Action employer. Our recruitment process is free from discriminatory hiring practices and all qualified applicants are considered for employment without regard to race, color, religion, sex, gender, sexual orientation, gender identity, ancestry, age, or national origin.  Neither will qualified applicants be discriminated against on the basis of disability or protected veteran status.  We believe in the strength of the collaboration, creativity and sense of community a diverse workforce brings.