CrawlJobs Logo

Lead Business Intelligence Analyst

United States, Florham Park · Job Posted June 01, 2026
Apply Position
Job Link Share

Job Description

This role is responsible for data aggregation, data quality, reporting, and trend analysis to evaluate program and pharmacy performance. The individual must be skilled in querying and analyzing data, while also supporting end users in interpreting and visualizing insights. Success in this role requires translating business needs into technical solutions that drive accurate and actionable reporting.

Job Responsibility

  • Translate business requirements into technical specifications to support data analysis and visualization
  • Develop a strong understanding of stakeholder objectives to create clear, impactful dashboards and reports
  • Write SQL queries and generate reports by extracting accurate data from multiple databases
  • Design and build interactive dashboards and reports using Power BI
  • Analyze data to identify trends, optimize processes, and deliver timely insights
  • Evaluate datasets for accuracy, completeness, and scope
  • explain anomalies or inconsistencies
  • Support pharmaceutical manufacturer clients with data requests, reporting, and insights
  • Aggregate data from multiple sources to support reporting needs
  • Investigate and resolve data discrepancies using SQL or statistical analysis tools
  • Manage daily reporting and trend analysis for multiple programs
  • Ensure reports meet program requirements and are delivered accurately and on time
  • Collaborate effectively with cross-functional teams to achieve shared objectives
  • Develop reporting solutions by assessing information needs, consulting with users, analyzing workflows, and following the software development lifecycle
  • Maintain compliance with all applicable healthcare data privacy regulations, including HIPAA

Requirements

  • Bachelor’s degree required
  • Information Systems or related field preferred
  • At least 2 years of experience working with pharmaceutical data in a collaborative environment
  • Advanced proficiency in Microsoft Excel (pivot tables, charts, formulas, etc.)
  • Strong experience with Power BI, including dashboard development and drill-through reporting
  • Demonstrated ability to own and resolve data investigations, preferably using SQL Server Management Studio
  • Client-facing experience with strong verbal and written communication skills
  • Excellent presentation and teamwork abilities
  • Hands-on experience with Microsoft SQL, including tables, views, stored procedures, and ad hoc queries

What we offer

  • Medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Lead Business Intelligence Analyst

8 matching positions

Lead Business Intelligence Analyst (w/ Management exp)

This role is responsible for data aggregation, data quality, reporting, and tren...
Location
Location
United States , Florham Park
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree required
  • Information Systems or related field preferred
  • At least 2 years of experience working with pharmaceutical data in a collaborative environment
  • Advanced proficiency in Microsoft Excel (pivot tables, charts, formulas, etc.)
  • Strong experience with Power BI, including dashboard development and drill-through reporting
  • Demonstrated ability to own and resolve data investigations, preferably using SQL Server Management Studio
  • Client-facing experience with strong verbal and written communication skills
  • Excellent presentation and teamwork abilities
  • Hands-on experience with Microsoft SQL, including tables, views, stored procedures, and ad hoc queries
Job Responsibility
Job Responsibility
  • Translate business requirements into technical specifications to support data analysis and visualization
  • Develop a strong understanding of stakeholder objectives to create clear, impactful dashboards and reports
  • Write SQL queries and generate reports by extracting accurate data from multiple databases
  • Design and build interactive dashboards and reports using Power BI
  • Analyze data to identify trends, optimize processes, and deliver timely insights
  • Evaluate datasets for accuracy, completeness, and scope
  • explain anomalies or inconsistencies
  • Support pharmaceutical manufacturer clients with data requests, reporting, and insights
  • Aggregate data from multiple sources to support reporting needs
  • Investigate and resolve data discrepancies using SQL or statistical analysis tools
What we offer
What we offer
  • Medical
  • Vision
  • Dental
  • Life and disability insurance
  • 401(k) plan
  • Fulltime
Read More
Arrow Right

Lead Business Intelligence Analyst - Epic Clarity

