Data Engineer

Location: Holmdel

Job Description Guardian is seeking a Data Engineer to join the team responsible for establishing and maintaining an optimized, scalable data pipelines to provide access to high quality, consistent data in an easy and convenient manner to all authorized end users and applications of Guardian and its subsidiaries. As a Data Engineer, you will play a vital role in our data infrastructure and analytics ecosystem.

You will work closely with data architects and data scientists to build and maintain data pipelines, transform raw data into actionable insights, and contribute to the development of cutting-edge data solutions. This is an excellent hands-on opportunity to experience the latest technologies and make a significant impact on our data-driven initiatives. The position will integrate new data sources from enterprise sources and external vendors using a variety of ingestion patterns including Structured Query Language (SQL) Ingestion, File, and Application Programming Interfaces (APIs).You

will Collaborate with cross-functional teams to understand data requirements and translate them into effective data pipelines.

Design and maintain reliable batch and real-time ingestion pipelines for databases, files, APIs, event streams, and third-party data sources, including schema evolution, error handling, and data quality controls.

Develop and operationalize scalable data pipelines using Python, PySpark, and SQL to transform ingested data into curated, trusted, and business-ready data assets.

Leverage Databricks to build, orchestrate, optimize, and govern production-grade data pipelines and data assets.

Build governed, high-quality data assets that support analytics, machine learning, and generative AI use cases.

Design scalable dimensional and domain-oriented data models, define schemas and data contracts, and optimize data structures for performance and usability.

Implement observability, automated data-quality checks, and proactive alerting to ensure pipeline reliability, performance, and compliance with service-level objectives.

Participate in code reviews, testing, and documentation efforts to maintain high-quality code and data documentation.

Stay updated on industry trends and best practices in data engineering.

Continue to look for innovative and next generation solutions for solving data challenges. You areA self-starter, self-motivated team player and have excellent communication skills, enabling you to engage with all levels of stakeholders who is fueled by collaboration, able to transform conceptual designs into reliable, scalable processes that meet or exceed customer needs. An individual who works closely with IT and business leaders across the enterprise to drive and embed the Enterprise Data Strategy into transformational roadmaps ensuring key principles of Data Governance, Data Management, Data Analytics and Architecture are implemented.

You have
10+ Years of IT experience, with 5+ years of experience as a Data Architect, data engineer or other data professional

Expert knowledge of relational and No

SQL database concepts, with hands-on experience across PostgreSQL, Oracle, Databricks, and cloud-native data stores.

Expert proficiency in logical, physical, dimensional, and domain-oriented data modeling, including schema design and data contracts; experience with enterprise modeling tools is preferred.

Extensive hands-on data engineering experience with distributed data processing and lakehouse technologies, including Python and PySpark on the Databricks platform. Hands-on experience designing and optimizing large-scale data pipelines and data-warehouse architecture using batch and incremental processing, change data capture, orchestration, and schema evolution.

Experience with AWS data…