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.
