Business Analyst

Key Responsibilities Data Analysis & Models Gather, clean, and analyze complex data from various sources. Design complex data models and methodologies. Proactively identify trends, risks, and opportunities through data analysis. Partner with data engineering and architecture teams on data design decisions. Provide complex data & analysis to internal teams and external consultants, auditors, and vendors. Insights Write advanced SQL queries and calculations. Translate ambiguous business problems into analytical approaches and insights. Analyze complex data to draw conclusions and inform decision making. Communicate insights to Director-level stakeholders. KPI/Metrics Partner with Director-level stakeholders to define and document KPIs & metrics. Develop corporate KPIs & metrics. Prepare, deliver, and support corporate KPIs & metrics. Reports & Dashboards Lead the design and delivery of complex, high-impact interactive dashboards and reports. Prepare, deliver, and support business critical reports. Document report definitions, metrics, and refresh processes. Enhance complex report delivery through automation. Work with Director-level stakeholders to understand needs to define and deliver BI solutions. Participate in large scale cross-functional projects that require BI input. Mentor analysts and review analytical work for quality and consistency. Education and Experience BA/BS in analytics, mathematics, information systems, business or related discipline; advanced degree preferred. 5-8 years of experience in BI, analytics, or data roles. Competencies (Knowledge, Skills and Abilities) Advanced SQL knowledge. Advanced level in at least one BI tool and data visualizations (e.g., Power BI, Tableau). Knowledge of MS Office suite including advanced level in MS Excel. Advanced understanding of databases (e.g. SQL Server) and data structures. Solid understanding of data modeling concepts and KPI design. Advanced problem solving and analytical skills. Strong ability to gather, synthesize and analyze information from multiple systems. Proven ability to influence stakeholders and guide decision-making. Strong business acumen and strategic mindset. Excellent interpersonal, communication, listening and presentation skills. Knowledge of health, disability, and retirement benefits, preferred. Sets clear goals and objectives, cooperates and participates fully in the coaching process, and actively seeks continuous learning to improve their own and team performance. Self-motivated with the ability to effectively prioritize and execute tasks effectively with minimal supervision; maintains focus on organizational goals. Participates fully on assigned and adjunct teams, fosters a collaborative spirit, builds collaborative networks with internal staff and vendor representatives. #J-18808-Ljbffr Stellar IT Solutions LLC