AgencyKPI, Inc.: Business Data Analyst

Come Join Us.About AgencyKPI:AgencyKPI is a Midwest Insurtech company that provides a business intelligence platform for insurance networks, independent agencies, and insurers.The people at AgencyKPI are an unparalleled combination of experienced insurance industry leaders along with exceptional data scientists, software developers and business strategists, and we are looking for the right people with the right skills to join us.During a time when most Insurtech companies claim that disruption is the path to the future, AgencyKPI is developing software platforms that support Harmony, Understanding, and Balance between all partners and vendors in the insurance industry.

Why this approach?

Because we have a fundamental belief that insurance agencies, networks, carriers, and wholesalers desire to deepen their relationships through mutual understanding and the harmonizing and balancing of their collective efforts.Culture:We are remote first company with employees located in various regions throughout the Midwest.

We were Ranked by the Austin Business Journal in 2020 as one of the Top 10 Best Places to Work, because we strive to understand the working styles of all our employees to ensure that our “Ways of Working” best serve all of us collectively and as individuals.

Our core values of Integrity, Innovation and Delivery guide us individually and as a team to work together in a cohesive manner to define and drive our organizational success.

We are seeking talented individuals who share these values and want to make a direct impact to the insurance industry.What is the role?As a Business Intelligence Data Analyst, you will analyze complex business problems using data to provide insight to decision makers and client stakeholders.

The day-to-day responsibilities will include identifying, retrieving and consolidating datasets from various data sources, and building advanced data visualization on commercial BI platform (Power BI, Tableau, etc.) based on the datasets for our customers to monitor business, optimize operations, and discover new opportunities.

Additionally, you will use your SQL and Python skills to create on-demand reports, conduct data auditing tasks, identify data issues, and communicate with the team to determine the cause of issues and resolve them.

AgencyKPI thrives by finding the right people, aligning them on the right teams, with the right tools to solve the hard customer problems which align with our Mission/Vision/Values.What you’ll do on a daily basis:Develop BI solutions (reports, dashboards and applications) in Power BI for customers’ insurance production data setsDevelop internal Python-based tools that integrate data from multiple systems forconsumption or integration with other systemsExtract ad-hoc data from various sources, and perform complex, detailed analyses inof applicable projects and/or on-demand business needsExtract ad-hoc data from various sources, and perform complex, detailed analyses in support of applicable projects and/or on demand business needs What background should you have?Bachelor’s degree in Business, Statistics, Information System, Computer Science, Mathematics or a related field2 years of experience working in data analysis and data visualizationProficiency in dashboard creation using Power BI or Tableau or similar toolsExperience in configuration of Power BI or similar tools for user authentication, integration with other systems, customization, automation, etc.Hands-on experience in developing SQL queriesFamiliar with Python and its libraries (e.G., Pandas).

Practical knowledge of Plotly, Streamlit a plusAdvanced Excel skills desiredAbility to collaborate and work as part of a teamAbility to communicate effectively with internal stakeholders and customersCapable of prioritizing multiple projects while still achieving deadlinesEagerness to learn new skills in a rapidly changing work environmentHave a can-do and get-it-done attitudeExperience in insurance or finance industry is a plusCertificate in PL-300 (formerly DA-100) ” MS Power BI Data Analyst” is a plusWhat do we offer?

Competitive compensation package Earn the opportunity to enjoy an equity position Generous health, dental and vision insurance package that covers employee, spouse, anddependents Instantly vesting 401k with company match Getting to work with an incredibly talented team, in a rapidly scaling company, with unmatched industry buy-in

Related Post