JOBSEARCHER

SQL Reporting Programmer Analyst

State of MaineRemote - must be located in EST time zone
Pay: $60/hr c2c*Must submit w/ last 5 SSN and MM/DD of birthday*Must have prior State or Government experience Looking for a senior SQL reporting programmer analyst with state government experience. Candidates can work remotely from home in the Eastern Time zones.
Position Overview: This role supports a major data system enhancement effort and focuses on developing high quality SQL based reports, documenting reporting requirements, and enabling intuitive self-service reporting for end users. The position involves building new reports, validating existing ones, mapping UI fields to database structures, and supporting a planned system enhancement for a new program. You'll also handle time sensitive ad hoc data requests that require direct database access. This is a hands-on reporting and documentation role that blends SQL development, requirements analysis, and collaboration with business and technical stakeholders. Top Responsibilities Reporting Development Develop and validate new reports using SQL Server Reporting Services (SSRS) and SQL Server Report Builder Create recurring subscriptions, intuitive self-service reports, and reusable Visual Studio report templates Build and optimize SQL queries to support reporting needs Complete ad hoc data requests for information not available through the user interface Requirements & Documentation Gather and interpret functional reporting requirements Document report design, including UI to database field mapping and schema references Produce clear technical documentation covering design, logic, and implementation Support reporting needs associated with upcoming system enhancements Self Service Reporting & User Support Promote and support self service reporting capabilities Assist users in understanding available data and report functionality Provide guidance on report usage and data interpretation Experience with analytic tools such as Tableau Server is a plus Core Technologies & Tools Reporting & DataSQL Server, SSRS, SQL Server Report Builder Visual Studio report development Oracle 11g, Toad for Oracle (v11.6-12.1), SQL Optimizer Tableau Server (preferred) Application Modernization (Front End & Middleware) This environment includes ongoing modernization of a legacy application stack. Candidates should be comfortable working alongside teams modernizing: HTML4/5, CSS3, JavaScript to meet W3C and ADA compliance Java 6+ applications using Eclipse Kepler and WebLogic 11gLegacy Windows 7 environments Agile or similar project management frameworks Required Skills & Competencies TechnicalStrong SQL development and report building experience Ability to convert complex technical or analytical problems into computable formats Experience preparing flowcharts, block diagrams, and structured logic Understanding of system capabilities, constraints, and data structures Ability to identify when enhancements or modifications are needed Communication & Collaboration Excellent written and verbal communication skills Ability to work with business and technical teams to clarify requirements Skilled at translating business needs into actionable technical solutions Comfortable documenting processes, logic, and design decisions
Ideal Candidate Profile: You thrive in environments where reporting, data structure understanding, and documentation intersect. You're comfortable working with both SQL Server and Oracle tools, enjoy building clean and intuitive reports, and can communicate clearly with stakeholders. You're also adaptable enough to work within a legacy modernization environment and contribute to improving reporting capabilities across the organization.