Pond Lehocky Giordano Inc.
    4+ years experienceRemotePosted 20 days ago
    Sign in to apply

    About the role

    Data Engineer - Snowflake

    Experience: 4-6 years min

    Job Description:

    We are hiring our first dedicated data engineer to build and run our cloud data platform.

    You will stand up a Snowflake instance, load data from our

    operational systems into it, and keep it reliable, secure and affordable. You will work with

    engineering, operations and leadership to turn raw data into trusted tables for reporting

    and analytics.

    What you will do

    Design and build the data platform: account or tenant setup, environments, storage

    layers (raw , cleaned, curated) and naming standards.

    Build and maintain ingestion pipelines from PostgreSQL, Salesforce, SaaS APIs and flat

    files, using batch and incremental (CDC) loads.

    Model data for analytics with dbt or F abric notebooks: dimensional models, tests and

    documentation.

    Manage security and access: role-based access, row and column masking for PII, SSO

    integration, and audit logging.

    Monitor pipelines and data quality; set up alerting and fix failures.

    Control cost: warehouse or capacity sizing, auto-suspend, query tuning and monthly

    spend reports.

    Manage the platform as code (Terraform, Git, CI/CD) and write runbooks so others can

    operate it.

    Support analysts and BI users (Power BI, Tableau or similar) with performant, well-

    documented data sets.

    Required qualifications

    4–6 years in data engineering, analytics engineering or a similar role.

    2+ years hands-on with Snowflake or Microsoft Fabric / Azure Synapse / Databricks in

    production.

    Strong SQL and Python.

    Experience building EL T pipelines with tools such as dbt, Airflow , Fivetran, Azure Data

    Factory or Fabric Data Pipelines.

    Solid grasp of dimensional modeling, incremental loading and data quality testing.

    Experience with cloud security basics: RBAC, encryption, secrets management,

    handling PII.

    Comfortable owning a platform end to end with little supervision.

    Preferred qualifications

    SnowPro Core / Advanced Data Engineer , or Microsoft Fabric Data Engineer Associate

    (DP-700) / Fabric Analytics Engineer (DP-600).

    Terraform or other infrastructure-as-code.

    Experience with Salesforce data, A WS (S3, RDS) and PostgreSQL.

    Experience in legal, healthcare or another regulated industry .

    Power BI semantic model experience.

    Success at 90 days

    Platform live with dev and prod environments, access controls and cost guardrails.

    Core sources loading on a schedule with monitoring.

    First curated data models in use by reporting.

    Location: Hybrid (must be local to Philadelphia)

    Range: $135K–$150K

    Telescoped is a product of Permanent Ventures, Inc.