Senior SQL Server BI Engineer

Job Title: Senior SQL Server BI Engineer

Location: On Site - Flowood, Mississippi, United States

Salary: $100,000-$120,000

Skills: SQL Server, SSRS, ETL, Database Performance Tuning, BI Analytics

About the Financial Services Company / The Opportunity:

Our client is a dynamic player in the financial services industry, committed to leveraging data-driven insights to empower business decisions and deliver high-quality financial solutions. This opportunity places you at the forefront of modern BI analytics, supporting mission-critical reporting and data infrastructure that shapes organizational strategy. As a Senior SQL Server BI Engineer, you will collaborate with talented professionals, drive improvements in data reliability and scalability, and contribute to a culture of innovation and knowledge sharing.

Responsibilities:

• Design, develop, and maintain accurate, efficient, and user-friendly SSRS reports and sub-reports.
• Optimize and manage SQL scripts, views, stored procedures, and functions for performance and reliability.
• Implement and oversee SQL Server Agent jobs, ensuring automated database tasks run efficiently and error-free.
• Monitor and tune SQL Server query performance, indexing, and troubleshoot database issues.
• Lead initiatives related to data quality, integrity, and governance, delivering accurate reporting outputs.
• Collaborate with business analysts, data engineers, and stakeholders to define and deliver analytics solutions.
• Participate in data modeling, ETL design, and BI solution architecture for advanced analytics projects.
• Develop and maintain documentation for database objects, reporting solutions, and internal processes.
• Mentor junior team members, promoting knowledge sharing and best practices across the IT team.
• Evaluate new SQL Server and BI technologies, recommending improvements and enhancements.

Must-Have Skills:

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent experience.
• 5 years of professional experience in SQL Server development, database administration, and BI analytics.
• Proven expertise in SSRS report development, including complex sub-reports, drill-through, and parameterized reports.
• Strong proficiency in writing, optimizing, and maintaining complex SQL queries, views, stored procedures, and functions.
• Experience managing SQL Server Agent jobs and scheduled automation tasks.
• Deep knowledge in database performance tuning, indexing, and query optimization.
• Hands-on experience in ETL, data integration, and data warehousing concepts.
• Familiarity with data governance, data quality, and security best practices.
• Excellent analytical and communication skills, with ability to explain technical concepts clearly to non-technical audiences.

Nice-to-Have Skills:

• Experience with Domo or other BI visualization tools.
• Knowledge of SSIS, Azure Data Services, or cloud-based SQL platforms.
• Familiarity with Agile development and project management methodologies.
• Advanced certifications such as Microsoft Certified: SQL Server Database Development/Administration.
• Exposure to big data, machine learning, or advanced analytics initiatives.