The Sr. Data Analyst-BI transforms data into meaningful insights that support business decisions, improve operational efficiency, and advance corporate strategy. The role centers on data analysis, reporting, dashboard development, semantic modeling, and effective use of modern BI platforms. Key Skills Strong Communication - Clearly convey technical findings in actionable business terms. - Basic understanding of project management and the ability to collaborate across teams. Data Analysis - Ability to interpret trends, patterns, and relationships within data. - Experience applying analytical or statistical techniques to support decisions. - Demonstrates curiosity and a drive to explore data for insights and opportunities. Data Visualization & Business Intelligence Tools - Ability to create intuitive dashboards, reports, and visualizations for varied audiences. - Hands-on experience with Power BI, including KPIs and self-service reporting. - Experience designing and optimizing data models or semantic models in Power BI or Fabric. - Familiarity with Power BI automation (Workspaces and apps, deployment pipelines, refreshes, Fabric workflows). Technical Proficiency - Strong SQL skills for querying and transforming relational data. - Proficiency in DAX and Power Query (M) for BI-focused calculations and transformations. - Solid understanding of relational databases and data modeling principles. - Ability to use Python for data preparation, automation, or advanced analysis. - Experience with generative AI tools for analysis or coding is a plus. Collaboration & Independence - Works effectively both independently and as part of cross-functional teams. Preferred education/experience: OR Required education - Bachelor’s degree in Data Analytics, Statistics, Information Systems, Business Intelligence, Applied Economics, Data Science, or a related field. - 2+ years of analytical or BI experience preferred. - 2+ years of P&C or Life/Retirement insurance industry experience preferred. - Experience with data visualization, semantic modeling, reporting, and SQL-based data manipulation. Salary Range: $76,600.00 - $106,450.00 Salary is commensurate to experience, location, etc. #VIZI #LI-LM1 Horace Mann was founded in 1945 by two Springfield, Illinois, teachers who saw a need for quality, affordable auto insurance for teachers. Since then, we’ve broadened our mission to helping all educators protect what they have today and prepare for a successful tomorrow. And with our broadened mission has come corporate growth: We serve more than 4,100 school districts nationwide, we’re publicly traded on the New York Stock Exchange (symbol: HMN) and we have more than $12 billion in assets. We’re motivated by the fact that educators take care of our children’s future, and we believe they deserve someone to look after theirs. We help educators identify their financial goals and develop plans to achieve them. This includes insurance to protect what they have today and financial products to help them prepare for their future. Our tailored offerings include special rates and benefits for educators. EOE/Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status For applicants that are California residents, please review our California Consumer Privacy Notice All applicants should review our Horace Mann Privacy Policy

Position Summary The Data Operations Analyst is a technical role responsible for ensuring the stability, accuracy, and efficiency of our core data pipelines and operational processes. This individual uses technical skills to manage data flows, troubleshoot issues, perform analysis, and support continuous improvement. This role serves as a critical link between our Data and Delivery teams, translating data into actionable insights and robust processes that support program delivery and other operations. The focus of this position is on the execution and maintenance of existing data processes and workflows. Key Responsibilities - Core Responsibilities: - - Run predefined Python scripts and notebooks in Databricks for routine tasks. - Perform regular data uploads to Salesforce using tools like Data Loader, ensuring accuracy. - Write basic SQL queries to extract data and answer routine business questions. - Handle first-tier data-related inquiries and support tickets from the Delivery team. - Assist in the documentation of operational processes. - Lead Generation Management & Support: Perform weekly manual reviews of sites to ensure pipeline replenishment. Provide ad-hoc lead generation support as requested. - Technical Pipeline Management: Oversee and troubleshoot core operational processes, including Salesforce data uploads, data quality checks in Databricks, and the execution of automated flows. - Data Quality Assurance: Proactively monitor and resolve data quality issues by running data checks, investigating anomalies, and managing data integrity across platforms. - Reporting & Support: Build and maintain reports and dashboards in Salesforce and/or BI tools (e.g., AWS Quicksight). Provide direct support to the Delivery team by handling ad-hoc analysis, data pulls, and custom reports. - Process Improvement: Document existing data processes and collaborate with technical teams to test, troubleshoot, and support the automation and enhancement of operational workflows. Key Qualifications - Bachelor's degree in a technical field or equivalent practical experience. - Strong organizational skills and high attention to detail. - Excellent communication skills with the ability to explain technical concepts. - Familiarity with Salesforce, particularly data management and reporting. - Basic understanding of SQL and data manipulation concepts. - Ability to work in a remote team environment. Location and Travel Power TakeOff is a 100% virtual company with no physical office location. However, many employees are based in two hubs in the areas around Denver, CO and Kitchener-Waterloo, Ontario. Residence in one of these two hubs is desired but not required, and relocation assistance will not be provided for the position. This position is eligible for employment in both the United States and Canada. Travel is not expected for this position. Power TakeOff will cover the associated accommodation and travel expenses for any company travel. Compensation and Benefits The total expected base salary range for employees residing in the U.S. is between $65,000 - $80,000 USD and CAD 76,200 - CAD 93,800 per year, depending on experience. Power TakeOff maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, and market conditions. - Medical insurance, including vision and dental - Health Savings Account contributions - Retirement plans with company matching - Student Loan Incentive Repayment Program (eligible 12 months after employment) - Generous time off, including: - - 15 paid vacation days, increasing to 20 after the first year - 7 flexible well-being days - At least 9 paid holidays - All company winter break between Dec. 25th and Jan. 1st - Summer "Friyays", from June through August we get each 2nd and 4th Friday off! Join our team and play a key role in driving positive impacts for our business, our customers, our utility clients, the environment, and all of society!

