Business Intelligence Analyst III

Guardian Life; Bethlehem (Northampton County); Hybrid; USD 69,000 - 113,000; Full time

Job summary

Guardian Life in Bethlehem, PA is seeking a Level III Business Intelligence Analyst to lead BI workstreams, translate business needs into data-driven solutions, and deliver accurate reporting and analytics. You will partner with cross-functional stakeholders to gather requirements, design BI solutions, establish standards, and support data quality.

You will develop complex SQL queries, create dashboards with Tableau or Power BI, mentor teammates, and drive best practices for reporting and data

Qualifications

• Experience developing, maintaining, and improving BI reports, dashboards, metrics, and analytical solutions.
• Strong SQL skills with complex queries, database objects, functions, joins, indexing concepts, and performance considerations.
• Deep understanding of BI tools, reporting functionality, data visualization principles, and how business users consume analytics.
• Ability to gather and translate business requirements into clear technical and analytical deliverables.
• Experience leading internal workstreams, managing multiple priorities, and influencing stakeholders on sequencing and prioritization.
• Experience validating data, creating test scenarios, executing test plans, and ensuring high-quality deliverables.
• Ability to identify patterns, trends, correlations, anomalies, and business implications from complex data.
• Strong communication skills with the ability to explain metrics, findings, recommendations, and data limitations to technical and non-technical audiences.
• Experience mentoring peers or team members on BI processes, reporting standards, data interpretation, or tool usage.

Responsibilities

• Create visualizations that support quick consumption, collaboration, exploration, transparency, and storytelling with information.
• Train end users on reports, dashboards, patterns, and anomalies, and mentor internal team members on processes, policies, procedures, and BI practices.
• Analyze business problems, develop models, and provide insights that help explain trends, patterns, anomalies, and business performance.
• Recommend key performance indicators for multiple business units and explain how metrics are calculated and used.
• Lead BI project workstreams, including requirements gathering, scope development, technical design, development, testing, and delivery.
• Create and maintain templates, development standards, reporting standards, and visualization standards for team use.
• Partner with IT and business stakeholders to design BI solutions that support operational decision-making and business strategy.
• Develop and optimize complex SQL queries using views, stored procedures, table-valued functions, subqueries, indexing concepts, execution plans, and multiple databases.
• Apply deep knowledge of relevant databases, data structures, and business data sources to deliver accurate and trusted reporting products.
• Influence business partners on BI best practices, report design, data interpretation, and prioritization of work.
• Lead testing scenario creation and execution, audit work for accuracy, and ensure delivered products meet high data quality standards.
• Research new BI technologies, interface with vendors, participate in vendor evaluations, and recommend tools or approaches that improve analytics capabilities.

Skills

SQL

BI tools

Tools

Tableau

Power BI

Alteryx

Job description

