Business Intelligence Developer

Reinsurance Associate Inc.; Missouri; On-site; USD 75,000 - 110,000; Full time

Job summary

Reinsurance Associate Inc. is seeking a Business Intelligence Developer to design, develop, and optimize reporting solutions and data models using SQL Server, SSIS, SSRS, and Power BI. You will partner with stakeholders to deliver actionable insights that drive strategic decisions.

You will build ETL processes, maintain data quality, and support executives with ad hoc analysis. A 3+ year BI background and strong communication skills are essential for success.

Qualifications

• Bachelor's degree or equivalent practical experience in CS/IS.
• 3+ years of experience in business intelligence, reporting, data modeling, or related fields.
• Strong SQL Server skills, including complex queries, joins, and stored procedures.
• Proficiency with SSIS, SSRS, Power BI, SSMS, and Visual Studio.
• Proficiency with Microsoft Office tools (Excel, Access, PowerPoint).
• Strong understanding of relational database concepts, data modeling, and data integrity.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Collaborate with stakeholders to gather reporting requirements and deliver enterprise reporting solutions.
• Design, develop, and optimize data models, tables, views, and procedures.
• Create and manage reports using SSRS and Power BI; support ad hoc analysis.
• Develop and maintain ETL processes and data integrations using Microsoft technologies.
• Monitor performance, troubleshoot issues, and ensure data governance and security.

Skills

SQL Server proficiency

Analytical skills

Communication skills

Problem solving

Education

Bachelor's degree in Computer Science, Information Systems, or equivalent

Tools

SSIS

SSRS

Power BI

SSMS

Visual Studio

Job description

Transform Data Into Insights That Drive Business Success

Are you passionate about data, analytics, and solving complex business challenges? Do you thrive in an environment where your work directly influences strategic decision-making?

We're seeking a Business Intelligence Developer to join our growing IT Reporting Resources team. In this role, you'll design, develop, and optimize reporting solutions, data models, and database systems that deliver critical business insights across the organization. You'll work with modern Microsoft data technologies, collaborate with stakeholders across departments, and play a key role in ensuring data is accurate, accessible, and actionable.

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.

Why Join Us?

• Work with modern Microsoft BI and data technologies.
• Make a direct impact on business strategy and decision-making.
• Collaborate with cross-functional teams across the organization.
• Expand your technical expertise through continuous learning and professional development.
• Be part of a team that values innovation, accuracy, and data-driven excellence.