Massachusetts Jobs

MassHire JobQuest Logo

Job Information

Prime Therapeutics Sr. BI Specialist - BI and Reporting - Remote in Boston, Massachusetts

Our work matters. We help people get the medicine they need to feel better and live well. We do not lose sight of that. It fuels our passion and drives every decision we make.

Job Posting Title

Sr. BI Specialist - BI and Reporting - Remote

Job Description Summary

Deliver against business intelligence objectives including creating solutions for information delivery and data analytics projects with the goal of empowering and enabling business users with actionable information. Expectations include independently analyzing, designing, and developing business intelligence and analytics solutions using coding standards and best practices in close partnership with business teams, architecture, and IT leaders; as well as, mentoring junior staff by providing guidance and design consultation.

Job Description

  • Independently creates solutions that provide accurate information quickly to the organization.

  • Analyzes, designs and builds reports, dashboards or other business intelligence components as needed.

  • Responsible for development initiatives that may drive the creation of new data assets or information exchange to support the creation of decision support applications or business intelligence/analytics solutions.

  • Work closely with other staff to identify levels of effort and task dependencies as assigned by the Manager.

  • Provides technical guidance on the creation of database tables, objects, assets and/or cubes utilizing commonly accepted methodologies and best practices for dimensional modeling and normal forms. Leads the creation of data marts as needed.

  • Trains and mentors business intelligence and analytics staff on use of new technologies, design and development approaches and the application of established standards and best practices for business intelligence development and data design.

  • Collaborates with other developers on the application of standards and best practices and contributes to the evolution of best practices and standards aimed at improving scalability, performance and maintainability; as well as, mentoring junior staff on the use and value of those standards.

  • Oversees and/or participates in the research and evaluation of new business intelligence, analytics and/or data visualization technologies.

  • Determines the best technologies to use for our environment considering future direction, risk, consistency and return on investment.

  • Considers the technology changes that have taken place over the years and helps project the trends for the future.Trains and mentors programming staff on use of newly acquired/adopted technologies.

  • Creates architecture and/or design documents that may be needed to initiate new development efforts, which may come from knowledge of the overall environment or incoming requirements and specifications.

  • Reviews incoming projects to determine if existing technologies/capabilities can support the needs of the incoming request.

  • Demonstrates the ability to work collaboratively or autonomously (based on the situation) on the design, creation and maintenance of metadata layers that provide easy to understand and accurate representations of our physical data structures and that allow the organization's user communities to derive value and insights from our data assets.

  • Will support, either through consultation, coaching, mentoring or by specifically performing the necessary tasks independently, the analysis, designs and development of reports, dashboards or data sources as needed.

  • Maintain communication with customers, internal and external, to facilitate analysis and troubleshooting for production issues or to ensure high levels of customer focus relating to business intelligence and analytics solutions.


  • A bachelor’s degree in business intelligence, management information systems, mathematics, statistics, analytics, computer and information sciences or similar is required.Will substitute seven years of direct experience in business intelligence, data analytics or statistics in lieu of a bachelor’s degree.

  • 4+ years of work experience in BI or related discipline, other employment or volunteer activities or demonstrated proficiency in Business Intelligence/Analytics project activities through successful initiatives that demonstrate competence that goes beyond what is typical of individuals with 4+ years of work experience.

  • Prior experience as a Business Intelligence Developer or Data Analyst supporting business intelligence, reporting, analytics or data warehouse projects.

  • Experience researching and implementing new information systems in a business setting.

  • Demonstrated experience using multiple databases and tools and using leading business intelligence, analytics or data visualization technologies.

  • Familiarity with a broad range of data platforms (e.g., Oracle, SQL Server, MySQL, Hadoop, Netezza, Teradata, RedShift, Snowflake) and Business Intelligence/data visualization tools/platforms/environments (IBM Cognos, SAS and SQL)

  • Hands-on knowledge of data warehousing and business intelligence concepts, including various forms of modeling (dimensional and relational) and warehousing strategies.

  • The ability to quickly learn and apply new technologies while considering the business needs and direction. Experience serving as the senior member on business intelligence or analytics/data warehousing projects with responsibility for design and approach decisions on projects.

  • The ability to overcome technical, political, environmental, and/or product owner related impediments to drive results.

Nice To have:

  • Familiar with working in an agile environment (using JIRA, and attending scrums)

  • Familiar with versioning software (Subversion or GitHub)

  • SAS Viya Experience

  • SAS Stored Processes familiarity

  • Scheduling SAS programs in a production environment rather than just adhoc analysis

  • Python experience

  • Demonstrated experience leading small teams to deliver business objectives.Experience in conducting technical interviews.

  • Experience implementing standards, best practices, or protocol that drives consistency and quality throughout the development lifecycle.

  • Demonstrated abilities in various forms of data modeling (dimensional and relational) and warehousing strategies.

  • Experience working with end users and customers, preferably with training and demonstrating solution capabilities.

  • Experience implementing new technological solutions in a business setting.

  • Master Data Management, Data Stewardship, or Data Governance experience.

  • Experience withbusiness operations systems, particularly those that may be in use in a Pharmacy Benefit Management setting (Claims Processing, Prior Authorization, Telephony, Membership, etc.)

  • Related industry experience.

  • Consideration will be given as to the candidate's proficiency and ability to contribute in the role based upon the following:- Professional/related publications written and/or contributed to.- Contributions to Blogs.- Technical certifications such as those offered by SAS, IBM, Microsoft.- Disciplinary certifications such as Scrum, Project Management Institute (PMI), Business Analysis.

Work Experience

Work Experience - Required:

Business Intelligence, IT

Work Experience - Preferred:


Education - Required:

A Combination of Education and Work Experience May Be Considered., Bachelors - Computer and Information Science, Bachelors - Information Technology, Bachelors - Mathematics, Bachelors - Statistics

Education - Preferred:


Certifications - Required:

Certifications - Preferred:

Potential pay for this position ranges from $80,920.00 - $129,480.00 based on experience and skills. Pay range may vary by 8% depending on applicant location.

To review our Benefits, Incentives and Additional Compensation, visit our Benefits Page ( and click on the "Benefits at a glance" button for more detail.

Prime Therapeutics LLC is an Equal Opportunity Employer and a Tobacco-free workplace . We encourage diverse candidates to apply and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, genetic information, marital status, family status, national origin, age, disability, veteran status, or any other legally protected class under federal, state, or local law. Every employee must understand, comply with and attest to the security responsibilities and security controls unique to their position; and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures .

Positions will be posted for a minimum of five consecutive workdays.

Prime Therapeutics' fast-paced and dynamic work environment is ideal for proactively addressing the constant changes in today's health care industry. Our employees are involved, empowered, and rewarded for their achievements. We value new ideas and work collaboratively to provide the highest quality of care and service to our members.

If you are looking to advance your career within a growing, team-oriented, award-winning company, apply to Prime Therapeutics today and start making a difference in people's lives.

Prime Therapeutics LLC is an Equal Opportunity Employer. We encourage diverse candidates to apply and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. If you are an applicant with a disability and need a reasonable accommodation for any part of the employment process, please contact Human Resources at 1.866.469.1257 or email