Description

Lead the design, build, and optimization of scalable data pipelines and financial cost allocation models within Snowflake.

This role is on-site.

Responsibilities

• Develop and maintain automated data pipelines integrating financial and operational data (GL, invoices, budgets) from enterprise sources into Snowflake.
• Partner with architects to build robust data models and semantic layers for flexible reporting and analysis.
• Write performant SQL and Python code to automate multi-layer cost allocation engines and service-level analytics.
• Implement reconciliation processes, IT controls, and data quality checks to ensure compliance and transparency.
• Utilize workflow orchestration tools (DBT, Airflow, Snowflake Tasks) and CI/CD practices for reliable releases.

Required Skills

• 5+ years of experience as a Data Engineer, with strong expertise in Snowflake.
• Advanced SQL proficiency, including window functions and CTEs for complex data transformation.
• Hands-on experience with Python for ETL/ELT processes and automation.
• Proven track record of delivering maintainable data pipelines in complex enterprise environments.
• Experience developing financial cost models, including cost allocation, recovery, and spend analysis.
• Familiarity with workflow orchestration tools such as DBT or Airflow.
• Knowledge of financial or technology operations systems (SAP, Clarity, ServiceNow, Cognos Planning).
• Strong communication skills with the ability to document solutions and collaborate with non-technical partners.

Preferred Skills

• Familiarity with Generative AI tools, such as Snowflake Cortex AI.
• Knowledge of Technology Business Management (TBM) framework and methodology.
• Strong understanding of corporate finance and accounting processes.

Key Skills

Education

Bachelor's degree