• Maintain, develop, and implement robust pipelines for large-scale data ingestion and transformation, in both batch and streaming, with a focus on refactoring and optimizing legacy systems. • Identify and execute refactorings in legacy data environments, aiming for continuous improvement of architecture, performance, and organization. • Define and apply data architecture standards, modeling, partitioning, versioning, security, and governance. • Evaluate and recommend technologies and frameworks, ensuring continuous evolution of the data stack. • Ensure data reliability, quality, and traceability through observability best practices, automated testing, and monitoring. • Serve as the technical point of contact for product and business stakeholders, translating strategic needs into scalable engineering solutions. • Collaborate with other disciplines (Data Analysts, Software Engineers, etc.) to integrate end-to-end solutions.

Role Description The Life Vendor Data Analyst supports the Vendor Management team by ensuring accurate vendor billing, reconciling invoices to contracted rates and underwriting requirements, and producing timely leadership reporting. This role uses business intelligence and analytics tools to identify trends, patterns, and cost drivers, and to deliver insights that inform operational and strategic decisions. In addition, the analyst provides day-to-day operational support to Life Underwriting, New Business Operations, and Distribution Partners, and contributes to continuous improvement initiatives to enhance efficiency and service level performance. What you'll do in this role - Vendor Invoicing, Reconciliation & Expense Reporting: - Oversee daily invoice intake and workflow management. - Review monthly vendor invoices and audit charges for adherence to contracted rates and terms. - Perform billing reconciliation; identify discrepancies, calculate deductions/adjustments, and determine final amounts due. - Initiate payment processing in accordance with established controls and timelines. - Maintain expense tracking and produce recurring leadership reports on spend, variances, and key drivers. - Analyze invoicing trends to validate appropriateness of submitted expenses and proactively identify savings opportunities (annual vendor budget > $8M). - Operational Vendor Support & Service Level Monitoring: - Validate rate reasonableness and confirm billed rates match contracted rates on submitted invoices. - Reconcile invoice charges to expected underwriting activity (e.g., APS/labs ordered, age/amount, and underwriting requirements) and resolve exceptions. - Maintain accurate records and data in required systems to support management reporting and decision-making. - Support development and tracking of vendor service level metrics; contribute to executive reporting packages. - Review vendor contracts and rate schedules as needed to support reconciliation and reporting. - Data Enablement & Vendor Management Dashboarding: - Normalize and transform invoice data for consistent reporting (e.g., standardizing formats, vendor line items, and policy-level mapping). - Combine invoice data with policy and underwriting data sources (e.g., nbA, MRAS, Alitheia) to enable “life-of-policy” and cost-to-serve analytics. - Support ingestion/connection of recurring Excel-based data into Snowflake and Power BI to improve automation and data quality. - Build and enhance monitoring, trending, and control reports that highlight unit cost, vendor performance, and expense-to-revenue insights. - Drive continuous refinement of dashboard definitions, documentation, and data integrity checks. - Underwriting Analysis & Trend Reporting: - Perform analysis of underwriting operations and outcomes (e.g., cycle time, approval/decline patterns, requirement ordering behaviors, guideline usage). - Identify emerging patterns and shifts that impact risk selection, operational performance, and vendor demand. - Translate findings into clear, actionable insights for underwriting and vendor management leadership. Qualifications - College degree or equivalent work experience. Background in Math, Science, Accounting, Finance, Analytics, or a related field preferred. - 2-5 years of cumulative, relevant experience. - Advanced professional expertise. Possesses functional knowledge of profession, however, is still acquiring higher level knowledge and skills for the role. Requirements - Experience with life insurance products. - Experience with PBI, & Snowflake. Benefits - Flexible full-time or hybrid telecommuting arrangements. - Plan for your future with our 401(k) plan and take advantage of immediate vesting and company matching up to 6%. - Paid time away including vacation and sick time, flex days and ten paid holidays. - Give back to your community and double your impact through our company matching.