Support Analyst

Duties: The Support Analyst is responsible for the design, development, implementation, and ongoing support of enterprise reporting solutions and data analytics for the City's Enterprise Resource Planning (ERP) systems. This position combines advanced technical expertise in database management, SQL programming, and business intelligence tools with a strong understanding of governmental accounting principles and financial operations. The role requires the ability to analyze complex business needs and translate them into effective technical solutions that enhance reporting accuracy, streamline processes, and improve operational efficiency. The Support Analyst plays a critical role in ensuring data integrity, resolving system and integration issues, and optimizing performance across multiple platforms. Success in this position requires strong collaboration with Finance, IT, and other City departments to deliver reliable, timely, and meaningful reporting. The Support Analyst supports compliance with Governmental Accounting Standards Board (GASB) requirements and other regulatory standards while contributing to the City's digital transformation initiatives through innovative data solutions and continuous process improvement. Report Development & Programming: Design, develop, test, and maintain custom reports, scripts, and data solutions to meet organizational needs. Write complex SQL queries, stored procedures, and database objects for data extraction, transformation, and analysis. Develop automated and scheduled reporting processes using tools such as SSRS, Power BI, Crystal Reports, Cognos, or similar. Create dashboards and data visualizations that provide actionable insights for leadership and stakeholders. Optimize report performance and ensure efficient data retrieval from enterprise systems. ERP System Support & Data Management: Provide advanced technical support for the City's ERP financial systems. Troubleshoot system issues, data discrepancies, and integration challenges. Conduct system testing, validation, and quality assurance for financial processes. Enhance system functionality through configuration improvements and technical solutions. Maintain data integrity across modules including General Ledger, Accounts Payable, Accounts Receivable, Payroll, Budget, and Fixed Assets. Financial Data Migration & Compliance: Support and execute data migration initiatives following industry best practices. Ensure compliance with GASB standards and applicable federal, state, and local regulations. Assist in preparing financial reports, disclosures, and audit documentation. Collaborate with Finance to maintain internal controls and audit readiness. User Training & Documentation: Provide technical support and guidance to ERP users across departments. Develop user manuals, training materials, and standard operating procedures. Conduct training sessions for users with varying levels of technical expertise. Promote and support self-service reporting capabilities. Project Management & Process Improvement: Track and report project progress, timelines, and deliverables. Document system configurations, workflows, and technical specifications. Participate in ERP upgrades, enhancements, and implementations. Identify opportunities for automation and process improvements. Collaborate with cross-functional teams to gather requirements and deliver solutions. Administrative & Financial Support: Coordinate vendor services, maintenance agreements, and contract renewals. Process purchase requests and maintain procurement documentation. Assist with IT budget preparation and expenditure tracking. Reconcile vendor invoices and ensure timely payments. Track telecommunications expenses and maintain accurate records. Quality Assurance & Compliance: Ensure all reporting solutions meet data governance and City standards. Validate data accuracy and reliability through quality control processes. Perform periodic audits of reports and data workflows. Maintain confidentiality of sensitive information. Support internal and external audit activities. Professional Development & Collaboration: Manage multiple priorities with strong organizational and time management skills. Communicate effectively with both technical and non-technical stakeholders. Apply analytical thinking to solve complex problems. Stay current with emerging technologies and industry best practices. Build collaborative relationships across departments. General: Must have and maintain, without interruption, required certifications and licenses. Works assigned schedule and complies with the City's timekeeping and attendance policies. Performs other related duties as assigned.

Qualifications: Bachelor's degree in Information Technology, Computer Science, Information Systems, Accounting, or a related field or equivalent combination of education and experience. Minimum of five (5) years of experience in report development, database programming, SQL administration, or ERP system support. Working knowledge of accounting functions including general ledger, payroll, accounts payable/receivable, budgeting, and financial reporting PREFERRED: Experience working in a governmental or public sector environment. Experience with ERP system implementation or upgrades. Knowledge of GASB standards and governmental accounting practices. Relevant certifications (e.g., Microsoft, Power BI, SQL, or ERP-related certifications)

The City of Pasadena offers very generous benefits to all full-time employees. For example:

• Employee-only medical insurance starts as low as $15 per month and the most expensive Employee & Family plan is less than $350 per month.
• The City has its own medical clinic staffed with a M.D. and two medical assistants. Employees and their covered dependents over the age of 5 can visit the clinic FREE OF CHARGE.
• Employees and their covered dependents also have access to Virtual Visits with a medical professional FREE OF CHARGE.
• The City offers college tuition reimbursement of up to $3,500 per year.
• As an employee, you will contribute a portion of your salary each pay-period towards your retirement and the City will match your contribution by 200%. Example, if you contribute $100, the City will contribute $200.
• Civilian employees accumulate vacation at the following rates:
  • Less than 6 years of service - two weeks of vacation per year.
  • From 6 to less than 11 years of service - three weeks of vacation per year.
  • From 11 to less than 21 years of service – four weeks of vacation per year.
  • From 21 to less than 26 years of service – five weeks of vacation per year.
  • From 26 years of service and up – six weeks of vacation per year.