Business Intelligence Specialist (Power BI Developer)

Business intelligence, Dashboard, Data visualization, Microsoft Power BI, Reporting, Alteryx, Business Objects, Functional requirements, Documentation, Data QA
Full Time
Up to $105,000
Travel not required

Job Description

PURPOSE OF THE JOB

The purpose of this job is to work closely with business leaders and provide quantitative and qualitative data analysis and reporting of patterns, insights, and business trends.  This position will complete analysis of various data sources and structures in support of Business and IT teams to meet the business and financial goals of the Company.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Collects and aggregates data from multiple internal and external sources for analyses to drive insights into business performance

  • Aggregates large, complex data sets from multiple databases and creates insight reports and dashboards.
  • Collaborates with appropriate parties within the organization to integrate new data sources into our existing data infrastructure.
  • Delivers complex and actionable reports that show key performance indicators, identifies areas of improvement into current operations, and displays root cause analysis of problems. 

Provides quantitative and qualitative data analysis of patterns, insights, and trends to decision-makers

  • Collaborates in cross-functional teams to implement analytical solutions.
  • Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team.
  • Analyzes current business processes; makes recommendations to management for new, more efficient, workflows, and processes.
  • Uses and presents analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives. 

Provides reporting solutions and responds to report requests across multiple business areas and for complex enterprise wide projects

  • Collaborates with team members and leaders across the organization to identify and understand business problems and processes.
  • Enhances and develops analytical and reporting solutions to solve business problems and extract insights.
  • Enhances and supports enterprise-wide strategies, processes, and standards for business intelligence and reporting.
  • Delivers complex functional specifications and system design specifications for assigned projects. 

Performs as a subject matter expert for the department.

  • Trains staff on project deliverables and acts as a resource for colleagues in the department to answer questions and solve complex problems.
  • Conceptualizes and proposes reporting solutions to business leaders throughout the organization.
  • Provides training materials, documentation, and suggestions to Enterprise Data Analytics leadership staff concerning data analysis and reporting.
  • Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team.
  • Develops functional specifications and reporting design specifications for assigned projects.
  • Uses and presents analytics and metrics to improve processes and provides data-driven forecasts of potential costs, risks, and profits of business initiatives. 

SUPERVISORY RESPONSIBILITIES

This role does not have supervisory responsibilities. 

EDUCATION AND EXPERIENCE

Bachelor's degree from a college or university required in a quantitative field such as Statistics, Math, Economics, or Computer Science. Minimum 5 years of technical experience in analytics, data science, actuarial or equivalent quantitative field required.  Minimum 3 years of experience with SQL, Power BI, and SAP Business Objects BI required.  Minimum 3 years of experience programming with Alteryx or other ETL tools preferred.  

CERTIFICATES, LICENSES, REGISTRATIONS

None required. 

KNOWLEDGE AND SKILLS

Demonstrated experience with data visualization tools, such as Power BI, is required. Working knowledge of analytics, data science and/or actuarial, required.   Experience with SQL and SAP Business Objects BI tools (Webi, Crystal, Explorer, Dashboards, etc.), required.  Strong analytical and problem solving skills.  Ability and willingness to continuously acquire new knowledge (business domain knowledge, expertise with software, etc.).  Ability to communicate effectively, especially in a cross-functional team setting.  Ability to effectively present analysis to ICW staff and external audiences. Familiarity with business operations in the property casualty insurance industry is preferred. 

PHYSICAL REQUIREMENTS 

Office environment – no specific or unusual physical or environmental demands and employees are regularly required to sit, walk, stand, talk, and hear.  

WORK ENVIRONMENT 

This position operates in an office environment and requires the frequent use of a computer, telephone, copier, and other standard office equipment.

Dice Id : 10123200
Position Id : 7002599
Originally Posted : 2 months ago
Have a Job? Post it