Data Analyst - Consent Decree Program Management

At Jacobs, we're challenging today to reinvent tomorrow by solving the world's most critical problems for thriving cities, resilient environments, mission-critical outcomes, operational advancement, scientific discovery and cutting-edge manufacturing, turning abstract ideas into realities that transform the world for good.
Your impact
We are seeking a mid-level Data Analyst with 3 to 5 years of experience in data management and CMMS implementation. This role will support data integration, reporting, system configuration, and process improvement initiatives across operational and asset management systems. The ideal candidate is detail oriented, analytical, and comfortable working across technical and business teams to solve complex data challenges.
Key Responsibilities

• Support implementation, configuration, and ongoing enhancement of CMMS platforms, including Cityworks.
• Design, develop, and maintain SQL Server databases, queries, stored procedures, and views.
• Write and optimize PL/SQL for data processing and system integration tasks.
• Develop and maintain ELT processes to move and transform data between operational systems and reporting environments.
• Perform data validation, reconciliation, and quality control to ensure data accuracy and completeness.
• Build dashboards and reports in Power BI to support operational, financial, and performance metrics.
• Create, update, and troubleshoot Crystal Reports to support business and operational reporting needs.
• Develop and maintain MS Access databases and VBA scripts to automate processes and reporting tasks.
• Collaborate with DevOps and IT teams on system integrations, automation, and deployment activities.
• Document data flows, business rules, and system configurations to support long-term maintainability.
• Identify inefficiencies in workflows and propose practical, scalable improvements.

Here's what you'll need
Required Qualifications

• 3 to 5 years of experience in data management, analytics, or related technical roles.
• Hands-on experience implementing or supporting CMMS platforms, preferably Cityworks.
• Strong proficiency in Microsoft SQL Server, including T-SQL development and performance tuning.
• Experience writing and maintaining PL/SQL.
• Experience building ELT pipelines and working with structured and semi-structured datasets.
• Proficiency in Power BI for report and dashboard development.
• Experience creating, modifying, and troubleshooting Crystal Reports.
• Experience with Microsoft Access and VBA automation.
• Strong understanding of relational database design principles and data governance practices.

Preferred Qualifications

• Working knowledge of ArcGIS Pro and GIS data structures.
• Familiarity with API integrations and system-to-system data exchange.
• Experience supporting quality control processes for operational data.

Skills and Competencies

• High attention to detail with a strong focus on data accuracy and integrity.
• Ability to think critically and approach problems from multiple angles.
• Strong troubleshooting and problem-solving skills.
• Ability to translate business requirements into technical solutions.
• Effective communication skills and ability to work cross-functionally.
• Self-motivated with the ability to manage multiple priorities.

Our health and welfare benefits are designed to invest in you, and in the things you care about. Your health. Your well-being. Your security. Your future. Employees have access to medical, dental, vision, and basic life insurance, a 401(k) plan, and the ability to purchase company stock at a discount. Eligible employees may also enroll in a deferred compensation plan or the Executive Deferral Plan. Jacobs has an unlimited U.S. Personalized Paid Time Off (PPTO) policy for full-time salaried/exempt employees, seven paid holidays, and caregiver leave. And certain roles may be eligible for additional rewards, including merit increases, performance discretionary bonus, and stock.
The base salary range for this position is $70,000.00 to $100,000.00. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Job posted on March 13, 2026. This position will be open for at least 3 days.
We value collaboration and believe that in-person interactions are crucial for both our culture and client delivery. We empower employees with our hybrid working policy, allowing them to split their work week between Jacobs offices/projects and remote locations enabling them to deliver their best work.
Your application experience is important to us, and we’re keen to adapt to make every interaction even better. If you require further support or reasonable adjustments with regards to the recruitment process (for example, you require the application form in a different format), please contact the team via Careers Support.