Senior Data Analyst/Data Solutions Developer

Position SummaryWe are seeking an experienced Senior Data Analyst/Data Solutions Developer who lives within 70 miles of Sacramento, CA. Will need to go to the office,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. Experience with Agiline aiWorks is highly desirable.Key ResponsibilitiesBusiness & Data AnalysisAnalyze 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.Enterprise Data Warehouse DevelopmentDesign 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.Key Competencies:Reverse engineering and business process analysisAdvanced SQL and database developmentEnterprise Data Warehouse design and implementationReport and dashboard modernizationUser interface and user experience designAnalytical problem solvingStakeholder communication and requirements gatheringReporting & Dashboard DevelopmentDevelop 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.Platform & Solution DevelopmentWork 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.Required Qualifications5+ 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.Technical SkillsExperience 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 reconciliationApplication Development: Agiline aiWorks, Web-based UI design and development, Forms and workflow applications, , Dashboard and portal development, Low-code / no-code platforms