Data Modeler / Data Engineer (100% Remote)

Position: Data Modeler / Data Engineer

Work Set up: 100% remote

Work Type: Independent Contractor

Schedule: US Time Zone

Data Modeler/Engineer

Responsibilities:

• Architect and build end-to-end data pipelines across companies with assorted source systems: REST API extractions, scheduled and incremental loads, database replication feeds, and flat-file/ERP ingestion
• Land and stage raw source data in modern cloud data platforms (lakehouse/warehouse architectures), with orchestration, scheduling, monitoring, and failure recovery
• Design and maintain dimensional models (Kimball star schemas, conformed dimensions, fact tables, slowly changing dimensions) that unify data
• Build and tune the SQL layer: load orchestration, reporting views, incremental vs. full-refresh strategies, performance optimization
• Develop semantic models and measures for BI consumption; manage deployments, refresh schedules, and access security
• Integrate financial data from accounting systems and reporting packages; reconcile operational data against finance-reported actuals
• Build validation and data-quality frameworks: automated tie-outs against source-system reports, pipeline health monitoring, and exception reporting that routes fixes back to operating teams

Skills and Experience:

• Expert SQL (complex queries, tuning, stored procedures) and strong dimensional-modeling fundamentals
• Hands-on experience with a modern cloud data platform (e.g., Microsoft Fabric, Databricks, Snowflake) - lakehouse/warehouse patterns, pipelines, notebooks
• API integration: REST extraction, auth flows (OAuth, service principals), pagination and rate-limit handling; scripting in Python
• Proven data-validation discipline