Senior Data Architect

Data EngineerData EngineerFull TimeRemoteTeam 201-500H1B No SponsorCompany Site LinkedIn

Location

Pennsylvania

Posted

103 days ago

Salary

Not specified

Bachelor Degree7 yrs expEnglishAirflowAmazon RedshiftBig QueryCloudETLKafka

Job Description

• Architect a comprehensive data warehouse, analytics framework, and integration platform that enables full data interoperability across our ecosystem. • Design and implement a next-generation data warehouse solution leveraging modern cloud data platforms (Snowflake, Redshift, or similar). • Architect dimensional models, data marts, and fact tables optimized for analytics and reporting. • Establish data governance frameworks, data quality standards, and lineage tracking. • Design multi-tenant data isolation strategies while enabling cross-tenant analytics where appropriate. • Design a unified integration framework for connecting with external systems (APIs, webhooks, file-based imports). • Build event-driven integration patterns leveraging Kafka/MSK for real-time data synchronization. • Create standardized data exchange formats and schemas for interoperability. • Design integration monitoring, error handling, and retry mechanisms. • Establish patterns for bi-directional data synchronization. • Architect a comprehensive analytics framework that enables self-service analytics and reporting. • Design data models that support both real-time and batch analytical workloads. • Build frameworks for metric definitions, KPI tracking, and business intelligence. • Integrate with existing BI tools (Sisense) and enable new analytical capabilities. • Design data access patterns that balance performance, cost, and security.

Job Requirements

Data Architecture: 7+ years designing and implementing large-scale data architectures for SaaS platforms
Data Warehousing: Deep expertise with modern cloud data warehouses (Snowflake, Redshift, BigQuery) including schema design, optimization, and cost management
ETL/ELT Pipelines: Extensive experience building scalable data pipelines using tools like Airflow, dbt, Estuary, Fivetran, or custom solutions
Multi-Tenant Systems: Proven experience designing data architectures for multi-tenant SaaS applications
Data Modeling: Strong background in dimensional modeling, star/snowflake schemas, and data normalization/denormalization strategies
Integration Architecture: Experience designing integration frameworks, API-based data exchange, and event-driven architectures
Experience with data migration projects, especially customer data migrations in SaaS contexts
Knowledge of data governance, compliance (GDPR, CCPA), and security best practices
Experience with observability and monitoring tools for data pipelines (DataDog, CloudWatch, etc.)
Strong communication skills for collaborating with engineering, product, and business stakeholders
Ability to balance technical excellence with business requirements and timelines.

Benefits

Time Off: Unlimited PTO because we trust you to manage your time and recharge when you need it. We encourage our team to truly disconnect and come back refreshed.
Comprehensive Benefits: Our generous benefits package includes medical and dental coverage, competitive 401(k) matching to help you plan for the future, plus gym subsidies to support your health and wellness goals.
Balanced Growth: We offer intellectually challenging work on meaningful problems while respecting your work/life balance. We believe the best work happens when people have time for life outside of work.