Data Reporting Analyst
ASCENDING Inc.
contract
Posted on:
Location: Virginia • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
AWSCloudMS SQL ServerSQL
About the role
- Partner with business stakeholders, analysts, and engineers to assess reporting needs and develop effective data solutions.
- Gather and translate business requirements into data specifications, ensuring alignment with organizational goals.
- Design and develop reporting solutions including dashboards, scorecards, and tabular data visualizations.
- Create and maintain reports using SQL Server Reporting Services (SSRS) and deploy them via Visual Studio and Report Builder.
- Write, optimize, and manage SQL queries to support complex reporting requirements.
- Analyze report requests to ensure they meet business needs and identify opportunities for optimization.
- Identify and eliminate redundant or unnecessary data points in reports to enhance clarity and usability.
- Validate and reconcile data discrepancies across multiple sources to maintain data integrity.
- Troubleshoot and resolve issues related to reports, queries, and analytics; provide user support for reporting issues.
- Maintain a catalog of existing reports and ensure proper documentation.
- Conduct complex data mining exercises and interpret results through various analytical methods.
- Offer recommendations to management for process improvements and performance metrics; participate in QA testing and project implementation efforts.
- Serve as a bridge between business processes and business intelligence to drive insights and improve operational efficiencies.
Requirements
- Strong analytical mindset with the ability to conduct structured and results-driven business data analysis.
- Expert proficiency in SQL, including hands-on experience with Microsoft SQL Server for advanced query development.
- Extensive experience with Microsoft Reporting Services (SSRS) and Report Builder for report creation and deployment.
- Proficiency in Microsoft Visual Studio for developing and managing reporting solutions.
- Prior experience in data analytics and report writing within the mortgage or financial industry (preferred).
- Strong understanding of business processes and a proven ability to build trust with stakeholders.
- Core competencies: Analytical Thinking, Effective Communication, Problem-Solving, Independence & Initiative, Organizational Skills.
- Must live in Virginia (Fully Remote requirement).
- Contracted, Mid-level role.