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.