Description

Key Responsibilities:

Data Pipeline & Ingestion
• Maintain and enhance ingestion pipelines for Investran, Chronograph, NetSuite, SAP Concur, and Paylocity into a Snowflake-based data platform
• Assess and implement integration approaches for new source systems with focus on scalability, security, and maintainability
• Monitor pipeline reliability, troubleshoot failures, and improve orchestration logic
• Support third-party data ingestion using Fivetran secured through Azure NAT Gateway

Data Modeling (dbt)
• Build and enhance dbt models across bronze, silver, and gold data layers
• Develop clean and reusable consumption-layer datasets for Power BI reporting
• Create and maintain dbt tests, documentation, and data quality standards
• Support forecasting models combining actual cash flow and forecast data

Platform & Governance
• Support Snowflake administration including role/access management and performance monitoring
• Maintain governance standards, testing frameworks, and platform documentation
• Coordinate with IT teams to ensure adherence to information security policies
• Provide ongoing technical support as reporting and analytics usage expands

Stakeholder Collaboration
• Act as a technical point of contact for enterprise data products
• Partner with finance, accounting, and business analysts to gather and translate reporting requirements
• Participate in feedback sessions, model validation, and enablement activities
• Support migration from Excel-based reporting to centralized Power BI solutions

Required Skills:
• Snowflake
• dbt
• SQL
• Power BI
• Fivetran
• Azure Cloud / Azure NAT Gateway
• ETL / Data Pipeline Development
• Data Warehousing Concepts
• Financial & Accounting Data Modeling

Preferred Qualifications:
• Experience with forecasting and cash flow datasets
• Strong analytical and troubleshooting skills
• Excellent communication and stakeholder management skills
• Experience working in enterprise analytics environments

Key Skills

Education

Bachelor's degree