Reports Developer

Summary

Heartland Consulting is seeking a Data Reporting Analyst/Developer to analyze business data and develop, maintain, and improve reporting solutions. The role partners with stakeholders and technical teams to translate business needs into reports, dashboards, and data visualizations, while validating data, resolving reporting issues, and supporting analytics projects.

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

Skills

• 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
• Strong knowledge and understanding of business needs, with the ability to establish and maintain a high level of customer trust and confidence
• Analytical Mindset
• Strong Communication
• Problem-Solving Skills
• Independent Thinker
• Highly Organized
• Remote work with the ability to come onsite on demand with minimal notice
• Must reside in Virginia
• Prefers prior experience in either a technical or functional area that involved data analytics and report writing for a Mortgage/Financial institution

Qualifications

Must Haves

• 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
• Strong knowledge and understanding of business needs, with the ability to establish and maintain a high level of customer trust and confidence
• Analytical Mindset
• Strong Communication
• Problem-Solving Skills
• Independent Thinker
• Highly Organized
• Remote work with the ability to come onsite on demand with minimal notice
• Must reside in Virginia

Nice to Haves

• Prefers prior experience in either a technical or functional area that involved data analytics and report writing for a Mortgage/Financial institution

Benefits

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