Guardianlife

Business Intelligence Analyst III

BethlehemFull timeMid$68,970 - $113,310 / yearPosted 19 days ago
Apply on Guardianlife →

Sign into see who you know at Guardianlife.

Job SummaryThe 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 ResponsibilitiesCreate 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 QualificationsExperience 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 busi...