Business Intelligence Solutions Specialist

Assurant, Inc.; United States; Remote; USD 70,000 - 110,000; Full time

Job summary

Assurant, Inc. is seeking a Business Intelligence Solutions Specialist to develop data-driven solutions for Legal and Compliance operations.

You will partner with stakeholders across Legal, Compliance, IT and external providers to translate business requirements into reporting, analytics, automation and technology solutions. You will design and maintain Power BI dashboards, integrate data via SQL and ETL, and lead automation initiatives using Power Automate and APIs to deliver measurable

Qualifications

• Minimum 3 years in BI, data analytics, or related fields.
• Experience building Power BI dashboards and data models.
• Strong SQL skills for data extraction, transformation and validation.
• Experience with ETL, data integration, APIs and automation tools.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards, reports, data models, and KPIs.
• Write and optimize SQL queries; perform ETL to integrate data from multiple sources.
• Build and support automated workflows using Power Automate and APIs.
• Collaborate with Legal, Compliance, IT and vendors to translate requirements into solutions.
• Lead projects through planning, testing, deployment, and continuous improvement.
• Ensure data accuracy, access controls, and data security in BI environments.
• Document processes, data flows, and solution configurations; train users.

Skills

Advanced English proficiency

Stakeholder management

Analytical thinking

Project management

Education

Bachelor's degree in Information Systems or related field

Tools

Power BI

SQL

Power Query

Power Automate

APIs

ETL processes

Job description

The Business Intelligence Solutions Specialist supports Legal and Compliance operations by developing data-driven solutions that improve decision-making, operational efficiency, and business performance. This role partners with Legal, Compliance, IT, and external vendors to translate business requirements into reporting, analytics, automation, and technology solutions. In this position, you will develop business intelligence solutions, support data integrations, automate workflows, and lead process improvement initiatives. You will use tools such as Power BI, SQL, Power Query, Power Automate, APIs, and emerging artificial intelligence technologies to deliver measurable business value.

What makes us different?

• Work on solutions that directly improve Legal and Compliance operations and decision-making.
• Partner with stakeholders across Legal, Compliance, IT and external technology providers.
• Build end-to-end solutions using Power BI, SQL, Power Query, Power Automate, APIs, and other modern technologies.
• Contribute to automation, process improvement and artificial intelligence initiatives.
• Take ownership of projects from requirements gathering and development through testing, deployment and continuous improvement.

What will be my duties and responsibilities in this job?

• Develop, maintain and enhance Power BI dashboards, reports, data models, visualizations and KPIs that provide actionable insights and support business objectives.
• Write and optimize SQL queries; use Power Query and ETL processes to extract, transform, validate, and integrate data from multiple sources.
• Build and support automated workflows using Power Automate, APIs, web services and other integration technologies.
• Partner with business and technical stakeholders to gather requirements and translate them into effective reporting, analytics, automation and technology solutions.
• Lead and support projects through planning, development, testing, User Acceptance Testing, deployment, change management, and ongoing enhancement.
• Maintain data accuracy, reporting reliability, and appropriate access controls that include Power BI row-level security and workspace permissions.
• Monitor and troubleshoot dashboards, data refreshes, integration, and automation.
• Analyze current processes, identify improvement opportunities, and document business processes, data flows, system interactions, and solution configurations.
• Develop user documentation and training materials to support the successful adoption of new systems, processes, and reporting solutions.
• Research emerging technologies, including AI-enabled solutions, that can improve operational efficiency and business performance.

What are the requirements needed for this position?

• At least 3 years of experience in Business Intelligence, Data Analytics, Business Analysis, Business Systems, Project Management, Process Improvement, or a related field.
• Advanced English proficiency, C1 level or higher, with strong written and verbal communication skills.
• Hands-on experience developing Power BI dashboards and reports, including data modeling and reporting solutions.
• Strong SQL skills with experience extracting, transforming, validating, and analyzing data from multiple sources.
• Experience with ETL processes, Power Query, data integration, APIs, web services, or similar connectivity methods.
• Experience developing or supporting workflow automation solutions using Power Automate or comparable technologies.
• Demonstrated ability to gather business requirements and translate them into technical or technology-enabled solutions.
• Experience managing projects through planning, execution, monitoring, testing, and implementation.
• Bachelor’s degree in Information Systems, Computer Science, Engineering, Data Analytics, Business Administration, or a related field, or an equivalent combination of education and relevant professional experience.

What other skills/experience would be helpful to have?

• Advanced Power BI experience, including DAX, Power Query M, semantic modeling, row-level security, and report performance optimization.
• Experience with Python or other analytics tools used for reporting, automation, or data analysis.
• Experience working in Legal, Compliance, Risk Management, or another highly regulated environment.
• Knowledge of data governance, data quality, KPI development, and business intelligence reporting best practices.
• Experience with Lean, Six Sigma, or other continuous improvement methodologies.
• Experience designing and supporting end-to-end business intelligence, automation, and data integration solutions.
• Experience using Microsoft Visio, Lucidchart, or similar tools to document processes, workflows, data flows, and system interactions.
• Strong analytical, problem-solving, stakeholder management, organizational, and communication skills.
• Microsoft Power BI, PMP, CBAP, Lean Six Sigma, or related professional certification.