Data Reporting Analyst

Data Reporting Analyst/DeveloperThe Data Reporting Analyst/Developer is a key member of the Information Technology team, specializing in data analysis, reporting, and visualization across multiple business units. This role involves designing, developing, and maintaining reporting solutions using advanced data analytics platforms and visualization tools.The ideal candidate will collaborate with business leaders, engineers, analysts, and subject matter experts to understand reporting needs, enhance legacy reporting, and improve deployment methodologies. They will focus on optimizing data visualizations and reporting solutions to drive business insights and improve operational efficiencies. This position serves as a bridge between business processes and business intelligence, leveraging data mining, summarization, and analysis to provide valuable insights into business performance.Key ResponsibilitiesPartner 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 various 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, identifying opportunities for optimization and efficiency.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.Maintain a catalog of existing reports and ensure proper documentation.Conduct complex data mining exercises, interpreting results through various analytical methods.Provide support by resolving user-reported data and reporting issues.Offer recommendations to management for process improvements and performance metrics.Participate in quality assurance (QA) testing and project implementation efforts.Required Skills & QualificationsStrong 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 CompetenciesAnalytical Thinking – Ability to break down complex problems and derive meaningful insights from data.Effective Communication – Strong written and verbal communication skills to interact with business and technical teams.Problem-Solving – Ability to troubleshoot issues and develop efficient, data-driven solutions.Independence & Initiative – Self-starter who can take ownership of projects and deliver high-quality results.Organizational Skills – Ability to manage multiple tasks, meet deadlines, and maintain structured documentation.