Developing SQL queries to extract data from Epic Clarity and/or Caboodle Data Wa...
Location
Location
United States , Hollywood
Salary
Salary:
Not provided
mhs.net Logo
Memorial Healthcare System
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's: Computer Science
  • Minimum of seven (7) years’ experience in a healthcare setting with experience in finance, business intelligence, or clinical systems
  • A Master’s degree with five (5) years of experience in a healthcare setting with experience in finance, business intelligence, or clinical systems in lieu of seven (7) years of experience with a Bachelor’s degree
  • High level of expertise with SQL or other database, analytics software, and BI tools
  • Knowledge of multiple Epic data models and certification in at least one Epic module plus Clarity/Caboodle Data Model Certification or proficiency
Job Responsibility
Job Responsibility
  • Developing SQL queries to extract data from Epic Clarity and/or Caboodle Data Warehouse and creating clinical reports and dashboards using Tableau or Power BI
  • Performs in a lead role to provide information to end users which helps them optimize their clinical, financial and operational results
  • Responsible for all stages of business intelligence (BI) cycle: understanding business objective, gathering business requirements and translating them into data requirements, designing and developing reports or dashboards (code and visualization), scheduling and deployment of business intelligence components in accordance with supplied standards and best practices, and completing accurate and timely documentation
  • Collaborates with business and technology departments to understand system data and its use, data analysis and validation, and providing support around the data and how it is integrated
  • Monitors production systems for issues and resolves issues or elevates them for resolution when necessary
  • Creates SQL stored procedures, views and functions using best practices and efficient code
  • Loads data into Data Warehouse by extracting complex data from multiple sources into business-centric Data Marts
  • Provides understanding of the data in the organization, performing analysis and report writing with key sets of information from the EPIC Clarity data models, data warehouses, and multiple other systems throughout the organization
  • Supports end users and organizational leadership in obtaining meaningful data, analytics, visualizations and insights to assist with decision making and improve business operations
  • Provides ongoing performance monitoring and tuning for both new and existing reporting and BI applications
  • Fulltime
Read More
Arrow Right

Senior Business Analyst, Business Intelligence Center

Drive and lead initiatives to maximize opportunities as it relates to business p...
Location
Location
United States , Houston
Salary
Salary:
Not provided
sysco.com Logo
Sysco
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in mathematics, statistics, computer science or related field
  • 5 - 8 years’ experience with hands-on data visualization design and development in large-scale and complex environments
  • Experience with SQL
  • Experience with Tableau and Tableau Server
Job Responsibility
Job Responsibility
  • Collect and analyze data for potential business expansion
  • Identify specific business opportunities
  • Influence stakeholders to support business projects
  • Define projects and partner with other teams to produce better business outcomes
  • Ensure optimization and validation initiatives are implemented, tracked and reviewed postproduction
  • Test business processes and recommend improvements
  • Review and provide feedback on technical deliverables from peer and junior analysts
  • Fix and research highly complex or difficult technical problems
  • Visualize, design and prepare data in a framework that can be utilized by served and self-serving stakeholders
  • Shape, explore and propose data for business analysis or stakeholder initiatives using core Business Intelligence (BI) tools
  • Fulltime
Read More
Arrow Right

Sr. Business Intelligence Analyst

Responsible for designing and delivering broad business intelligence analysis an...
Location
Location
United States , West Des Moines
Salary
Salary:
69324.00 - 115540.00 USD / Year
sammonsfinancialgroup.com Logo
Sammons Financial Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree in Statistics, Finance, Marketing, Computer Science or Business Preferred
  • Minimum 3 years' experience with analysis Preferred
  • Experience writing BI expressive language like DAX or SAQL Required
  • Life insurance experience Preferred
  • Demonstrated ability to perform a variety of advanced calculations and apply data to solve problems associated with the financial aspects of business
  • Ability to interpret data to help in enterprise strategic decision making
  • Self-directed, can interpret data to understand trends and derive meaningful business insights for executives with little oversight
  • Expertise in developing Tableau, Power BI or Salesforce Einstein solutions using best practices
  • Experience manipulating large data sets leveraging and Data Wrangling, pulling data from data warehouses, marts and lakes
  • Comfortable in an Agile environment
