BI Developer / Reporting Analyst Remote

Aegis Security Insurance; San Diego (CA); Remote; USD 90,000 - 110,000; Full time

Job summary

Aegis Security Insurance is seeking a full-time BI Developer / Reporting Analyst experienced in the insurance industry. The role involves building and maintaining reports and dashboards using SSRS and Power BI, alongside writing complex SQL queries. This position offers competitive compensation and benefits while contributing to an established yet growing company in the insurance sector.

Benefits

Competitive pay

Bonus plan

Medical, dental, and vision insurance

Paid time-off in year of hire

401(k) with employer match

Qualifications

• 3+ years in a BI Developer, Reporting Analyst, or similar data-focused role.
• Proficient in SSRS, SSIS, Power BI, and SQL.
• 2+ years of experience in the insurance industry.

Responsibilities

• Build and maintain reports and dashboards using SSRS, SSIS, and Power BI.
• Write complex SQL queries to pull data from SQL Server and Databricks.
• Work with Business Analysts to gather requirements for projects.

Skills

SSRS

SSIS

Power BI

SQL

Job description

BI Developer / Reporting Analyst - K2 Insurance Services

K2 Insurance Services, LLC seeks a full-time BI Developer / Reporting Analyst with insurance-industry experience who will build and maintain reports and dashboards using SSRS, SSIS, and PowerBI. We are looking for someone that has strong Microsoft (SSRS / SSIS) reporting skills to support reporting from our SQL Data Warehouse, but also someone that can help us grow with PowerBI reporting from our newer Databricks platform.

K2 Insurance Services offers the opportunity to join an established company in growth mode. Our compensation program includes competitive pay; bonus plan; medical, dental, and vision insurance; paid time-off in year of hire; and 401(k) with employer match.

Salary Range : $90,000 to $110,000,USD per year

Key Responsibilities :

• Report building :
• Build and maintain reports and dashboards using SSRS, SSIS, and Power BI
• Write complex SQL queries to pull data from SQL Server and Databricks data warehouses, source-systems, and / or staging environments
• Incorporate queries into stored procedures or Databricks notebooks
• Provide pre-written reports to users, schedule subscription reporting
• Build and publish data models and semantic layers
• Support ad-hoc data requests from our stakeholders
• Business Requirement Gathering :
• Work with our Business Analysts and with stakeholders to learn requirements for each project.
• Collaborate with the data engineering team to understand the warehouse structure and ensure effective use of the SQL Server and Databricks platforms; help build requirements where additional warehouse data would be useful.
• Document requirements, uses of reporting tools, and development actions taken in Confluence and Jira
• Testing / Validation
• Validate results against known, valid data / aggregates
• Participate in testing with users / stakeholders
• Provide light training on new toolsets provided

Qualifications

• 3+ years in a BI Developer, Reporting Analyst, or similar data-focused role
• Proficient in SSRS, SSIS, Power BI, and SQL
• Experience querying and reporting from a cloud-based data warehouse, preferably Databricks
• Strong understanding of relational databases, data modeling, and ETL concepts
• Ability to communicate effectively with technical and non-technical stakeholders
• Attention to detail, especially in data validation and reconciliation
• 2+ years of experience in the insurance industry.
• Ability to work effectively in a fast-paced and collaborative environment.

Preferred Skills

• Experience with Agile / Scrum methodologies
• Familiarity with DAX and Power Query
• Familiarity working in the Azure Databricks environment

Learn more about AGIA at www.k2dealerins.com and K2 Insurance Services at www.k2ins.com.

Create a job alert for this search