Business Intelligence Analyst

West Point Underwriters; Florida; On-site; USD 75,000 - 105,000; Full time

Benefits offered by this job

Medical, Dental and Vision benefits

401k with company match

Generous PTO

Onsite gym

Casual dress

Job summary

TJ Jerger MGA, LLC is seeking a Business Intelligence Analyst to design, develop, and maintain data solutions. The role focuses on transforming complex data into meaningful insights, dashboards, and KPIs to support operations and strategic decisions.

The ideal candidate has strong SQL, Python or R skills, advanced Excel, and experience building BI dashboards with Power BI, Tableau, or Domo. Collaboration with stakeholders is essential, with emphasis on data integrity and governance.

Qualifications

• Bachelor's degree in a relevant field or equivalent experience.
• Strong SQL and database querying skills.
• Experience with Python, R, or similar for data analysis.
• Advanced Excel including formulas, pivots, lookups, automation.
• Experience building dashboards with Power BI, Tableau or Domo.
• Ability to work with large, multi-source datasets and derive insights.

Responsibilities

• Design, develop, and maintain data solutions supporting operations and decisions.
• Transform data from multiple sources into reports, dashboards, and metrics.
• Collaborate with stakeholders to gather reporting requirements and ensure data integrity.
• Identify trends and opportunities using statistical techniques.
• Create and optimize dashboards and data files for stakeholders.
• Test, validate, and document data processes and reports.
• Recommend process improvements for reporting, governance, and efficiency.
• Leverage AI and innovative tech to boost productivity.

Skills

SQL

Python

R

Excel

Data visualization

Analytical thinking

Education

Bachelor's degree in Data Analytics/CS/IS/Stats/Math/Business or related field

Tools

Power BI

Tableau

Domo

Job description

Description

T.J. Jerger MGA, LLC. is growing and we are in search of an Business Intelligence Analyst to join our team!

The Business Intelligence Analyst is responsible for designing, developing, and maintaining data solutions that support business operations and strategic decision-making. Transforming complex data from multiple sources into meaningful insights, reports, dashboards, and performance metrics. The Business Intelligence Analyst works closely with business stakeholders to understand reporting requirements, ensure data integrity, identify trends, and provide actionable recommendations through advanced analytics, data modeling, and visualization techniques.

Who are we?

Started in 2006, TJ Jerger is the Managing General Agency for American Traditions Insurance Company, the largest writer of manufactured home insurance in Florida. T.J. Jerger and ATIC are part of the Jerger family of companies.

Why work with us?

We are a family-oriented organization committed to providing competitive compensation and benefits packages to our employees including:

• Medical, Dental and Vision, Life and supplemental benefits starting day 1 of employment!
• Multiple plans to choose from in order to fit your needs
• 401k plan participation is available the 1st quarter after hire with 100% match of 3% and then 50% on the next 2%...fully vested!
• Generous PTO and paid holiday schedule
• 1 day of paid volunteer time off per year
• Onsite workout facility
• Casual dress code (work appropriate)
• 37.5 hour work weeks with great work/life balance as our goal!

What will you be doing?

• Implement data standards and best practices to ensure consistency, accuracy, and reliability across reporting and analytics processes
• Develop and deploy automation solutions to extract, transform, synthesize, validate, and integrate data from multiple sources
• Monitor data quality and integrity, proactively identifying and resolving data discrepancies, system issues, and database-related concerns
• Analyze complex datasets using statistical techniques to identify trends, patterns, correlations, and business opportunities.
• Utilize programming and analytical tools such as Python, R, SQL, Excel, Power BI, Domo and business intelligence platforms to design, develop, maintain and enhance reports, dashboards, visualizations, and data files of varying complexity that provide actionable insights to stakeholders
• Test and validate new or modified reports, datasets, dashboards, and analytical solutions to ensure accuracy, functionality, and data integrity
• Collaborate with business leaders, and stakeholders to gather requirements, define objectives, and translate business needs into technical solutions
• Document data processes, reporting methodologies, business rules, and technical specifications.
• Recommend and implement process improvements that enhance reporting capabilities, operational efficiency, and data governance practices
• Leverage Artificial Intelligence and innovative technologies to enhance efficiency, streamline processes, and improve overall productivity

Requirements

The Ideal Candidate will possess:

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Business Administration, or a related field; or equivalent combination of education and experience.
• Advanced proficiency in SQL and database querying.
• Experience utilizing Python, R, or similar scripting languages for data analysis and automation.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, lookups, data manipulation, and reporting automation.
• Experience developing dashboards and data visualizations using Power BI, Tableau, Domo or similar BI tools.
• Experience working with large, complex datasets from multiple sources.
• Strong analytical and critical-thinking skills with the ability to transform complex data into actionable business insights.
• Knowledge of data modeling, data warehousing concepts, and database structures.
• Ability to identify trends, patterns, anomalies, and opportunities within large datasets.
• Excellent written and verbal communication skills with the ability to present technical information to both technical and non-technical audiences.
• Strong problem-solving and troubleshooting abilities.
• Resourceful and innovative in diagnosing and resolving technical and business challenges.
• Ability to manage multiple priorities and projects while maintaining attention to detail and accuracy.
• Strong collaboration skills with the ability to build effective relationships across departments and organizational levels

Additional information:

This is an in office position and our offices are located in Pinellas Park, FL.

Our typical office hours are 8:30am - 5:00pm Monday - Friday.

Physical Requirements:

This position is in an office environment and would require:

• Ability to sit for extended periods while working at a desk or computer.
• Ability to stand, walk, and move throughout the office as needed for meetings and collaboration.
• Constantly operates a computer, keyboard, mouse, and other office technology.
• Ability to communicate verbally and in writing with colleagues, clients, and leadership.
• Ability to occasionally lift or move light office materials (e.g., files, binders, laptops) up to 15 pounds.

T.J. Jerger MGA, LLC is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.