Senior Data Engineer

Penbrothers; India; Hybrid; INR 1,200,000 - 1,600,000; Full time

Job summary

Penbrothers is seeking a Data Engineer to join the Financial Systems team in India. You will design, build, and maintain a Finance Data Warehouse to support financial reporting and compliance. This hybrid role requires strong Snowflake expertise, SQL skills, and collaboration with finance stakeholders.

Your work will have a significant impact on financial accuracy and decision-making. The position involves developing ELT pipelines, ensuring data quality, and building finance-specific data models with advanced analytical capabilities.

Qualifications

• 5+ years of experience in data engineering or data warehouse development.
• Strong hands-on experience with Snowflake, including warehouse design and performance tuning.
• Advanced SQL skills with experience writing and optimizing complex queries.

Responsibilities

• Design, build, and maintain a Finance Data Warehouse in Snowflake.
• Develop and manage ELT pipelines using tools like Fivetran and dbt.
• Ensure data integrity, quality, and reconciliation across source systems.

Skills

Data warehouse development

Snowflake

SQL

ELT pipelines

Tableau

Tools

Fivetran

dbt

Job description

About the Role

We are looking for a Data Engineer to join our Financial Systems team and help design, build, and scale a Finance Data Warehouse that will serve as the foundation for financial reporting, analytics, compliance, and future AI-driven use cases.

This role will be instrumental in standing up a finance-specific data layer sourced from systems like NetSuite (ERP), Salesforce (CRM), billing platforms, vendor management tools, and other financial data sources. You’ll work closely with Accounting, Financial Operations, FP&A, and Data Analytics partners to ensure financial data is accurate, well-modeled, and analytics-ready.

This is a hybrid role that blends hands‑on data engineering with thoughtful data modeling and close business partnership.

Work set-up

Work from home: 100%

Work schedule: Night Shift (Regular 9 hours per day, 5 days a week)

Work hours: 11:00 PM – 8:00 AM (PH time)

What you’ll do (duties and responsibilities)

• Design, build, and maintain a Finance Data Warehouse in Snowflake, optimized for financial reporting, analytics, and AI/ML use cases.
• Develop and manage ELT pipelines using tools like Fivetran and dbt to ingest, transform, and model data from finance and business systems.
• Own finance‑specific data models (e.g., GL, revenue, expenses, vendors, customers) with a strong focus on accuracy, consistency, and traceability.
• Partner with Accounting, Financial Operations, FP&A, and Data and other teams to translate business requirements into scalable data models and datasets.
• Ensure data integrity, data quality, and reconciliation across source systems and downstream reporting.
• Optimize Snowflake performance and cost through thoughtful warehouse design, query tuning, and efficient transformations.
• Implement and maintain data governance, metadata management, and documentation to support SOX compliance and audit needs.
• Support downstream use cases including Tableau dashboards, ad‑hoc analytics, and future AI/data‑mining initiatives.
• Monitor, troubleshoot, and improve data pipelines to ensure reliability and timeliness.
• Collaborate closely with other data engineers and platform teams to align with broader data architecture standards.

What You Bring (skills, qualifications or experience)

• 5+ years of experience in data engineering or data warehouse development.
• Strong hands‑on experience with Snowflake, including warehouse design, performance tuning, and cost optimization.
• Advanced SQL skills with experience writing and optimizing complex queries.
• Experience using dbt for data transformations, testing, and modeling.
• Solid understanding of data warehousing concepts, dimensional modeling, and metadata management.
• Experience building and maintaining reliable ELT/ETL pipelines in a cloud environment.
• Experience preparing data for advanced analytics and AI/ML use cases.
• Familiarity with BI tools such as Tableau and how they connect to data warehouses.
• Strong communication skills and the ability to work closely with non‑technical finance stakeholders.

Nice to Have (not required skills, but would be an added advantage)

• Experience working with financial systems such as NetSuite (ERP), billing platforms, or vendor management tools.
• Exposure to SOX controls, audit support, or finance compliance requirements.
• Experience using Snowflake features and AI/ML capabilities.
• Python experience for automation, orchestration, or pipeline enhancements.

Why This Role Matters

• You’ll help stand up a net‑new Finance Data Warehouse, not just maintain an existing one.
• Your work will directly impact financial reporting accuracy, audit readiness, and executive decision‑making.
• You’ll play a key role in enabling scalable analytics and future AI‑driven finance insights.
• You’ll partner deeply with Finance while still working on modern data tooling and architecture.