Senior Data & Reporting Systems Advisor

W3R Consulting; Northern (KY); Hybrid; USD 95,000 - 125,000; Full time

Job summary

W3R Consulting seeks a Systems Analysis Specialist to bridge business and technology, crafting requirements, validating rules, and supporting data warehouse modernization.

You will collaborate with stakeholders, developers and data engineers to deliver scalable reporting, automate processes, and improve data quality across enterprise environments. Strong communication and problem-solving are essential.

Qualifications

• 3+ years of intermediate to advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization)
• 3+ years of Tableau experience
• 3+ years of functional testing and regression/negative testing
• 3+ years of SSRS (drilldowns, drillthroughs, dynamic groupings, etc.)
• 3+ years of SSIS (review/debug/suggest design)
• 5+ years of data analysis and mining
• 5+ years of requirements gathering in Agile environments
• Excellent written and verbal communication skills
• Experience supporting enterprise data warehouse or Datamart environments
• Experience documenting complex business logic and data lineage
• ETL design, troubleshooting, and performance optimization
• Process automation implementation
• Data quality, governance, and validation
• Production reporting environments and release management

Responsibilities

• Participate in end-to-end user requirements discussions
• Coordinate with business partners to translate business processes into technical workflows
• Coordinate with developers on technical delivery
• Suggest design for and test code changes
• Design ways to improve systems, reduce costs and maximize opportunities
• Document all calls, business requirements and team items
• Integrate UM reporting into the Datamart Application

Skills

T-SQL

Tableau

SSRS

SSIS

Data analysis

Agile requirements gathering

Testing

Data warehousing

ETL

Data governance

Data quality

Release management

Communication

Education

Bachelor’s Degree

Tools

MS SQL Server

Job description

W3R Consulting seeks a Systems Analysis Specialist to bridge business and technology, crafting requirements, validating rules, and supporting data warehouse modernization.

You will collaborate with stakeholders, developers and data engineers to deliver scalable reporting, automate processes, and improve data quality across enterprise environments. Strong communication and problem-solving are essential.