Senior SQL Server / BI Analytics Engineer

Tower Loan of Mississippi, LLC; Dogwood Place (MS); On-site; USD 90,000 - 120,000; Full time

Job summary

Tower Loan of Mississippi, LLC is seeking a Senior SQL Server/BI Analytics Engineer to develop, optimize, and maintain the company’s database, reporting, and BI environment for reliable data insights.

This role focuses on SSRS reporting, SQL scripting, data integration, and governance, working with analysts and engineers to deliver scalable solutions and robust documentation across the organization.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent education and experience.
• 5+ years of professional SQL Server development and BI experience.
• Experience with SSRS reports and parameterized reports.
• Experience with ETL, data integration, and data warehousing.
• Knowledge of data governance, data quality and security best practices.
• Strong analytical and communication skills.
• Ability to explain technical concepts to non-technical stakeholders.
• Familiarity with BI platforms like Domo; SSIS, Azure Data Services 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.
• Monitor SQL Server performance and indexing; troubleshoot and optimize queries.
• Support data quality, governance, and security practices to ensure accurate reporting.
• Collaborate with analysts, data engineers, and stakeholders to identify reporting requirements and develop solutions.
• Participate in data modeling, ETL development, data integration, and BI solution design.
• Develop and maintain documentation for database objects and processes.
• Provide guidance and support to team members and share best practices.
• Evaluate SQL Server and BI trends and recommend improvements.
• Troubleshoot data/reporting issues; coordinate resolutions.
• Assist with special IT projects as needed.

Skills

SQL Server development

SSRS reporting

Query optimization

ETL development

Data warehousing

Data governance

Data quality

Azure Data Services

SSIS

Communication

Education

Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent education and experience

Tools

Domo

SSIS

Azure Data Services

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.