SSRS Reports Developer/ Data Analyst SQL

Calqulate - Irvine, CA

Full-time - Mid Level

Irvine, CA

About the position

SSRS Reports Developer / Data Analyst SQL in Irvine, California (Hybrid) is a pivotal role within an innovative Technology Consulting Firm. The selected candidate will be responsible for collaborating with clients on multiple projects, translating report and form requirements into visually appealing, data-rich solutions. This position requires a strong focus on understanding client needs, documenting specifications, tracking development progress, and ensuring data accuracy and reliability. The role also involves troubleshooting and resolving issues related to forms and reports while providing enhancement support. The ideal candidate will possess strong communication skills, be adept at balancing multiple project priorities, and thrive in a virtual work environment, consistently delivering high-quality work. In this role, the SSRS Developer / Data Analyst will utilize their expertise to design, develop, and maintain SSRS Reports and Forms that meet client business needs. They will collaborate with stakeholders to understand their reporting needs and translate those needs into actionable solutions. The candidate will be responsible for collecting and integrating data from diverse sources, ensuring data accuracy, consistency, and completeness in all reports and forms. Continuous improvement and optimization of existing reports for enhanced performance and efficiency will also be a key responsibility. Thorough documentation of report design, development processes, and technical specifications will be maintained, along with conducting comprehensive testing and debugging to resolve issues in forms and reports. The role requires offering guidance and support to team members and clients on developed forms and reports, as well as keeping up-to-date with the latest SSRS and MS SQL features and best practices in report development. Project administration and communication are also critical, including monitoring and updating project tasks, maintaining organized documentation, responding promptly to client and vendor requests, and clearly communicating status updates and deliverable statuses to the project team, clients, and vendors. The candidate will also be responsible for organizing and leading meetings with the project team, clients, and vendors as necessary.

Responsibilities

• Utilize expertise to design, develop, and maintain SSRS Reports and Forms that meet client business needs, ensuring clarity, accuracy, and visual appeal.
• Collaborate with stakeholders to understand their reporting needs and translate those needs into actionable solutions.
• Collect and integrate data from diverse sources, including databases, spreadsheets, and other repositories.
• Ensure data accuracy, consistency, and completeness in all reports and forms.
• Continuously improve and optimize existing reports for enhanced performance and efficiency.
• Maintain thorough documentation of report design, development processes, and technical specifications.
• Conduct comprehensive testing and debugging to resolve issues in forms and reports.
• Offer guidance and support to team members and clients on developed forms and reports.
• Keep up-to-date with the latest SSRS and MS SQL features and best practices in report development.
• Monitor and update project tasks, action items, checklists, and ticket trackers regularly.
• Maintain organized and consistent documentation and file management practices.
• Respond promptly to client and vendor requests, documenting interactions effectively.
• Follow up on open tasks and activities, ensuring timely completion and updating stakeholders on progress.
• Clearly communicate status updates, issue resolutions, and deliverable statuses to the project team, clients, and vendors.
• Organize and lead meetings with the project team, clients, and vendors as necessary.

Requirements

• Bachelor's Degree or equivalent work experience.
• Proven experience in SSRS Reports and Forms Development is essential.
• Strong skills in MS SQL for data retrieval and manipulation.
• Understanding of data warehousing concepts and database design.
• Excellent analytical and problem-solving abilities.
• Commitment to producing high-quality forms and reports.
• Strong communication and collaboration skills.
• Willingness to work evenings and weekends as required.

Nice-to-haves

• Demonstrated ability to be productive in a virtual work environment.
• High aptitude for critical thinking and problem-solving, especially when details are limited.
• Anticipate client and team needs, taking initiative to address them.
• Strong verbal, listening, and written communication skills in client interactions.
• Proficiency in professional email communication, including responsiveness, proper formatting, grammar, and professionalism.
• Comfortable with virtual communication and occasional in-person meetings.
• Ability to manage multiple priorities and client/team demands efficiently.
• Establish strong, trust-based relationships with clients and team members.
• Demonstrate a sense of urgency in addressing all requests, valuing each task equally.
• Uphold a high degree of confidentiality in all aspects of work.