Job Description

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. Seniority level Seniority level Not Applicable Employment type Employment type Contract Job function Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at JRD Systems by 2x Los Angeles, CA $170,000.00-$720,000.00 2 weeks ago Los Angeles, CA $170,000.00-$720,000.00 2 weeks ago Santa Monica, CA $104,600.00-$153,500.00 1 week ago Glendale, CA $104,600.00-$153,500.00 1 month ago Santa Monica, CA $95,300.00-$127,800.00 1 week ago Los Angeles, CA $141,000.00-$202,000.00 2 weeks ago Software Engineer, Game Support, Game Studio Long Beach, CA $132,000.00-$169,000.00 1 week ago Burbank, CA $79,000.00-$133,000.00 6 hours ago Santa Monica, CA $114,900.00-$168,700.00 2 days ago Commerce, CA $90,000.00-$130,000.00 1 month ago Data Analyst, Production Finance Operations & Innovation We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr JRD Systems

Job Tags

Full time, Contract work,

Similar Jobs