Job Overview Our client in the Bedminster area of NJ has an excellent opportunity for a Data Engineer! You are expected to be in the office one or two days a week. Responsibilities: Build data pipelines / data orchestrator and data structures for existing operational data stores, Azure data lake & data warehouse. Develop proof-of-concepts to evaluate new technologies and suggest improved and better ways to re-architect existing data loading processes and data structures. Design and develop ELT / ETL to load data from internal sources into operational data stores, Azure data lake and data warehouse. Create APIs, data structures and schemas to store and retrieve data. Create and maintain data mappings, data definitions, architecture, and data flow diagrams. Implement solutions to validate and test data quality. Build proof-of-concepts to determine viability of new processes and technologies. Deploy and manage code in non-prod and prod environments. Troubleshoot data related issues and fix defects. Optimize and performance tune databases and queries. Participate in code reviews and train other team members. Document code and create code templates based on industry best practices. Requirements: Bachelor’s Degree and/or equivalent experience required. Minimum 5 years of experience working as a Data Engineer, ETL Engineer, Data/ETL Architect or similar roles. 5+ years of solid continuous experience in Python. 3+ years of continuous experience with Airflow. 3+ years of experience with Azure Data Factory (ADF) or similar. 3+ years of experience working with relational databases: Oracle, SQL Server, PostgreSQL, or similar. 3+ years of experience working with NoSQL databases: MongoDB, Cosmos DB, DocumentDB or similar. 3+ years of experience writing SQL code. 3+ years of experience in Kimball Dimensional Modeling (Star-Schema). 2+ years of experience in columnar databases: Snowflake, Azure Synapse, or similar. 2+ years of Azure experience. Job Detail Shortlist Apply Now Apply with Linkedin Never pay anyone for job application test or interview. Related Jobs (10) Asterisk PBX Developer Full Time Business Continuity / Disaster Recovery Operational Resilience Analyst Full Time IT Systems Operations Manager Full Time PMO Project Manager Full Time EDI / ERP Specialist Full Time SAP Procure-to-Pay (PTP) Systems Analyst Full Time System Administrator Full Time Microsoft Dynamics 365 Sales (CRM) Enterprise Applications Support Analyst Full Time SAP BODS (Business Objects Data Services) Specialist Full Time Lead .Net Full-Stack Developer / Engineer Full Time Contact You accepts our Terms and Conditions
