Sr. Data, Reporting Analyst

Evolving Solution Services; Louisville (KY); On-site; USD 90,000 - 140,000; Full time

Job summary

Medvantx in Louisville, KY is seeking a Sr. Data & Reporting Analyst to transform complex data into actionable insights through advanced reporting, analytics, and visualization.

You will partner with stakeholders to gather requirements, develop dashboards and reports using Power BI, SSRS, and SQL-based tools, ensure data accuracy, and support strategic decisions across the enterprise. This role emphasizes governance, quality, and scalable BI solutions.

Qualifications

• Bachelor’s degree in computer science or related field, or comparable work experience.
• 5+ years' experience in software engineering, development operations engineering, database administration, or product development role; strong MS SQL Server proficiency.
• Experience developing reports with SSRS and SQL Report Builder.
• Experience designing and supporting SSIS ETL packages and data integration processes.
• Strong Power BI experience with data modeling, DAX, and dashboard development.
• Knowledge of data warehousing concepts, dimensional modeling, and star schema design.
• Experience with Azure SQL, Azure Data Factory preferred.
• Familiarity with source control, release management, and Agile/Scrum methodologies.
• Strong understanding of data governance and data quality principles.

Responsibilities

• Design, develop, and maintain complex reporting solutions using T-SQL, SSRS, SQL Report Builder, and Power BI.
• Write, optimize, and troubleshoot T-SQL queries, stored procedures, views, functions, and scripts for BI initiatives.
• Develop and support SSIS packages for ETL across multiple systems.
• Collaborate with stakeholders to gather reporting requirements and translate into scalable solutions.
• Create and maintain dashboards with Power BI, SSRS, and SQL-based reporting tools.
• Validate data from multiple sources to ensure accuracy and integrity across reports.
• Perform root cause analysis and resolve data/reporting issues through investigation and validation.
• Support enterprise data warehouse and data integration initiatives with Data Engineers/DBAs.
• Build data models, report datasets, database objects, and semantic layers for self-service reporting.
• Monitor and optimize report performance and database efficiency.

Skills

Data analysis

Data visualization

SQL performance tuning

T-SQL development

Dashboard development

Stakeholder collaboration

Data modeling

KPI reporting

Agile/Scrum

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

SSRS

SSIS

SQL Server

Azure SQL

Azure Data Factory

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Professional Louisville, Louisville, KY, US

5 days ago Requisition ID: 1010

As a Sr. Data & Reporting Analyst, your primary focus will be ontransforming complex data into actionable business insights through advanced reporting, analytics, and visualization solutions. Partners with business stakeholders to gather requirements, develop and maintain dashboards and reports, ensure data accuracy and integrity, and support strategic decision-making. This role utilizes tools such as Power BI, SQL, and data modeling techniques to identify trends, measure performance, and deliver meaningful analytics that drive operational efficiency and business growth. Serves as a subject matter expert in reporting processes and provides guidance on best practices for data analysis and reporting.

Key Responsibilities

• Design, develop, and maintain complex reporting solutions using T-SQL, SQL Server Reporting Services (SSRS), SQL Report Builder, and Power BI.
• Write, optimize, and troubleshoot T-SQL queries, stored procedures, views, functions, and scripts to support reporting, analytics, and business intelligence initiatives.
• Develop and support SSIS packages for data extraction, transformation, and loading (ETL) processes across multiple business systems.
• Collaborate with business stakeholders to gather reporting requirements and translate them into scalable technical reporting solutions.
• Develop, maintain, and enhance operational, financial, and executive dashboards utilizing Power BI, SSRS, and SQL-based reporting tools.
• Analyze and validate data from multiple sources to ensure data accuracy, consistency, and integrity across reporting platforms.
• Perform root cause analysis and resolve complex data, reporting, and system issues through technical investigation and data validation.
• Support enterprise data warehouse and data integration initiatives by working closely with Data Engineers and Database Administrators.
• Create and maintain data models, report datasets, database objects, and semantic layers to support self-service reporting capabilities.
• Monitor and optimize report performance, query execution, and database efficiency to improve scalability and end-user experience.
• Support testing, deployment, validation, and change management activities across reporting environments.
• Identify and implement opportunities for reporting automation, standardization, and process improvement.
• Present KPIs, trends, insights, and recommendations to business and leadership stakeholders.
• Ensure compliance with data governance, security, and reporting standards.
• Design and implement monitoring, alerting, and health-check processes to proactively identify data quality, reporting, and system performance issues.
• Establish and monitor operational metrics, reporting SLAs, and service health indicators.
• Build strong partnerships with internal stakeholders, leadership, and external clients to support strategic and operational decision-making.
• Drive KPI standardization, reporting governance, visualization best practices, and enterprise reporting frameworks.
• Communicate reporting releases, enhancements, bug fixes, and data definition changes while facilitating stakeholder feedback and prioritizing improvements.

Skills & Qualification

• Bachelor’s degree in computer science or related field, or comparable work experience
• 5+ year's experience in a software engineering, development operations engineering, database administration, or product development role. Advanced proficiency in Microsoft SQL Server, including T-SQL development and performance tuning.
• Experience developing reports with SQL Server Reporting Services (SSRS) and SQL Report Builder.
• Experience designing and supporting SSIS ETL packages and data integration processes.
• Strong experience with Power BI, including data modeling, DAX, and dashboard development.
• Knowledge of data warehousing concepts, dimensional modeling, and star schema design.
• Experience working with Azure SQL, Azure Data Factory, or cloud-based data platforms is preferred.
• Familiarity with source control, release management, and Agile/Scrum methodologies.
• Strong understanding of data governance, data quality, and master data management principles.

Physical Demands

• The physical demands of this position are in keeping with general office functions: sitting, using a computer, keyboard, telephone, etc.
• Reasonable accommodation can be made to enable employee to perform the essential job duties.

Medvantx is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender (including pregnancy, childbirth, or related conditions), sexual orientation, gender identity, gender expression, age, veteran or disability status, or other protected characteristics.