Penbrothers · 6 hours ago
Senior Data Engineer
United States
Full-time
Hybrid
Senior Level
5+ years expPenbrothers is an HR & remote talent management partner, and they are seeking a Senior Data Engineer to join their Financial Systems team. The role involves designing, building, and scaling a Finance Data Warehouse for financial reporting and analytics, while collaborating closely with various teams to ensure data accuracy and integrity.
Outsourcing/Offshoring
No H1B
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
Qualification
Required
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
Preferred
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
Benefits
Meaningful work & Growth: We take every opportunity to stretch ourselves and deliver an excellent client experience.
Employee as our biggest asset: We are genuinely invested in our people’s career and welfare.
Global reach & local impact: Get to work with high-growth startups and dynamic companies from the comfort of your own home.
Powering global startups: We’ve created 1,400 Filipino jobs that empower global start-ups to focus on growth.
Company
Penbrothers
We are Penbrothers, your remote HR partner! We work with startups and SMEs worldwide, helping them build and scale their teams with talent in the Philippines at a fraction of the cost.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase