SQL and Reporting Analyst (SQL Server + SSRS)

FedTec Overview: FedTec is a Woman-Owned Small Business with headquarters in Reston, VA. However, FedTec is more than just a company – we are a dedicated team of visionary individuals who understand the power of transformation. With our unwavering commitment to innovative technology and forward-focused methods, we empower government agencies to fulfill their missions successfully with our capabilities in Digital Transformation, and Cyber Security. Our strategy is rooted in in-depth advising and a unique shoulder-to-shoulder mission experience, all geared towards enabling our clients, their agencies, and every American to thrive. We use the same approach as our employees, building meaningful and lasting relationships to meet their evolving needs and help them grow. We are excited to welcome you to our family. DESCRIPTION OF SERVICES: When You Join FedTec, You Are Joining a Family! We take pride in our work and the true and transparent relationships we build with our employees and partners. We believe that positive energy attracts like-minded individuals, which is why we have such exceptional people on our team. Just as you'd do for your own family, we prioritize your safety, health, and happiness. That's why we've created the FedTec Total Well-Being program, offering benefits like: Comprehensive medical, dental, and vision plans. These plans encompass a range of beneficial features, such as Telehealth virtual care programs, and access to resources to support your physical and mental well-being. Generous paid time off for relaxation and rejuvenation. Financial security through 401k, company-paid short and long-term disability, life insurance, and additional voluntary coverage. Support for your life and family with access to an Employee Assistance Program, Pet Insurance, and Prepaid Legal services. Recognition and growth opportunities through our Rewards & Recognition and Learning & Development programs. Our newest addition, the FedTec Fit Program Position Title: SQL and Reporting Analyst (SQL Server + SSRS) Work Location: Remote (U.S. only – No offshore work permitted) Engagement Type: Contract Duration: Fulltime Position Overview: The State of Missouri’s Office of Administration is seeking an experienced SQL and Reporting Analyst to support ongoing reporting, data analysis, and documentation initiatives. The selected candidate will be responsible for developing, maintaining, and optimizing SQL queries, SSRS reports, and related documentation to support data-driven decision-making and reporting needs across multiple state programs. This role requires hands-on technical experience with SQL Server 2019 and SSRS 2016/2022, as well as strong communication, documentation, and collaboration skills. Responsibilities: • Design, write, and optimize SQL Server 2019 queries to support analytical and reporting requirements. • Develop, maintain, and enhance SSRS 2016/2022 reports for multiple business units. • Create and maintain technical specification documentation for data models, reports, and integrations. • Support the verification and validation of data outputs to ensure data accuracy and integrity. • Collaborate with business analysts, project managers, and other stakeholders to translate requirements into technical deliverables. • Apply project management practices to track and report on work progress, timelines, and deliverables. • Utilize Azure DevOps for task tracking, version control, and collaboration. • Participate in team meetings via Microsoft Teams or Webex and contribute to documentation using Visio, Microsoft Office, and Snagit. Required Qualifications: • 3+ years of experience working with SQL Server 2019. • 3+ years of hands-on SSRS report development experience (SSRS 2016/2022 preferred). • 3+ years of experience maintaining detailed technical specifications and documentation. • 3+ years of experience using Visio, Microsoft Office, Azure DevOps, Teams/Webex, and Snagit. • 3+ years of experience applying project management principles to track tasks and deliverables. • Strong analytical, problem-solving, and communication skills. • Ability to work independently in a remote team environment. Preferred Qualifications: • Prior experience working on public sector or government projects. • Experience with Power BI or other reporting/visualization tools. • Familiarity with data warehousing concepts and ETL processes. Job Type: Full-time Pay: $78,112.88 - $94,071.42 per year Work Location: Remote Apply tot his job Apply To this Job