NearU · 1 day ago
Data Architect
Charlotte, NC
Full-time
Onsite
Senior Level
6+ years expNearU is a people-centric, process-driven, and technology-enabled customer service platform dedicated to revolutionizing the home services industry. They are seeking a Data Architect to design, build, and evolve their enterprise data platform, ensuring data quality and platform reliability to support analytics and AI-driven use cases.
Customer Service
Responsibilities
Architect and maintain Snowflake as the enterprise analytical and AI data backbone
Design schemas and data models optimized for:
Financial and operational KPIs
Executive and self-service analytics
AI context datasets, features, and embeddings
Build and maintain Snowflake views that centralize KPI logic and support downstream BI, reporting, and AI workloads
Implement and govern Streams, Tasks, Dynamic Tables, Snowpark, and secure data sharing
Optimize warehouse sizing, performance, and cost across BI, transformation, and AI workloads
Reverse Architect Databricks as the data processing, cleansing, and enrichment layer
Understand and document current medallion architecture (Bronze / Silver / Gold):
Bronze: raw, immutable ingestion
Silver: cleansed, standardized, validated datasets
Gold: analytics- and AI-ready datasets
Understand Spark-based cleansing logic including:
Deduplication and record survivorship
Data standardization and normalization
Schema enforcement and drift handling
Null handling, outlier detection, and anomaly flags
Ensure reliable and governed handoff of curated data from Databricks into Snowflake
Define enterprise standards for data quality, completeness, and consistency
Design reusable cleansing and validation frameworks for structured and unstructured data
Implement automated data quality checks and scoring at each pipeline stage
Partner with analytics and business teams to resolve source system inconsistencies
Ensure analytics and AI datasets are accurate, explainable, and auditable
Partner with the Manager of Data Analytics and IT to define, document, and operationalize enterprise KPIs
Translate KPI definitions into governed, reusable Snowflake views for reporting, dashboards, and AI context
Ensure KPI logic is consistent, traceable to source data, and performant at scale
Design and govern ingestion and ELT pipelines from ERP, SaaS, APIs, and operational systems
Oversee pipelines built with Fivetran, dbt, and Python
Embed data cleansing, validation, and reconciliation into ingestion workflows
Ensure pipelines meet SLAs for analytics, finance, Marketing and AI workloads
Build monitoring and alerting for Snowflake and Databricks pipelines
Implement alerts for:
Pipeline failures and SLA breaches
Data freshness issues
Volume and schema anomalies
Implement anomaly detection for KPI and dataset behavior that may impact reporting or AI outputs
Partner with IT and Analytics teams on incident response and escalation
Design data architectures that support:
Retrieval-Augmented Generation (RAG)
Prompt context datasets
Embedding generation and lifecycle management
AI inference feedback loops
Prepare cleansed, curated datasets that reduce hallucinations and improve AI reliability
Support integrations with Snowflake Cortex, Azure OpenAI, and related LLM platforms
Enforce data governance, access controls, and masking aligned with enterprise and AI usage policies
Ensure lineage and transparency from source systems to analytics and AI outputs
Work under the direction of the Manager of Data Analytics and IT
Collaborate with data engineers, analysts, and IT teams to deliver production-ready data assets
Qualification
Required
6+ years of experience in data architecture, data engineering, or analytics engineering
Strong hands-on experience with Snowflake
Experience with Databricks / Apache Spark
Demonstrated experience designing data cleansing, standardization, and quality frameworks
Experience supporting AI or LLM-driven data workflows
Advanced SQL and strong Python skills
Experience designing enterprise data platforms in a cloud environment (Azure preferred)
Preferred
Experience with Snowflake Cortex, Snowpark, SQL or AI SQL functions
Experience enabling RAG pipelines, embeddings, or vector search
Familiarity with Azure OpenAI or similar LLM platforms
Experience with data quality or observability tools (e.g., Experian, etc.)
Experience supporting finance, ERP, or multi-entity data environments
Company
NearU
NearU is a family of home services companies led by some of the most prominent veterans and visionaries in industry.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Freeman Spogli
2022-08-17Private Equity
Leadership Team
E
Ed Leezer
Regional General Manager NearU Services Sandhills Region
Recent News
globallegalchronicle.com
2023-11-14
GlobeNewswire News Room
2023-10-03
2022-08-17
Company data provided by crunchbase