Job Responsibility
Job Responsibility
  • Lead the way in data discovery, both proactively and by request, to identify key insights and trends to help drive strategic recommendations
  • act as data expert
  • Collaborate with SME's and IT teams to turn data into critical information and knowledge that can be used to make sound business decisions
  • Work with cutting edge modern Business Intelligence (BI) Tools to deliver data visualizations and AI enhanced predictions
  • Collect and understand data to extract value and communicate it both visually and verbally to senior leaders and key stakeholders throughout the organization
  • Collaborate with partners and stakeholders to design and create user accepted dashboards. Bring value add contributions to the process of designed and authoring executive level dashboards and reports
  • Design analytics and reporting deliverables, especially around data visualization best practices and creation
  • Perform data abstraction, cleansing, validation, modeling, interpretation and reporting
  • Play an active role in business reviews, especially in reviewing analytical findings and in strategic planning discussions
  • Support the extraction of actionable information and align with business objectives. Ensure solutions meet the buss needs
What we offer
What we offer
  • Comprehensive health coverage for you and your family, including Medical, Dental, Vision, HSA & FSA options, and term life insurance
  • Competitive compensation with a performance-based incentive program tied to clear goals and individual and/or company success
  • Invest in your future with our 100% company-funded Employee Stock Ownership Plan (ESOP), plus automatic enrollment in our 401(k)
  • Work–life balance that means something. Friday afternoons off year-round, generous paid time off, and paid holidays
  • Commit to your growth with paid development time, tuition reimbursement, and professional development opportunities across industry, individual, and leadership programs
  • Make an impact beyond the workplace through volunteer time off, and our company nonprofit matching gift program, supporting the causes that matter most to you
  • An ownership culture that inspires
  • join a connected, values-driven workplace where employees take accountability, support one another, and are empowered to do their best work—together shaping our future shared success
  • Fulltime
Read More
Arrow Right

Intelligence Lead Analyst - OSINT Threat Hunting

Go beyond traditional analysis and become a proactive threat hunter at the heart...
Location
Location
United States , Charlotte; Tampa
Salary
Salary:
117440.00 - 176160.00 USD / Year
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6-10 years of relevant experience
  • Working knowledge in one or more of the following areas: Advanced Persistent Threat, Third Party Risks/Threats, Cybercrime, Extremist Groups and Cyber Terrorists, Hacktivism, Distributed Denial of Service attacks, Fraud, Malware, Mobile Threats
  • Proven track record of operationalizing cyber threat intelligence
  • Consistently demonstrates clear and concise written and verbal communication
  • Proven influencing and relationship management skills
  • Proven analytical skills
  • Bachelor’s degree/University degree or equivalent experience
  • Proficiency in the MITRE ATT&CK framework
  • Hands-on experience with Threat Intelligence Platforms including Recorded Future, Mandiant Advantage, ThreatConnect, MISP, or OpenCTI
  • Experience with scripting and automation languages including Python, PowerShell, and Bash
Job Responsibility
Job Responsibility
  • Analyze regional threat data and determine a correlation if any, to existing intelligence requirements
  • Monitor and research cyber threats with a direct or indirect impact to the Citi brand
  • Research and identify malicious activity by performing post-mortem analysis on logs, traffic flows, and other activities
  • Conduct intrusion analyses to ascertain the impact of an attack, and develop mitigation techniques for future attacks
  • Evaluate networks and programs to assess potential weaknesses and points of entry
  • Analyze and present to senior leadership discovered patterns to forecast future cyber-attacks and their potential impact
  • Liaise with intelligence communities, law enforcement, industry partners, peer financial institutions, and information sharing communities
  • Triage, process, analyze, and disseminate intelligence alerts, reports, and briefings
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
What we offer
What we offer
  • Discretionary and formulaic incentive and retention awards
  • medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays
  • Fulltime
Read More
Arrow Right
New

Senior Business Intelligence Analyst

