Job description

Job Title: Data Specialist - Big Data | Hybrid Location: Alhambra, CA 91803 (Hybrid - 2 days onsite, 3 days remote) Duration: 12 Months Job Description: • The Data Specialist – Big Data will lead the design, development, and management of an enterprise data warehouse architecture. • The role is critical to enabling data-driven decision-making across an organization by integrating data from multiple business systems—both on-prem and in the cloud—and transforming it into a reliable, well-documented, and easily accessible source for reporting and analytics. • The Data Specialist – Big Data will take full ownership of a data warehouse; maintain documentation on the data warehouse architecture, datasets, data dictionaries and data flows; ensure seamless data ingestion and transformation; support business users in accessing insights through Power BI and other reporting tools; and plan and drive the transition to a modern analytics platform for SAPC. Skills: • Strong SQL skills and in-depth experience with SQL/T-SQL, and SSIS. • Solid understanding of data modeling, metadata management, and data lineage using tools such as Azure Data Lake Storage Gen2, Azure Data Factory, Azure Synapse. • Familiarity with ETL/ELT tools as Azure Data Factory, Azure Synapse. • Database development and administration skills using SQL Server, Cache or InterSystems IRIS. • Proficiency in Power BI (including gateway setup for hybrid environments) and experience building interactive dashboards. • Familiarity with Crystal Reports and legacy reporting systems. • Demonstrated ability to work with both technical and business users and to translate business needs into scalable data solutions. • Strong communication, documentation, and problem-solving skills. • Experience working in hybrid environments (on-prem and cloud) and managing secure data integration. • Knowledge of data privacy and compliance frameworks (e.g., HIPAA, 42 CFR Part 2). • Familiarity with CI/CD pipelines for data integration and deployment. • Background in public health, government, or healthcare IT. Experience Preferred: • 8+ years of progressively more responsible, full-time, paid experience in a centralized Information Technology organization performing information systems analysis and design for complex systems. • 4+ years of hands-on experience in two or more of the following fields: data engineering, database administration, BI development, or data architecture. • 4+ experience designing and managing data warehouse/data lakes in Azure (Data Lake Storage Gen2, Synapse, Azure Data Factory). • 4+ Experience with Azure Purview, Azure Synapse, Azure Data Factory or similar data catalog/governance tools. • 4+ Experience with database management systems, to include SQL Server, Cache or InterSystems IRIS, Azure Data Lake Storage Gen2. Education Preferred: • Bachelor's degree in Computer Science, Information Systems, or a closely related field. Additional Information: • Please note that the work location is 1000 S Fremont Ave, Building A9 East, Alhambra, CA 91803. • The work schedule is hybrid, 2 days onsite, 3 days remote.

Requirements