Senior Data Engineer

Penbrothers

16d•Remote

About The Position

Penbrothers is seeking a Data Engineer to join their Financial Systems team. The role involves designing, building, and scaling a Finance Data Warehouse using Snowflake. This data warehouse will be the foundation for financial reporting, analytics, compliance, and future AI-driven use cases. The position requires creating a finance-specific data layer sourced from systems like NetSuite (ERP), Salesforce (CRM), billing platforms, and vendor management tools. The Data Engineer will collaborate 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 combining hands-on data engineering, data modeling, and business partnership. The work setup is 100% remote, with a night shift schedule from 11:00 PM to 8:00 AM PH time, aligned with US Business Hours/US Central Time.

Requirements

Minimum of 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 Haves

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.

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.