Senior Data Engineer – Cloud Data Products & Analytic Enablement

Company :Highmark HealthJob Description : JOB SUMMARY***CANDIDATE MUST BE US Citizen (due to contractual/access requirements)***As a Senior Data Engineer – Cloud Data Products & Analytic Enablement, you will be instrumental in transforming diverse data sources into actionable intelligence, empowering critical business decisions across our organization and within our application ecosystem. This pivotal role demands a strong foundation in data engineering principles, combined with a keen focus on analytical engineering to unlock the full potential of our data assets.You will leverage your deep expertise in Google Cloud Platform (GCP) technologies, including Managed Airflow (Cloud Composer), BigQuery, Cloud Run Functions, DataFlow, DataProc, and DataPlex, to design, build, and optimize scalable data pipelines. Your work will encompass the entire data lifecycle from ingestion and processing to modeling and orchestration, ensuring the highest standards of data quality, performance, and governance.A core aspect of this role involves translating complex engineered data into readily consumable, business-ready insights. You will achieve this by developing curated datasets and robust analytical assets. Success in this position requires exceptional proficiency in SQL and Python, coupled with the ability to strategically partner with diverse stakeholders, translating intricate business requirements into impactful, scalable data products.ESSENTIAL RESPONSIBILITIESDesign, develop, and maintain robust data processes and solutions to ensure the efficient movement and transformation of data across multiple systemsDevelop and maintain data models, databases, and data warehouses to support business intelligence and analytics needsCollaborate with stakeholders across IT, product, analytics, and business teams to gather requirements and provide data solutions that meet organizational needsMonitor work against production schedule,provide progress updates, and report any issues or technical difficulties to lead developers regularlyImplement and manage data governance practices, ensuring data quality, integrity, and compliance with relevant regulations.Collaborate on the design and implementation of data security measures, including access controls, encryption, and data maskingMentor other associate and intermediate data engineers as neededPerform data analysis and provide insights to support decision-making across various departmentsStay current with industry trends and emerging technologies in data engineering, recommending new tools and best practices as neededOther duties as assigned or requested.EXPERIENCERequired5 years of experience in design and analysis of algorithms, data structures, and design patterns in the building and deploying of scalable, highly available systems5 years of experience in a data engineering, ETL development, or data management role.5 years of experience in SQL and experience with database technologies (e.g., MySQL, PostgreSQL, MongoDB).5 years of experience in data warehousing concepts and experience with data warehouse solutions (e.g., Snowflake, Redshift, BigQuery)Preferred7+ years of experience in designing, developing, and meticulously implementing robust data solutions, encompassing sophisticated structuring and transformation of data from diverse, complex source systems.7+ years of experience in producing high-quality, efficient, and maintainable data-related code that underpins critical stakeholder applications.7+ years of experience working across a multitude of technology systems, consistently designing innovative solutions or developing impactful data solutions specifically within the complex healthcare or insurance industry.7+ years of experience in strategically translating intricate business requirements, design mockups, prototypes, and user stories into precise technical designs and highly impactful, scalable data solutions.7+ years of experience with both SQL and Python, utilizing these languages for sophisticated data manipulation, advanced analytical insights, and the development of resilient data pipelines.5+ years of experience leveraging core GCP data services, including BigQuery, DataFlow, Cloud Composer (Managed Airflow), DataProc, and Cloud Run, optimizing their use for cloud-native data architectures.5+ years of experience with traditional on-premise database systems, including Oracle, Teradata, and DB2, bridging legacy and modern data landscapes.5+ years of experience operating within Unix/Linux environments, including scripting and system-level data operations.Possesses proven, hands-on experience with dbt (data build tool) for advanced data transformation and the development of sophisticated analytical data models.Experienced with cutting-edge data virtualization tools such as Starburst (Trino) or other composable data platforms, enabling unified access to distributed data assets.Skilled in leveraging advanced data quality engines (e.g., Monte Carlo, Soda) to ensure proact