Senior Data Engineer

Title: Senior Data Engineer Location: San Francisco, California Work Type: Hybrid Job Type: Contract Key Responsibilities: • Design, develop, optimize, and maintain enterprise data pipelines and data warehouse solutions. • Build and support ETL/ELT processes for extracting, transforming, validating, and loading data from multiple enterprise systems. • Analyze and maintain statewide statistical reporting processes and SAS-based reporting scripts. • Support migration from legacy SAS reporting solutions to modern analytics and statistical platforms. • Develop and maintain data models, data dictionaries, dashboards, and reporting artifacts. • Configure and support Snowflake, Talend Data Fabric, Azure Data Lake Storage (ADLS), and related cloud-based technologies. • Create and execute data quality assurance, validation, and governance processes. • Validate data submissions, troubleshoot integration issues, and support production operations. • Support onboarding and integration activities for new organizational units and external stakeholders. • Provide technical guidance, troubleshooting support, and training to technical teams and business users. • Maintain database objects, union views, dashboards, and enterprise reporting environments. • Produce technical documentation including functional specifications, technical designs, test plans, and process documentation. • Collaborate with project teams, business stakeholders, and leadership to communicate project status, milestones, risks, and deliverables. • Perform deployment, maintenance, and operational support activities for reporting and analytics environments. • Assist with additional operational and enhancement activities related to enterprise reporting platforms and data systems. Job Qualifications/Requirements: • 10+ years of experience in data engineering, data warehousing, business intelligence, or enterprise analytics environments. • Strong hands-on experience with: • SQL programming and database development • SAS analytics and statistical reporting • Power BI dashboard development and reporting • Data modeling and data warehouse design • Enterprise ETL/ELT tools such as Talend, Informatica, or Oracle Data Integrator • Experience implementing and supporting large-scale enterprise data warehouse and analytics solutions. • Experience with Snowflake administration, integration, and support. • Experience working with Talend Data Fabric, Azure Data Lake Storage (ADLS), cloud-based data technologies, and modern analytics platforms. • Familiarity with R programming and advanced analytics tools is preferred. • Strong understanding of: • Data governance • Data quality management • Data classifications • Data security and access controls • Experience analyzing and documenting: • Functional requirements • Business cases • Technical specifications • Communication plans • Test plans • Product lifecycle artifacts • Experience supporting production environments, troubleshooting data issues, and maintaining operational stability. • Ability to assess complex situations and develop effective problem-solving solutions. • Excellent written and verbal communication skills with both technical and non-technical stakeholders. • Strong interpersonal skills, collaborative mindset, and commitment to continuous improvement. • Experience working with project schedules, milestones, timelines, and deliverables. • Proficiency with Microsoft Office applications including Excel, Word, Project, and Visio. • Experience working within government agencies, judicial systems, or public-sector organizations is highly desirable. • Knowledge of digital government initiatives and public-sector technology strategies is a plus. • Ability to communicate clearly and effectively in English, both written and verbal.