Data Solutions Developer

Title: Senior Data Analyst /Data Solutions Developer

End Client : State of California
Location : Sacramento, CA area. Hybrid work, some on-site meetings may be required by the client
Visa : USC and GC only

Position Summary
We are seeking an experienced Senior Data Analyst/Data Solutions Developer in the Sacramento, CA, area. Will analyze, reverse-engineer, document, and modernize existing reports, dashboards, data interfaces, and business applications. The ideal candidate possesses advanced SQL expertise, strong analytical skills, and the ability to translate complex legacy reporting and operational systems into scalable Enterprise Data Warehouse (EDW) solutions.
This role requires a unique combination of data analysis, business process understanding, database development, reporting, UI/UX design, and application development skills. The successful candidate will work closely with business stakeholders to understand existing systems and recreate or enhance them using modern data platforms and reporting tools.

Key Responsibilities

Business & Data Analysis

• Analyze and reverse engineer existing reports, dashboards, data extracts, interfaces, and business applications.
• Document data flows, business rules, calculations, transformations, and reporting requirements.
• Work directly with business users to understand operational processes and reporting needs.
• Identify opportunities to consolidate, modernize, and improve existing reporting solutions.

• Design and develop SQL-based solutions within enterprise data warehouse environments.
• Translate legacy reporting logic into optimized EDW structures and reusable SQL components.
• Develop complex SQL queries, views, stored procedures, and data models.
• Validate data accuracy through reconciliation and comparison against existing systems.

• Reverse engineering and business process analysis
• Advanced SQL and database development
• Enterprise Data Warehouse design and implementation
• Report and dashboard modernization
• User interface and user experience design
• Analytical problem solving
• Stakeholder communication and requirements gathering

• Develop modern reports, dashboards, scorecards, and analytical applications.
• Recreate legacy reports while improving usability, performance, and maintainability.
• Build executive, operational, and ad-hoc reporting solutions.
• Design intuitive and visually effective user interfaces for reporting and analytics.
• Design and implement data-driven user interfaces and business applications.
• Develop forms, dashboards, workflow screens, and operational portals.
• Create user-friendly experiences across multiple technology platforms.
• Collaborate with stakeholders to improve usability and business adoption.

• Work across multiple databases and application platforms.
• Support migration of reporting and analytical solutions from legacy systems to modern architectures.
• Utilize Agiline aiWorks , similar or related technologies to build data-driven applications and automation solutions.

• 5+ years of experience in data analysis, reporting, business intelligence, or application development.
• Expert-level SQL development skills.
• Strong experience in analyzing and documenting existing systems and business processes.
• Experience designing and developing reporting and dashboard solutions.
• Ability to understand complex data structures and business rules.
• Strong problem-solving, analytical, and communication skills.

• Experience with Agiline aiWorks is highly desirable.
• Database Platforms: Microsoft SQL Server, Oracle Database, PostgreSQL, Azure SQL Database, MySQL (preferred)
• Data & Analytics: Advanced SQL development, Data warehousing concepts, Data modeling and business rule implementation, Report and dashboard development, Data validation and reconciliation
• Application Development: Agiline aiWorks, Web-based UI design and development, Forms and workflow applications, , Dashboard and portal development, Low-code / no-code platform,