Azure Data Engineer- w2 Position Only.-Local To CA

Job Description

**Job Role: Data Specialist – Azure Data Engineer**

**Location: Los Angeles, CA (Hybrid)**

**Duration: 12 12-month contract**

**Is this role located on-site, hybrid, or remote?: Hybrid**

**Is a Livescan Required for Position?: Yes**

**We can do h1b transfer after the offer.**

**Skills Preferred:**

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.

**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 at 1000 S Fremont Ave, Building A9 East, Alhambra, CA 91803. The work schedule is hybrid, 2 days onsite, 3 days remote.