Reports Developer

Heartland Consulting; Richmond (VA); Hybrid; USD 75,000 - 90,000; Full time

Job summary

Heartland Consulting is seeking a Data Reporting Analyst/Developer to analyze data and design reporting solutions across multiple business units. You will develop and maintain reports using SQL Server Reporting Services and Visual Studio, and you will mine data from various sources to drive business insights.

You’ll work with business leaders, engineers, and analysts to improve legacy reporting and deploy robust data visualizations.

Qualifications

• Expert hands-on experience with SQL on Microsoft SQL Server in development and optimization tasks.
• Strong background in designing data models and reporting solutions to drive business insights.
• Experience with SSRS, Report Builder, and Visual Studio to create and deploy reports and dashboards.

Responsibilities

• Collaborate with stakeholders and engineers to translate data needs into reporting solutions.
• Gather requirements and convert them into data specs and report designs (reports, dashboards, scorecards).
• Develop and maintain SSRS reports; write and optimize SQL queries to support reporting needs.

Skills

SQL

Data analytics

Data modeling

Mortgage/Financial domain

Communication

Analytical mindset

Problem-solving

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

• Analytical Mindset
• Strong Communication
• Problem-Solving Skills
• Independent Thinker
• Highly Organized

Additional Details

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

Salary: $75000 - $90000 per year