Reports Developer

Heartland Consulting; Richmond (VA); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Heartland Consulting in Virginia seeks a Data Reporting Analyst/Developer to analyze data and design reporting solutions across business units, leveraging SSRS, SQL Server, and visualization tools to deliver actionable insights. You will work with stakeholders, engineers, and analysts to gather requirements and develop dashboards for timely decisions.

The role requires strong SQL, SSRS, Report Builder, and Visual Studio skills, plus a methodical, independent approach and clear communication.

Qualifications

• Strong data analysis and intermediate data modeling skills.
• Advanced SQL on Microsoft SQL Server is required.
• Hands-on SSRS and Report Builder experience is mandatory.
• Experience with Visual Studio for building data/reporting solutions.

Responsibilities

• Collaborate with stakeholders and engineers to define data reporting needs and opportunities.
• Translate requirements into data specifications and report designs.
• Design dashboards, scoreboards, and tabular reports to meet requirements.
• Develop and maintain SSRS reports using SQL Server data sources.
• Use Visual Studio and Report Builder to deploy reporting solutions.
• Write and optimize SQL queries to support reporting.
• Validate data and reconcile discrepancies across sources.
• Identify opportunities to improve reporting and analytics processes.

Skills

SQL Server

SSRS

Report Builder

Visual Studio

Data Analysis

Data Modeling

Communication

Problem-Solving

Education

Bachelor's degree in IT/CS or related field

Tools

SSRS

Report Builder

Visual Studio

SQL Server

Job description

Data Reporting Analyst/Developer

The Data Reporting Analyst/Developer is an Information Technology Systems specialist who analyses data and reporting across various business units, designs, develops, and maintains reporting solutions using data analytics platforms, reporting tools, and visualization techniques. This position works with business leaders, engineers, other analysts, and subject matter experts to understand data and reporting needs, identify opportunities for improvements within legacy reporting, deployment methodologies etc. They focus on efficiencies and value-added solution building of data visualizations and reports to help company harvest business insights from efficient Data & Analytics. This role works towards bridging the gap between business processes and business intelligence and will have responsibility to mine, summarize, and analyze data from multiple sources to help drive insights into business performance.

Duties/Responsibilities

• Work with business stakeholders, business analysts, and engineers to understand data and reporting problems and opportunities and develop appropriate data reporting solutions
• Gather business requirements and convert them into data requirements and reports specifications, including process definitions, and changes required.
• Design reporting solutions to include reports, dashboards, scorecards and tabular data based on the type of requirement.
• Develop and maintain reports using SQL Server Reporting Services (SSRS).
• Utilize Visual studio to create and deploy SSRS reports.
• Utilize Report Builder to create and deploy SSRS reports.
• Write, optimize, and maintain SQL queries to support reporting needs.
• Analyze report requests to ensure they align with business needs rather than assumed requirements.
• Identify redundant or unnecessary data points in requested reports and recommend optimizations.
• Validate and reconcile data discrepancies across multiple sources.
• Debug and resolve errors in reports and queries.
• Catalog and document current reporting.
• Perform complex data mining exercises independently and interprets results using a variety of analytical methods
• Identify, troubleshoot and close service requests for user issues related to data, reporting and analytics.
• Provide feedback and suggestions to management for process improvement and critical metrics
• Participate in projects and QA Testing
• Assist in the overall implementation and execution of project and performance criteria as required

Knowledge/Skill Requirement

• Excellent knowledge and experience conducting structured and result-oriented business data analysis and intermediate knowledge of Data Modeling are required for this job.
• Expert hands-on experience with Structured Query Language (SQL) on Microsoft SQL Server development at advance level is a critical requirement for this position.
• Excellent hands-on experience with Microsoft Reporting Services (SSRS), and Report Builder is a must have requirement
• Excellent hands-on experience working with Microsoft Visual Studio for developing data and reporting solutions

• Prefers prior experience in either a technical or functional area that involved data analytics and report writing for a Mortgage/Financial institution
• Strong knowledge and understanding of business needs, with the ability to establish and maintain a high level of customer trust and confidence

Must have Competencies:

1. Analytical Mindset
2. Strong Communication
3. Problem-Solving Skills
4. Independent Thinker
5. Highly Organized

Additional Details:

• Remote work with the ability to come onsite on demand with minimal notice
• Must reside in Virginia.