Better Debt Solutions is building an enterprise data platform on Microsoft Fabric, and you will play a central role in designing, delivering, and continuously improving it. This fully in-office position in Irvine, CA includes medical, dental, and vision coverage options, paid time off with company holidays, and regular team social events. You will also get direct visibility and reporting to executive leadership (CEO & COO), with the autonomy to architect and scale the platform that supports operational reporting and AI-driven insights.
Responsibilities
- Design and implement scalable data warehouse and Lakehouse architectures using Microsoft Fabric and Azure.
- Architect and organize data structures within OneLake, Fabric Warehouse, and Lakehouse using a medallion pattern (bronze, silver, gold).
- Develop and maintain ingestion and transformation pipelines using Data Factory in Fabric (pipelines, Copy jobs) and Spark/Python notebooks.
- Ingest data from REST APIs and relational databases including MySQL/MariaDB, PostgreSQL/Redshift, and SQL Server, including sources behind on-premises data gateways.
- Create dimensional models and star schemas with SCD Type 2 history and conformed dimensions for cross-functional reporting.
- Centralize business logic in curated gold-layer tables to keep semantic models consistent and support near-real-time operational dashboards.
- Profile and tune Spark and SQL workloads to speed up transformation run times using partitioning, file sizing, join strategies, and caching.
- Convert legacy full-reload workflows into incremental and CDC pipelines to reduce compute overhead.
- Monitor and manage Fabric capacity (CU) consumption using the Fabric Capacity Metrics app to avoid throttling during peak workloads.
- Maintain Delta tables using OPTIMIZE, VACUUM, and V-Order to support fast reads in Direct Lake and warehouse queries.
- Audit pipelines, notebooks, and dataflows to remove redundant processing and consolidate duplicated logic.
- Implement automated monitoring for freshness, volume, and completeness, including proactive alerting on production pipelines.
- Reconcile loaded data with source systems to resolve ingestion gaps and anomalies at the root cause.
- Perform safe historical corrections and backfills using dry runs and validation before production deployment.
- Collaborate with vendor partners, internal business users, and BI and analytics teams to deliver cost-efficient, scalable data solutions.
Requirements
- Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field (or equivalent professional experience).
- 7+ years of hands-on experience in Data Engineering or Data Platform Development, including direct production experience with Microsoft Fabric and Azure data technologies.
- Strong proficiency in Python, PySpark, and advanced SQL.
- Proven ability to identify, decompose, and solve complex data challenges independently and collaboratively.
- Track record of reducing run times and compute costs through workload optimization, incremental loading, and dimensional modeling (star schema, SCD Type 2).
- Practical experience with Git-based development and deployment promotion workflows using Azure DevOps or GitHub.
- Excellent communication skills to bridge conversations across executive leadership (CEO, COO), vendor partners, and non-technical stakeholders.
Technologies
- Microsoft Fabric, Azure, OneLake, Fabric Warehouse, Data Factory in Fabric
- Spark, Python, PySpark
- REST APIs, MySQL, MariaDB, PostgreSQL, Redshift, SQL Server
- On-premises data gateways
- SCD Type 2, star schema
- Delta tables, OPTIMIZE, VACUUM, V-Order
- Direct Lake, Fabric Capacity Metrics app, Fabric capacity (CU)
- Azure DevOps, GitHub, Git-based development
- SQL
Benefits
- Comprehensive medical, dental, and vision insurance coverage options.
- Paid vacation and paid company holidays throughout the year.
- Lunch is on us every Friday.
- Vibrant team culture with regular quarterly social events, team outings, and annual holiday parties.
- 401(k) retirement savings plan options.
- Direct visibility and reporting to executive leadership (CEO & COO), supporting autonomy to architect and scale the enterprise data footprint.
Bonus Points (Great To Have)
- Microsoft Fabric Data Engineer Associate (DP-700) certification.
- Familiarity with Azure AI Foundry or Azure Machine Learning.
- Experience leveraging AI-assisted coding tools to accelerate pipeline development.
- Familiarity with secondary cloud ecosystems such as Google Cloud Platform (GCP).
- Prior DBA experience managing data security, redundancy, and high availability.
Location: Irvine, CA (Fully In-Office)
Compensation: $140,000 - $155,000 / year
Job Type: Full-Time (Exempt/Salary)
What you’ll be doing: Priorities can shift as system optimization needs, business analytics demands, and strategic platform initiatives evolve.
