Business Intelligence Developer

Reinsurance Associate Inc.; Fenton (MO); On-site; USD 75,000 - 110,000; Full time

Job summary

Reinsurance Associate Inc. is seeking a Business Intelligence Developer to transform data into actionable insights. You will design and optimize reporting solutions, data models, and databases using Microsoft data technologies to support strategic decision-making across the organization.

Join a collaborative IT Reporting Resources team and partner with stakeholders to deliver reliable, scalable reports in SSRS and Power BI, implement ETL processes, and ensure data accuracy and governance.

Qualifications

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

Responsibilities

• Partner with stakeholders to gather 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 partners.
• Deliver ad hoc analysis and SQL query support for management and executives.
• Provide user training and documentation for reporting tools and dashboards.

Skills

SQL

SSIS

SSRS

Power BI

SSMS

Visual Studio

Excel

Access

PowerPoint

Data modeling

Data integrity

Analytical skills

Communication

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Azure Data Factory

Azure DevOps

WinSCP

CI/CD

PowerShell

Workato

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.