Robert Half is partnering with an innovative organization to hire a Senior Busin...
Location
Location
United States , Beloit
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business Analytics, or a related field
  • 5+ years of experience in Business Intelligence, Data Analytics, Business Analysis, or a similar role
  • Advanced SQL skills with experience working with relational databases
  • Hands-on experience with Snowflake data modeling and modern data warehousing concepts
  • Experience building dashboards and reports in Power BI or similar BI platforms
  • Strong understanding of data modeling, ETL/ELT processes, and data quality methodologies
  • Excellent analytical, organizational, problem-solving, and communication skills
  • Experience managing projects and collaborating with both technical and non-technical stakeholders
  • This position requires U.S. citizenship
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable data models, data warehouses, and ETL/ELT pipelines using Snowflake
  • Build reliable data validation processes including reconciliation, record count validation, anomaly detection, and other data quality controls
  • Write and optimize advanced SQL queries to support reporting, analytics, and business intelligence initiatives
  • Develop interactive dashboards and reports using Power BI or similar visualization platforms
  • Translate business requirements into technical data solutions that provide meaningful insights
  • Partner with stakeholders across multiple business functions to gather requirements and deliver BI solutions
  • Lead Business Intelligence projects from planning through implementation, including documentation, timelines, and stakeholder communication
  • Establish and promote BI best practices, governance standards, and data visualization strategies
  • Provide end-user training, support, and guidance to encourage adoption of reporting and analytics tools
  • Identify opportunities to improve reporting processes, data accessibility, and overall analytics capabilities
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • company 401(k) plan
  • Fulltime
Read More
Arrow Right

Business Intelligence Analyst

The Digital Planning Transformation program is a global initiative designed to m...
Location
Location
Mexico , Miguel Hidalgo
Salary
Salary:
Not provided
pepsico.com Logo
Pepsico
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience in management and performance reporting
  • Strong ability to translate business requirements into scalable reporting and dashboard solutions
  • Experience with data and systems management in a financial or performance reporting environment
  • Advanced technical proficiency in Tableau
  • Strong Excel skills for analysis, modeling, and reporting
  • 0–1 year of professional experience in finance, analytics, reporting, or a related field
  • Advanced English
Job Responsibility
Job Responsibility
  • Partner with Operating Units and Functions to gather and clarify reporting requirements
  • Design and develop end-to-end financial performance dashboards with drill-down capabilities
  • Build and deploy standardized reporting frameworks and harmonized dashboards
  • Continuously enhance and evolve dashboards, tools, and systems to improve usability and performance
  • Proactively identify improvement opportunities and lead the implementation of enhancements
  • Collaborate closely with S&T teams to ensure business requirements are accurately translated into Cockpit designs
  • Analyze how end-users (analysts and senior leaders) consume data and tailor solutions accordingly
  • Deliver new dashboard features and improve user experience and system performance
  • Ensure financial data security, compliance, and alignment with corporate and sector FP&A standards
  • Support training and enablement of Cockpit users
What we offer
What we offer
  • Opportunities to learn and develop every day through a wide range of programs
  • Internal digital platforms that promote self-learning
  • Development programs according to Leadership skills
  • Specialized training according to the role
  • Learning experiences with internal and external providers
  • Recognition programs for seniority, behavior, leadership, moments of life, among others
  • Financial wellness programs that will help you reach your goals in all stages of life
  • A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle
  • Wellness Line
  • thousands of Agreements and Discounts
Read More
Arrow Right

Business Intelligence Analyst

***CANDIDATE MUST BE US Citizen (due to contractual/access requirements)*** The ...
Location
Location
United States , Working at Home
Salary
Salary:
68400.00 - 105900.00 USD / Year
wv.highmarkhealthoptions.com Logo
Highmark Health Options
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree in Math, Computer Science, Analytics, Engineering, Information Science or related field
  • 3 years directly related work experience
  • Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access
  • Basic understanding of SQL / querying capabilities
  • Experience with Oracle Cloud Business Intelligence, OTBI, BI Publisher, OACs, FRS, Smartview
  • Familiarity with the Software Development Lifecycle Process and Project Management Lifecycle
  • Strong written and verbal communication skills
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Effective participation in team-based work
  • Ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture
Job Responsibility
Job Responsibility
  • Elicit, analyze, document, and validate business requirements through interviews, workshops, and existing documentation
  • Create detailed process flows, use cases, and user stories to clearly define system and process changes
  • Collaborate with stakeholders to prioritize requirements and ensure alignment with business goals
  • Identify opportunities for process improvement and automation
  • Extract, transform, and load (ETL) data from various sources, including Salesforce
  • Perform data analysis to identify trends, patterns, and insights that support business decisions
  • Develop and maintain reports and dashboards using data visualization tools
  • Ensure data quality and accuracy
  • Customize and configure Salesforce to meet specific business needs (e.g., workflows, validation rules, custom objects)
  • Develop simple scripts in Python to automate data processing, system integration, or reporting tasks
  • Fulltime
Read More
Arrow Right