Data Modeling Architect - Financial Analytics :: Houston,TX :: Contract Job at SS33 Business Services LLC, Houston, TX

bHMyR3Nyb3J6WU9wVGlTM2FuTWJ6emxxUmc9PQ==
  • SS33 Business Services LLC
  • Houston, TX

Job Description

Job Description: Data Modeling Architect Financial Analytics

Start: 4/28

Duration: Contract

Location: Houston, TX Onsite 3 days a week

Job Description:

We are seeking a seasoned Data Modeling Architect with specialized expertise in designing and delivering financial data solutions that power executive decision-making. This role focuses on building a trusted and scalable data foundation for critical financial KPIs - including Revenue, EBITDA, Cash Flow, OPEX, and CAPEX - leveraging Snowflake Data Cloud on AWS.

The ideal candidate will be responsible for architecting robust financial data models, enabling analytics and reporting across Finance, FP&A, and the C-Suite. This position requires mastery of SQL-based data modeling, strong understanding of financial reporting structures, and the ability to operate at the intersection of technology, finance, and enterprise strategy.

Key Responsibilities

1. Financial Data Modeling & Architecture

  • Design and implement enterprise-grade data models that accurately represent financial structures, hierarchies, and calculations, including multi-entity consolidations, currency conversions, and time-based aggregations.
  • Build conceptual, logical, and physical data models in Snowflake that align with best practices and support GAAP, IFRS, and internal FP&A reporting requirements.
  • Translate C-suite and finance executive reporting needs into well-governed, scalable SQL models using dimensional modeling (star/snowflake) and data vault patterns where appropriate.
  • Architect financial subject areas including:
  • P&L (Profit & Loss) : revenue recognition, gross margin, operating income
  • Balance Sheet : assets, liabilities, equity
  • Cash Flow : direct/indirect method modeling, cash burn rates
  • Cost centers, GL accounts, budgets vs actuals , etc.

2. Data Integration & ELT Strategy

  • Partner with data engineers and platform teams to design source-to-target mappings from systems like SAP ECC/S4HANA, Oracle EBS, NetSuite, Workday Finance, etc.
  • Build reusable SQL patterns to manage multi-source, multi-entity financial data harmonization.
  • Design layered architecture (staging ? raw ? curated ? semantic) in Snowflake, ensuring traceability and auditability of financial metrics.
  • Ensure accurate and performant ELT transformation logic, particularly for complex aggregations and period-end adjustments.

3. Executive Stakeholder Engagement

  • Work closely with Finance, FP&A, CFO office, Treasury, and Investor Relations teams to understand strategic reporting needs and translate them into data architecture artifacts.
  • Serve as the bridge between technical data teams and business leaders, ensuring financial data integrity and transparency across reports and dashboards.
  • Support what-if analysis, scenario modeling, and driver-based planning through model extensibility.

4. Governance, Quality & Compliance

  • Define and enforce data modeling standards, naming conventions, metadata practices, and documentation protocols.
  • Implement strong data quality and validation checks, especially around month-end and quarter-end close cycles.
  • Align financial data models with internal controls and SOX, GAAP/IFRS compliance frameworks.
  • Partner with data governance teams to register models and metrics in data catalog tools like Alation, Collibra, or Atlan.

Required Qualifications

  • Bachelor's or Master's Degree in Finance, Accounting, Computer Science, or a related discipline.
  • 15+ years of experience in enterprise data modeling or data architecture roles.
  • 3+ years of Snowflake Data Cloud experience in production environments, preferably on AWS.
  • Expert-level proficiency in SQL, with experience in window functions, recursive queries, CTEs, and performance tuning for financial workloads.
  • Deep understanding of finance data structures and KPIs, including GAAP/IFRS treatment, ledger-based modeling, and consolidation logic.
  • Hands-on experience working with data from ERP systems like SAP, Oracle Financials, Workday, or similar.
  • Familiarity with financial close processes, including journal entries, accruals, and restatements.

Preferred Qualifications

  • SnowPro Advanced: Architect or equivalent Snowflake certification.
  • Prior experience building executive dashboards in Power BI, Tableau, or Looker using financial data marts.
  • Experience with data transformation frameworks like dbt.
  • Exposure to Python or R for financial analytics, forecasting, or anomaly detection.
  • Understanding of financial planning and analysis (FP&A) methodologies such as zero-based budgeting, rolling forecasts, or scenario planning.
  • Experience implementing data security models for sensitive financial datasets using RBAC and data masking in Snowflake.

Soft Skills & Core Competencies

  • Strong communication and storytelling ability, especially when interfacing with executive leadership.
  • Detail-oriented with a "data-first" mindset and financial accuracy obsession.
  • Ability to manage ambiguity and drive clarity across finance and IT functions.
  • Comfortable operating in Agile/SAFe delivery environments with sprint-based release cycles.

Job Tags

Contract work, 3 days per week,

Similar Jobs

The University of Iowa

HAND ORTHOPEDIC SURGEON Job at The University of Iowa

Full/Part Time Status:Full TimePosition Description:The University of Iowa Health Care Department of Orthopedics and Rehabilitation is seeking an Orthopedic Hand surgeon who will have teaching, research, and clinical service responsibilities in the Hand and Wrist... 

Valbella At The Park

Sushi Chef Job at Valbella At The Park

 ...We are looking for a sushi chef to head the department at Valbella At The Park. Youll be the sole sushi preparer for the restaurant and be responsible for all preparation, ordering, plating, and meeting of all health department requirements. Must be able to handle fast... 

Kualoa Ranch Hawai'i

Ticket Office Reservations Agent Job at Kualoa Ranch Hawai'i

Ticket Office Reservations Agent Location Kaneohe, HI : Join a company that is involved in many diverse operations in one of the most beautiful places in Hawai'i. Kualoa Ranch Hawai'i has enjoyed a proud past and looks forward to an exciting future. A team committed to... 

K.A. Recruiting, Inc.

CLS (Blood Bank) OR Clinical Laboratory Scientist Job at K.A. Recruiting, Inc.

CLS (Blood Bank) openings at a beautiful facility in the Mather, CA area MANY different shift options available Details: full time, permanent position extremely competitive pay excellent benefits Requirements: Lab Certifications are required for this role! Click... 

Da Vinci Collaborative

Teacher/Tutor Job at Da Vinci Collaborative

 ...needs of our clients. The role of our District and Clinic Teacher/Tutor is to provide the best customized instruction for each of our...  ...~1 Year Teaching Experience- preferred ~ Experience with multi-sensory language, writing and comprehension programs- preferred...