Business Reporting Analyst II

Assurant•Lewisville, TX

3d•$56,200 - $94,100•Hybrid

About The Position

The Business Reporting Analyst designs, builds, and maintains operational and management reports for US depot operations. The role gathers, organizes, and documents requirements, performs system and data analysis, and develops reporting solutions based on those requirements. It also provides production reporting support and works to accommodate customers’ business needs while maintaining positive customer relationships through strong communication and coordination. The analyst must be able to explain technical concepts in non-technical terms to non-technical constituents. The analyst provides technical guidance and mentoring in areas of acquired expertise, develops subject-matter expertise, and regularly produces reports for internal and external customers and clients. The role supports data and report automation to improve the efficiency of profitability analysis, analyzes variances in key metrics, and identifies risks and opportunities early. It measures established KPIs and recommends actions to improve performance. The analyst collaborates with internal customers to improve existing reports or develop new ones and proposes improvements to reporting systems. This is a hybrid role based at the Lewisville, Texas, or Mt. Juliet, Tennessee, facility, with on-site work 2–3 days per week. The stated pay range is $56,200–$94,100.

Requirements

At least 3 years of experience working as a reporting analyst with SQL and Excel in a professional environment.
Bachelor’s degree in Computer Information Systems or a related field.
Advanced PC knowledge.
Intermediate or advanced Excel knowledge, including pivot tables and VLOOKUPs.
Intermediate or advanced knowledge of SQL, SSRS, Power BI, SSMS, and Oracle SQL Developer.
Strong mathematical, analytical, and statistical skills.
Professional, friendly, and courteous demeanor when working with teammates and business partners.
High degree of integrity and ability to exercise sound judgment.
Complex problem-solving skills.
Ability to deliver results on time.
Ability to prioritize and manage multiple tasks and assignments.

Nice To Haves

At least 2 years of experience with visual tools such as Power BI or Tableau is desired.
Advanced Excel macros knowledge is a plus.

Responsibilities

Design, build, and maintain operational and management reports for US depot operations.
Gather, organize, and document requirements; perform system and data analysis; and develop reporting solutions based on requirements.
Provide production reporting support.
Accommodate customers’ business needs and maintain positive customer relationships through strong communication and coordination.
Communicate technical concepts in non-technical terms to non-technical constituents.
Provide technical guidance and mentoring in areas of acquired expertise and develop subject-matter expertise.
Produce internal and external customer and client reports.
Automate data and reporting to improve the efficiency of profitability analysis.
Analyze variances in key metrics and identify risks and opportunities early.
Measure established KPIs and recommend alternative courses of action to improve performance.
Collaborate with internal customers to improve existing reporting or develop new reporting.
Propose methods and ideas to improve reporting systems.