Business Intelligence Analyst III# Careers## Business Intelligence Analyst IIIApply: Hybrid - In office 3 days per week: Bethlehem: Full time: Posted Yesterday: R000110521**Job Summary**The Level III Business Intelligence Analyst is responsible for leading business intelligence workstreams, translating business needs into data-driven solutions, and delivering accurate, reliable, and actionable reporting and analytics. This role partners closely with business and technology stakeholders to gather requirements, design BI solutions, establish standards, support data quality, and help business partners use information to identify trends, patterns, risks, and opportunities.**Key Responsibilities*** Create visualizations that support quick consumption, collaboration, exploration, transparency, and storytelling with information.* Train end users on reports, dashboards, patterns, and anomalies, and mentor internal team members on processes, policies, procedures, and BI practices.* Analyze business problems, develop models, and provide insights that help explain trends, patterns, anomalies, and business performance.* Recommend key performance indicators for multiple business units and explain how metrics are calculated and used.* Lead BI project workstreams, including requirements gathering, scope development, technical design, development, testing, and delivery.* Create and maintain templates, development standards, reporting standards, and visualization standards for team use.* Partner with IT and business stakeholders to design BI solutions that support operational decision-making and business strategy.* Develop and optimize complex SQL queries using views, stored procedures, table-valued functions, subqueries, indexing concepts, execution plans, and multiple databases.* Apply deep knowledge of relevant databases, data structures, and business data sources to deliver accurate and trusted reporting products.* Influence business partners on BI best practices, report design, data interpretation, and prioritization of work.* Lead testing scenario creation and execution, audit work for accuracy, and ensure delivered products meet high data quality standards.* Research new BI technologies, interface with vendors, participate in vendor evaluations, and recommend tools or approaches that improve analytics capabilities.**Required Qualifications*** Experience developing, maintaining, and improving business intelligence reports, dashboards, metrics, and analytical solutions.* Strong SQL skills, including experience with complex queries, database objects, functions, joins, indexing concepts, and performance considerations.* Deep understanding of BI tools, reporting functionality, data visualization principles, and how business users consume analytics.* Ability to gather and translate business requirements into clear technical and analytical deliverables.* Demonstrated ability to lead internal workstreams, manage multiple priorities, and influence stakeholders on sequencing and prioritization.* Experience validating data, creating test scenarios, executing test plans, and ensuring high-quality deliverables.* Ability to identify patterns, trends, correlations, anomalies, and business implications from complex data.* Strong communication skills with the ability to explain metrics, findings, recommendations, and data limitations to technical and non-technical audiences.* Experience mentoring peers or team members on BI processes, reporting standards, data interpretation, or tool usage.**Preferred Qualifications*** Experience supporting multiple business units or cross-functional reporting initiatives.* Experience with BI platforms such as Tableau, Power BI, or similar visualization and dashboarding tools.* Experience with Data Blending tools such as Alteryx, DataIku, Informatica, Snaplogic, or similar.* Experience researching, evaluating, or recommending new reporting, analytics, or data technology capabilities.* Understanding of data security processes, dashboard access, database access, and related ticketing or access request workflows.* Familiarity with advanced analytics concepts and how predictive or prescriptive analytics can support business decision-making.**Core Competencies*** Technical proficiency in SQL, BI tools, reporting standards, data validation, and dashboard development.* Business acumen with the ability to recommend KPIs, understand business unit needs, and connect analysis to strategic priorities.* Analytical thinking with the ability to research business problems, create models, and deliver meaningful insights.* Process improvement mindset with the ability to create standards, lead internal workstreams, and improve reporting practices.* Stakeholder influence with the ability to guide business partners on best practices, prioritization, and effective use of data.* Mentorship and knowledge sharing to strengthen team capability and promote consistent BI practices.**Location Vaccination Requirements:*** The primary location for this position is remote.* Covid 19 vaccinations required for this position.Any offer of employment will be contingent upon the candidates affirmation of being Full Vaccinated prior to commencing employment in the new role. New hires will have five business days from their start date to provide proof of vaccination through our Vaccination Status Confirmation Form. Fully Vaccinated means that at least two weeks have elapsed since you received the recommended number of doses of any COVID-19 vaccine that is currently fully approved, or authorized for emergency use, by the Food and Drug Administration or that have been listed for emergency use by the World Health Organization. If an applicant is unable to be vaccinated due to a medical condition or a sincerely held religious belief, practice or observance, Guardian may provide reasonable accommodations. This policy may not apply to any Guardian colleagues working in a local jurisdiction (state, county, or city) that implements a law prohibiting a private employer from requiring vaccination, unless there is an applicable vaccine mandate from the federal government that would supersede the vaccination laws of the local jurisdiction. Guardian, in its sole discretion, may modify or terminate this requirement at any time. **Travel*** up to 10% Travel within the US.**Salary Range:**$68,970.00 - $113,310.00The salary range reflected above is a good faith estimate of base pay for the primary location of the position. The salary for this position ultimately will be determined based on the education, experience, knowledge, and abilities of the successful candidate. In addition to salary, this role may also be eligible for annual, sales, or other incentive compensation. **Our Promise** At Guardian, you’ll have the support and flexibility to achieve your professional and personal goals. Through skill-building, leadership development and philanthropic opportunities, we provide opportunities to build communities and grow your career, surrounded by diverse colleagues with high ethical standards. **Inspire Well-Being** As part of Guardian’s Purpose – to inspire well-being – we are committed to offering contemporary, supportive, flexible, and inclusive benefits and resources to our colleagues. Explore our company benefits at www.guardianlife.com/careers/corporate/benefits. *Benefits apply to full-time eligible employees. Interns are not eligible for most Company benefits.* **Equal Employment Opportunity** Guardian is an equal opportunity employer. All qualified applicants will be considered for employment without regard to age, race, color, creed, religion, sex, affectional or sexual orientation, national origin, ancestry, marital status, disability, military or veteran status, or any other classification protected by applicable law. **Accommodations** Guardian is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. Guardian also provides reasonable accommodations to qualified job applicants (and employees) to accommodate the individual's known limitations related to pregnancy, childbirth, or related medical conditions, unless doing so would create an undue hardship. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [e-mail]. Please note: this resource is for accommodation requests only. For all other inquires related to your application and careers at Guardian, refer to the Guardian Careers site. **Visa Sponsorship** Guardian Life is not currently or in the foreseeable future sponsoring employment-based visas (e.g., such as an H-1B). In order to be a successful applicant, you must be legally authorized to work in the United States, without the need for employer sponsorship/support now or at any time in the future. **Notice Regarding Guardian’s Use of Artificial Intelligence in Recruitment** As part of Guardian’s job application process, Guardian may use artificial intelligence tools (“AI Tools\") to automate the sorting and filtering of information provided by applicants as part of its preliminary screening. This preliminary screening may be used to help identify applicant materials and resumes relative to their indication that the applicant meets the requirements for the specific job for which they are applying, as specified in the listing posted on Guardian’s jobs website (Careers at Guardian at https://www.guardianlife.com/careers). At Guardian, we do not use AI Tools to substantially assist or replace human judgment or discretionary decision making in our hiring process. All hiring decisions will be made by Guardian colleagues. Please be aware that if you apply for a specific position with Guardian, you will have the choice of opting out of Guardian’s use of AI Tools during the job application process. If you would like to request an alternative process that does not utilize AI Tools or would like to request a reasonable accommodation, within ten business days of your position application, you must email your request to [e-mail], making sure to provide your name and job requisition identification number. Guardian will retain your applicant materials and resume and all information therefrom in accordance with Guardian’s document retention policy, a copy of which you may request via [e-mail], at applicable times, Guardian will make public the most recent bias audit results for such AI tools, which may be found here. **Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday.**### About GuardianEvery day, Guardian helps our 29 million customers realize their dreams through a range of insurance and financial products and services. Our Purpose, to inspire well-being, guides our dedication to the colleagues, consumers, and communities we serve. We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com.