Senior Data Reporting & BI 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

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.