Solution Architect Data Engineering

Description
Bristlecone Inc.s Data Services Delivery team seeks a senior data architect who can bridge finance expertise with modern data engineering. You will own the design of target architectures for client finance data guiding data from ERP and subledger sources through rigorous modeling testing and reconciliation so the Controllers office and FP&A can rely on accurate timely information at monthend close. This clientfacing role splits your time between highlevel design/review and handson development using SQL dbt and Python.

• Design endtoend finance data architectures from ERP/subledger extraction to Snowflake warehouse delivery.
• Lead data modeling testing and reconciliation processes to ensure monthend reporting accuracy.
• Develop and maintain Snowflake schemas tables and performancetuned queries.
• Build test and document dbt models that translate raw finance data into trusted analytics.
• Write Python ETL scripts for data ingestion transformation and validation.
• Collaborate with Controllers FP&A and other finance stakeholders to capture requirements and translate them into technical designs.
• Produce clear architecture diagrams data dictionaries and technical documentation for client teams.
• Conduct client workshops and presentations to explain data flows journal entry mappings and warehouse configurations.
• Ensure data security governance and compliance with industry standards.
• Mentor junior engineers and promote best practices in data engineering and finance domain knowledge.

• 8 years of data engineering or data architecture experience with at least 5 years focused on finance data platforms.
• Deep expertise in Snowflake architecture including clustering micropartitions and rolebased security.
• Advanced SQL proficiency and handson experience with dbt for data transformation.
• Strong Python programming skills for building ETL pipelines and automation.
• Handson experience extracting data from ERP systems such as Oracle SAP or Workday.
• Solid understanding of accounting concepts journal entries and monthend close processes.
• Proven clientfacing consulting experience able to communicate complex technical ideas to business audiences.
• Track record of designing documenting and delivering endtoend data solutions that meet strict accuracy and performance requirements.
• Experience with data testing frameworks CI/CD pipelines and version control (Git).
• Excellent written and verbal communication skills with the ability to produce clear technical documentation.

Required Experience:

Staff IC