Data Engineer IRC293384

Description

The client is one of the fastest-growing NYC-based tech companies that is on a unique mission to
empower America’s workforce to take control of their financial lives by disrupting archaic payroll
processes and their consequences. Through rich and seamless partnerships with our clients, we have
become the pioneers in providing employees real-time access to earned wages daily – across all
industries – so employees can pay bills on time and avoid late fees and payday loans.
Client’s most important asset, our people, makes our mission possible. We come together through
collaboration and ambition in a team-driven culture. As a result of the success we’ve seen, we are
going through huge growth and are constantly looking for exceptional talent to join us. You will learn,
grow, and take things on and make them your own. We can’t wait for you to join us in our journey –
apply now!

Seeking Senior Data Engineer(s) with a strong Analytics Engineering background for a dedicated finance data structuring and automation project. The primary objective is to audit existing business logic, currently scattered across legacy SQL, Excel workflows, and BI reports (Metabase, Tableau), and reverse-engineer it into a centralized, scalable layered data architecture.
This role will be responsible for building well-structured data models in Snowflake using dbt, and ultimately developing the automated pipelines, custom scripts, or reverse ETL flows necessary to export this finalized data directly into NetSuite or other enterprise ERP/accounting systems.

Requirements

Required Skills (Must Haves)
Senior-Level Expertise: 5+ years of experience in Data Engineering or Analytics Engineering, with a proven track record of owning end-to-end data modeling and integration projects.
Cloud data warehouse: Experience with modern cloud data warehouses or lakehouse platforms ( Snowflake preferable, Databricks, BigQuery or Redshift acceptable).
Excellent SQL: Advanced to expert-level SQL capabilities; highly proficient in complex pipeline analysis, query optimization, and cost-efficient query design.
Legacy & BI Reverse-Engineering: Proven experience reverse-engineering undocumented logic from existing BI tools, complex Excel sheets, and legacy SQL into modernized pipelines.
Layered Architecture: Strong understanding and practical experience building Medallion (Bronze/Silver/Gold) data environments.
Preferred Skills (Nice to Haves)
Snowflake & dbt Mastery: Deep, hands-on experience building models in Snowflake and managing transformations/testing via dbt (Core or Cloud).
Semantic Layers: Experience building dbt or Snowflake semantic views.
Finance Domain Knowledge: Familiarity with accounting principles, ERP data structures, and how finance teams consume data.
ERP Integration Experience: Hands-on experience structuring data and managing automated payloads/exports into enterprise accounting packages or ERPs (e.g., NetSuite, Workday, SAP).
Reverse ETL: Experience with data activation / reverse ETL tools such as Hightouch or Census.
Advanced Pipeline Orchestration: Proven experience designing fault-tolerant, automated data pipelines using modern orchestration tooling.
API & Integration Scripting: Proficient in Python (or similar) to build custom API connectors and automate the export of data into external systems.
AI Implementation: Demonstrated success delivering tangible value by integrating AI into data engineering workflows. Prefer Claude, but can work with any background that can quickly translate to our AI tools.

What We’re Looking For
Someone who is highly pragmatic and comfortable working with imperfect, real-world data.
Able to move quickly from ambiguity to structured solutions.
Strong communicator who can work closely with finance, product management and non-technical stakeholders.
Takes ownership of both data quality and scalable platform design.
Comfortable working in an evolving environment and helping define best practices.

 

Job responsibilities

Key Deliverables & Responsibilities
Rapid Onboarding: Quickly get up to speed with existing data architecture, snapshotting, reporting logic, and business workflows.
Reverse Engineering: Analyze and reverse-engineer legacy reports, queries, Excel-based processes, and existing BI dashboards (Metabase, Tableau) to understand current logic.
Data Modeling: Design and build scalable, well-structured data models within Snowflake using dbt.
ERP Pipeline Automation: Develop and maintain data pipelines to transform and deliver data directly into accounting and finance systems (e.g. NetSuite).
Schema Design: Build new schemas to support finance processes and downstream integrations.
Must actively leverage AI methodologies and modern tooling to optimize system performance, enhance alerting infrastructure, and deliver data products that empower data-driven decisions
Business Alignment: Translate business and finance requirements into clean, reusable datasets.
Self-Service Enablement: Enable self-service analytics through well-documented and reliable data models.
Architecture Implementation: Implement and maintain a layered data architecture (e.g., bronze/silver/gold).
Cost-Conscious Development: Write efficient, well-structured SQL in Snowflake with awareness of cost implications (query design, data scanning, warehouse usage).
Performance: Optimize SQL queries and overall data performance across the platform.
Data Activation & Export: Support data activation and operational use cases via custom API/Python scripting or reverse ETL tools such as Hightouch.

What we offer

Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you’ll experience an inclusive culture of acceptance and belonging, where you’ll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders. 

Learning and development. We are committed to your continuous learning and development. You’ll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally.

Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you’ll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what’s possible and bring new solutions to market. In the process, you’ll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today.

Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way!

High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you’re placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do.

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.