Business Intelligence Analyst III
Guardian Life · Bethlehem, PA · 2 days ago
Hybrid$69k–$113k/yrFull-time
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 and Schedule
The primary location for this position is remote. Travel up to 10% within the US.
Pay
$68,970.00 - $113,310.00