Design, build, deploy, and maintain reliable, scalable, and governed research data pipelines and reusable data products supporting Research & Discovery, translational science, analytics, reporting, AI, and scientific decision-making.
Responsibilities
Design and maintain conceptual, canonical, logical, semantic, and physical data models for Research and Discovery data products.
Translate scientific, experimental, and business requirements into reusable enterprise information models.
Define core Research entities, attributes, identifiers, relationships, hierarchies, experimental context, events, and scientific business rules.
Establish canonical representations across laboratories, research sites, source systems, external providers, and data products.
Model structured, semi-structured, unstructured, and multimodal scientific data while preserving provenance and experimental context.
Designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem using dbt Core, Microsoft Fabric, and Azure Data Factory within a medallion architecture.
Compensation
$138,000-143,000 annually
Responsibilities
Architect, implement, and maintain dbt Core models across the medallion architecture
Integrate MDM workflows and reference data into medallion-layer transformations
Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models
Build data models that power enterprise analytics, reporting, and other downstream uses
Optimize SQL code and dbt Core transformation logic
Requirements
High School Diploma, GED, or equivalent experience
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field
Design end-to-end data solutions on a modern GCP-native Enterprise Data Platform, including ingestion, transformation, and consumption layers, and lead architectural decisions for migration and new data products.
Responsibilities
Design end-to-end data solutions on EDP
Define source-to-target mappings and transformation designs
Make hands‑on GCP service selection and design decisions
Design dimensional and analytics‑ready data models
Apply security, access, and least‑privilege design principles
Requirements
Bachelor's degree in a relevant field or equivalent work experience
Nice to have: retail, consumer, or omni‑channel domains
Nice to have: platform modernization or EDW‑to‑GCP migration
Lead the enterprise analytics organization, delivering trusted business intelligence, operational reporting, executive dashboards, and advanced analytical solutions.
Compensation
The compensation range for this position is: $180,000.00 - $200,000.00 per year.
Responsibilities
Lead and develop teams of Analytics Engineers, Data Analysts, and Business Intelligence developers
Define and execute the enterprise analytics strategy
Partner with business leaders to identify reporting and analytics priorities
Deliver executive dashboards, operational scorecards, and self-service analytics solutions
Establish enterprise reporting standards, KPIs, and business metrics
Requirements
Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, Business Analytics, or related field.
Design, build and maintain the data foundation that connects the company's products, CRM, finance systems and operational tools to trusted reporting and analytics.
Responsibilities
Build and maintain reliable ETL/ELT pipelines from product databases, finance systems, CRM and other sources into the central platform
Develop integrations using SQL, APIs, Python and cloud services
Design scalable schemas and data models for shared company, user, CRM, product-usage, finance and operational data
Implement incremental loads, testing, logging, retries, alerting and monitoring
Write readable, secure, version-controlled code and manage performance, access, scalability and cost
Requirements
relevant degree, diploma or equivalent practical experience
Design, build, test, deploy, and support scalable data pipelines and data products on Azure Databricks.
Responsibilities
Design, build, test, deploy, and support scalable data pipelines and data products on Azure Databricks.
Develop ingestion and transformation processes for data from on-premises, cloud, SaaS, and third-party sources using batch and, where appropriate, streaming patterns.
Use SQL and Python or PySpark to transform, validate, and optimize large and complex datasets.
Design and maintain reusable data structures across raw, refined, and curated layers, applying dimensional modeling and star schema principles where appropriate.
Build reliable Delta Lake solutions and apply Databricks capabilities for orchestration, performance, observability, and data quality.
Requirements
Bachelor’s degree in technology, engineering, computer science, or a related field, or an equivalent combination of education and experience.
Base Salary Range: $104,000.00 - $156,000.00, offered in good faith and based on experience, location, and qualifications. Additional Rewards: Annual bonus opportunities and potential long-term incentives tied to both company and individual success.
Responsibilities
Design, develop, and maintain enterprise‑level data models to support analytics, reporting, and integration needs.
Build high‑quality dashboards, semantic models, and datasets using Microsoft Power BI.
Leverage Microsoft Fabric capabilities—including Lakehouse, Dataflows Gen2, Pipelines, Semantic Models, and Notebooks—to build scalable modern analytics solutions.
Develop DAX measures, Power Query transformations, and dataflows to create governed, reusable data assets.
Understand and interpret Oracle E‑Business Suite (R12) and Oracle Fusion Cloud ERP data structures, tables, and reporting layers.
Requirements
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field
Data EngineerNewLiquid Thought · Somerset West, South Africa