Data Engineer (GCP, Matillion)

TechDigital Group; Secaucus (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

TechDigital Group is hiring a Data Engineer in Secaucus, New Jersey. In this role, you will design and develop scalable data pipelines on Google Cloud Platform, build and optimize ETL/ELT processes, and collaborate with stakeholders to create robust analytical solutions. The ideal candidate should have expertise in SQL and data visualization tools like Quick Suite or Looker. This position plays a critical role in handling complex data requirements to improve business decision-making.

Qualifications

• Experience in designing and developing data pipelines and products.
• Proficient in Google Cloud Platform and analytics solutions.
• Ability to write efficient SQL scripts and troubleshoot data issues.

Responsibilities

• Design and maintain scalable data pipelines in GCP.
• Build ETL/ELT processes for data ingestion and transformation.
• Collaborate with stakeholders to gather requirements.

Skills

Data Pipeline Development

ETL/ELT Processes

Google Cloud Platform

SQL

Data Visualization

Tools

Google BigQuery

Dataflow

Dataform

Matillion

Quick Suite

Looker

Job description

Job Details

As a Data Engineer, you will be a key member of an agile team dedicated to designing, building, and scaling innovative business data products on a modern cloud data platform. You will collaborate closely with business stakeholders and IT partners to transform complex data requirements into robust, scalable, and reliable analytical solutions that drive business decisions.

What You’ll Do

• Design, develop, and maintain scalable and reliable data pipelines and data products within the Google Cloud Platform (GCP) ecosystem.
• Build and optimize ETL/ELT processes using tools like Dataflow, Dataform, and Matillion to ingest and transform data from a variety of sources.
• Leverage Google BigQuery to model, store, and deliver data for analytics and advanced business intelligence applications.
• Develop and maintain compelling analytics solutions for BI and data visualization platforms such as Quick Suite or Looker.
• Collaborate with stakeholders to gather requirements and translate them into detailed technical design specifications and discovery documentation.
• Write clean, efficient, and well-tested application software, including SQL scripts and procedures, ensuring it meets functional and performance requirements.
• Proactively troubleshoot, debug, and resolve data and application issues, providing post-implementation and rotational on-call support to ensure business continuity.
• Provide technical leadership and mentorship within the team, sharing expertise and promoting best practices.
• Partner with external vendors on co-development initiatives to deliver integrated solutions.
• Maintain clear and proactive communication with the Information Engineering Technical Lead and team members regarding project status, risks, and concerns.
• Ensure all solutions are compliant with departmental SOPs and contribute to process improvements.