Senior Data Specialist - Big Data (DTLA Los Angeles)

The Data Specialist Big Data will to 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.

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.