Business Intelligence Developer

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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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, Power Shell, Azure Dev Ops, or CI/CD processes.
• Familiarity with big data environments and cloud-native data solutions.

• 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.