What You'll Do We’re looking for a Business Intelligence Analyst to join our Data and Analytics Consulting Team. In this role, you’ll make key data & metrics easily consumable for data-driven decision-making and consult directly with Benefits & Protection leadership to fine-tune our analytics solutions. You'll capture, format, and present data and business context to build meaningful numeric and graphical summaries and function as a data domain expert, establishing data standards & requirements with data engineers. You’ll have the opportunity to: Provide insight into key business metrics through the creation of durable data pipelines and compelling data visualization for business leaders and partners aligned to our Benefits & Protection business unit strategic goals, specifically within the Customer Onboarding and Underwriting areas Research, analyze, and validate the primary source(s) for definitive data and completeness to feed metrics associated with Benefits & Protection Develop proactive data strategies and present recommendations to key partners regarding internal and 3rd party data, including sales, customer, operations, and claims data Build and maintain sophisticated Business Intelligence reporting platforms to support insightful decision making for leaders across Benefits & Protection Actively participate in project teams to thoroughly develop and maintain processes or systems in accordance with scheduled target dates. This may include partnering closely with Data Engineers, Data Analysts, Data Scientists, Analytics Consultants, and Product Managers as well as key business stakeholders and subject matter experts As Principal continues to modernize its systems, this role will offer you an exciting opportunity to build solutions that will directly impact our long-term strategy and tech stack, all while ensuring that our products are robust, scalable, and secure! Operating at the intersection of financial services and technology, Principal builds financial tools that help our customers live better lives. We take pride in being a purpose-led firm, motivated by our mission to make financial security accessible to all. Our mission, integrity, and customer focus have made us a trusted leader for more than 140 years! Who You Are Bachelors degree or Associate's degree with 2+ years of experience, ideally in analytics, consulting, or project management, though other relevant experience will be considered Experience using dedicated business intelligence applications and/or cloud services (e.g., PowerBI, Tableau, SQL, Salesforce, etc.) Experience writing and troubleshooting SQL queries Excellent problem solving, analytical, math, and statistical skills and demonstrates the ability to identify and resolve complex problems Ability to coach and review work of peer team members Skills That Will Help You Stand Out Power BI AWS Athena Snowflake Oracle DB2 Power Automate Business area domain knowledge with insurance products Salary Range Information Salary ranges below reflect targeted base salaries. Non-sales positions have the opportunity to participate in a bonus program. Sales positions are eligible for sales incentives, and in some instances a bonus plan, whereby total compensation may far exceed base salary depending on individual performance. Actual compensation for all roles will be based upon geographic location, work experience, education, licensure requirements and/or skill level and will be finalized at the time of offer. Salary Range (Non-Exempt expressed as hourly; Exempt expressed as yearly) $71250 - $95950 / year Time Off Program Flexible Time Off (FTO) is provided to salaried (exempt) employees and provides the opportunity to take time away from the office with pay for vacation, personal or short-term illness. Employees don’t accrue a bank of time off under FTO and there is no set number of days provided. Pension Eligible Yes Additional Information Hours This role will partner with our global teams and has an expectation for flexibility in your work schedule to have occasional start times around 7am CST. Work Environments This role offers an in-office and hybrid (blending at least three office days in a typical workweek) work arrangement in Des Moines, IA. Work Authorization/Sponsorship At this time, we're not considering applicants that need any type of immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States. This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc. For additional information around work authorization needs please use the following links. Nonimmigrant Workers and Green Card for Employment-Based Immigrants Investment Code of Ethics For Principal Asset Management positions, you’ll need to follow an Investment Code of Ethics related to personal and business conduct as well as personal trading activities for you and members of your household. These same requirements may also apply to other positions across the organization. Experience Principal At Principal, we value connecting on both a personal and professional level. Together, we’re imagining a more purpose-led future for financial services – and that starts with you. Our success depends on the unique experiences, backgrounds, and talents of our employees. And we support our employees the same way we support our customers: with comprehensive, competitive benefit offerings crafted to protect their physical, financial, and social well-being. Check out our careers site to learn more about our purpose, values and benefits. Principal is an Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Posting Window We will accept applications for 3 full days following the Original Posting Date, after which the posting may remain open or be removed based upon applications received. If we choose to post the job again, we will accept additional applications for at least 1 full day following the Most Recently Posted Date. Please submit applications in a timely manner as there is no guarantee the posting will be available beyond the applicable deadline. Original Posting Date 9/6/2024 Most Recently Posted Date 10/15/2024