Senior SQL Server / BI Analytics Engineer

Tower Loan; Flowood (MS); On-site; USD 90,000 - 120,000; Full time

Job summary

Tower Loan in Flowood, MS is seeking a Senior SQL Server / BI Analytics Engineer to enhance our data platform. You will develop and optimize SSRS reports, SQL scripts, and procedures to improve reporting reliability and performance.

You will collaborate with analysts and engineers on data modeling, ETL, and BI solutions, delivering robust data governance and scalable data integration practices. This role requires strong communication and problem-solving skills.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Minimum of 5 years of professional experience in SQL Server development, database administration, BI, or related field.
• Experience developing and maintaining SSRS reports.
• Experience with ETL, data integration, and data warehousing.

Responsibilities

• Design, develop, and maintain SSRS reports and sub-reports to provide accurate, efficient, and user-friendly reporting solutions.
• Develop, optimize, and maintain SQL scripts, queries, views, stored procedures, and functions to support performance, reliability, and scalability.
• Implement, maintain, and monitor SQL Server Agent jobs and other scheduled automation processes.
• Monitor SQL Server performance and perform indexing, query tuning, troubleshooting, and other database optimization activities.
• Support data quality, integrity, governance, and security practices to help ensure accurate and reliable reporting.
• Collaborate with business analysts, data engineers, and other stakeholders to identify reporting and analytics requirements and develop appropriate solutions.
• Participate in data modeling, ETL development, data integration, and business intelligence solution design.
• Develop and maintain documentation for database objects, reporting solutions, processes, and related technical procedures.
• Provide guidance and technical support to other team members and contribute to knowledge sharing and development of best practices.
• Evaluate SQL Server, business intelligence, and related technology trends and recommend improvements to systems and processes.
• Troubleshoot database, reporting, and data-related issues and coordinate resolution as needed.
• Support business intelligence visualization tools and related reporting platforms.
• Assist with special projects, system enhancements, and other IT initiatives as needed.

Skills

SQL Server

SSRS

Query optimization

ETL

Data governance

Analytical thinking

Communication

Stakeholder collaboration

Education

Bachelor's degree in CS / IS / related field

Microsoft SQL Server certifications preferred

Tools

SSIS

Domo

Azure Data Services

Cloud-based SQL platforms

BI reporting tools

Job description

Senior SQL Server / BI Analytics Engineer page is loaded## Senior SQL Server / BI Analytics Engineerlocations: Flowood MStime type: Full timeposted on: Posted Yesterdayjob requisition id: JR2262**We take pride in what we do! Deciding to come grow with us is an exciting opportunity to enhance your career success stories. You are the center to what we do. We would love to have you here!**The Senior SQL Server/BI Analytics Engineer develops, maintains, and optimizes the company's database, reporting, and business intelligence environment. This position supports reliable data and reporting through SQL Server development, SSRS reporting, database performance optimization, data integration, and business intelligence solutions.**Duties/Responsibilities:*** Design, develop, and maintain SSRS reports and sub-reports to provide accurate, efficient, and user-friendly reporting solutions.* Develop, optimize, and maintain SQL scripts, queries, views, stored procedures, and functions to support performance, reliability, and scalability.* Implement, maintain, and monitor SQL Server Agent jobs and other scheduled automation processes.* Monitor SQL Server performance and perform indexing, query tuning, troubleshooting, and other database optimization activities.* Support data quality, integrity, governance, and security practices to help ensure accurate and reliable reporting.* Collaborate with business analysts, data engineers, and other stakeholders to identify reporting and analytics requirements and develop appropriate solutions.* Participate in data modeling, ETL development, data integration, and business intelligence solution design.* Develop and maintain documentation for database objects, reporting solutions, processes, and related technical procedures.* Provide guidance and technical support to other team members and contribute to knowledge sharing and development of best practices.* Evaluate SQL Server, business intelligence, and related technology trends and recommend improvements to systems and processes.* Troubleshoot database, reporting, and data-related issues and coordinate resolution as needed.* Support business intelligence visualization tools and related reporting platforms.* Assist with special projects, system enhancements, and other Information Technology initiatives as needed.* Perform all other duties as assigned.**Required Skills/Abilities:*** Advanced knowledge of Microsoft SQL Server, database development, and database administration.* Strong knowledge of SSRS report development, including parameterized reports, drill-through functionality, and complex sub-reports.* Ability to develop, maintain, and optimize complex SQL queries, views, stored procedures, and functions.* Strong knowledge of database performance tuning, indexing, query optimization, and troubleshooting.* Knowledge of ETL processes, data integration, data modeling, and data warehousing concepts.* Understanding of data governance, data quality, and database security best practices.* Strong analytical, problem-solving, organizational, and communication skills.* Ability to manage multiple priorities and work effectively with technical and non-technical stakeholders.* Ability to explain technical concepts and reporting solutions to employees with varying levels of technical knowledge.* Knowledge of business intelligence and data visualization tools.* Experience with Domo or similar business intelligence platforms preferred.* Knowledge of SSIS, Azure Data Services, cloud-based SQL platforms, Agile methodologies, machine learning, or advanced analytics preferred.**Education and Experience:*** Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent education and experience.* Minimum of 5 years of professional experience in SQL Server development, database administration, business intelligence, data analytics, or a related field.* Experience developing and maintaining SSRS reports.* Experience managing SQL Server Agent jobs and scheduled automation processes.* Experience with ETL, data integration, and data warehousing.* Microsoft SQL Server or related technical certifications preferred.**Physical Requirements:*** Stand, walk, and/or sit for eight (8) hours a day.* Communicate effectively, verbally, written, in person, via telephone, or electronically.* Lift and maneuver up to 20 lbs.The above description outlines the most significant job functions performed, but may include other similar functions or assignments not explicitly mentioned.### Your Next Opportunity AwaitsIf you're seeking a rewarding career with a company that values its employees and communities, we encourage you to apply. If your profile matches our open positions, our team will be in touch with you.