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 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.
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.
Tech Stack
MS SQL Server
SQL
Benefits
MENTORSHIP Develop and leverage essential domain knowledge, plus your passion with ASCENDING. Get guidance from experienced mentors and expand knowledge in AWS cloud computing, software development and business development.
BUILD VERSATILE SKILLS Confront different challenges and build your versatile skills crossing from software engineering, big data, DevOps, front-end, full-stack, testing, automation and more.
DIVERSITY AND INCLUSION ASCENDING values diversity and has an open mind for talented and professionals. Our commitment to inclusion across race, gender, age, religion, identity, and experience drives us forward every day.