Senior SQL Server / BI Analytics Engineer

Tower Loan of Mississippi, LLC; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Tower Loan seeks a Senior SQL Server/BI Analytics Engineer to develop, maintain, and optimize the company’s database, reporting, and BI ecosystem in the United States. You will support reliable data and reporting through SQL Server development, SSRS reporting, and BI solutions.

Key responsibilities include designing SSRS reports, optimizing SQL scripts, managing SQL Server Agent jobs, and ensuring data governance and security across projects.

Qualifications

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

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.

Skills

Microsoft SQL Server

SSRS report development

SQL scripting & stored procedures

Database performance tuning

ETL / data integration

Data governance & security

Analytical thinking

Communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

SSIS

Azure Data Services

Domo

Job description

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.

With over 260 locations across 8 states, our team builds strong customer relationships by offering personalized financial solutions in person, by phone, and online.

We're dedicated to our communities, foster employee growth, and offer clear career paths through internal promotion.

Established since 1936, Tower Loan is proud to be one of America's largest privately owned consumer finance companies, operating more than 260 office locations across eight states. We are dedicated to building strong customer relationships by providing personalized financial solutions and are deeply committed to serving our communities. We foster a culture of growth and development for our employees, with a strong promote-from-within philosophy. For decades, Tower Loan has empowered our customers and team members to build brighter futures.