Business Intelligence Developer

Reinsurance Associate Inc.

$80K — $95K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience.
  • 3+ years in business intelligence, reporting, database development, or related fields.
  • Strong SQL Server skills, specifically in complex queries and stored procedures.
  • Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, and SQL Server Management Studio (SSMS).
  • Proficiency in Microsoft Office tools including Excel and Access.
  • Strong understanding of relational database concepts and data integrity practices.
  • Excellent analytical, problem-solving, and communication skills.

Responsibilities

  • Partner with business stakeholders to gather and define reporting requirements.
  • Develop, maintain, and enhance enterprise reporting solutions.
  • Create and manage reports using SSRS and Power BI.
  • Support reporting needs for internal users and external business partners.
  • Deliver ad hoc analysis and database query support for management and executives.
  • Design, maintain, and improve enterprise relational data models.
  • Develop and maintain ETL and integration processes using Microsoft technologies.

Benefits

  • Opportunities for professional development and ongoing training.
  • Supportive work environment that emphasizes collaboration.
  • Access to advanced tools and technologies in data analytics.
  • Flexible work schedule with potential remote work options.
  • Comprehensive user support and resources for personal growth.
Full Job Description
What You'll Do
Reporting & Analytics
  • Partner with business stakeholders to gather and define reporting requirements.
  • Develop, maintain, and enhance enterprise reporting solutions.
  • Create and manage reports using SQL Server Reporting Services (SSRS) and Power BI.
  • Support reporting needs for both internal users and external business partners.
  • Deliver ad hoc analysis and database query support for management and executive teams.
  • Provide user support, training, and documentation for reporting tools and dashboards.
Data Modeling & Database Development
  • Design, maintain, and improve enterprise relational data models.
  • Build and optimize SQL tables, views, functions, and stored procedures.
  • Evaluate and implement enhancements to data structures and reporting databases.
  • Analyze business requirements and recommend efficient database solutions.
  • Support and improve Microsoft Access applications and user interfaces.
Integration & Automation
  • Develop and maintain ETL and integration processes using Microsoft technologies.
  • Create and manage SQL Agent jobs and automated file delivery solutions.
  • Support data integrations across multiple platforms and systems.
  • Monitor processing schedules and ensure reliable data flow across the organization.
Database Administration & Performance
  • Monitor and optimize database and reporting performance.
  • Troubleshoot data issues and implement long-term solutions.
  • Collaborate with IT Engineering on system deployments, upgrades, and enhancements.
  • Ensure adherence to data governance, security, and reliability standards.
What You'll Bring
Required Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience.
  • 3+ years of experience in business intelligence, reporting, database development, or related fields.
  • Strong SQL Server skills, including complex queries, joins, and stored procedures.
  • Experience with:
    • SQL Server Integration Services (SSIS)
    • SQL Server Reporting Services (SSRS)
    • Power BI
    • SQL Server Management Studio (SSMS)
    • Visual Studio
  • Proficiency with Microsoft Office tools, including Excel, Access, and PowerPoint.
  • Strong understanding of relational database concepts, data modeling, and data integrity practices.
  • Excellent analytical, problem-solving, and communication skills.
Preferred Qualifications
  • Experience with SQL Administration and SQL Agent Jobs.
  • Familiarity with SFTP tools such as WinSCP.
  • Experience working in financial services, insurance, or other regulated industries.
  • Knowledge of Azure cloud technologies and cloud-based data platforms.
  • Experience with Azure Data Factory, Workato, PowerShell, Azure DevOps, or CI/CD processes.
  • Familiarity with big data environments and cloud-native data solutions.

Similar Jobs

More Information Technology Jobs

Find similar Business Intelligence Developer jobs: