Mid-Level Data Engineer / Analyst - USA

The Role

We’re seeking a Mid-Level Data Engineer/Analyst to independently design, build, and optimize data pipelines and analytics solutions that power business intelligence and AI/ML initiatives. In this role, you will own key data workstreams end to end, build production-grade transformation layers using dbt and Spark, manage data infrastructure on Snowflake and Databricks, and collaborate with analysts, data scientists, and product teams to deliver reliable, well-governed, and high-quality data products. You will also contribute to the maturity of our DataOps and data observability practices.

What You’ll Do

• Design, build, and maintain production-grade ETL/ELT pipelines using dbt, Apache Spark (PySpark), Airflow, Dagster, or Prefect.

• Develop and optimize data models on Snowflake, Databricks, BigQuery, or Redshift following dimensional modeling, data vault, or One Big Table patterns.

• Implement and manage data ingestion from diverse sources including databases, REST/GraphQL APIs, event streams (Kafka, Kinesis), SaaS platforms, and flat files using Fivetran, Airbyte, or custom connectors.

• Build and maintain semantic/metrics layers and curated data products for analytics, reporting, and self-service consumption.

• Implement data quality, testing, and observability frameworks using dbt tests, Great Expectations, Soda, Monte Carlo, or Datafold.

• Create advanced dashboards, reports, and analytical visualizations using Tableau, Looker, Power BI, or Sigma Computing.

• Optimize query performance, pipeline efficiency, and cloud data platform costs across Snowflake, Databricks, or BigQuery.

• Collaborate with data scientists and ML engineers to prepare and serve feature datasets for machine learning models.

• Implement DataOps practices including CI/CD for data pipelines, version-controlled transformations, and automated testing.

• Write production-quality Python and SQL code with proper testing, documentation, and error handling.

• Support data governance initiatives including cataloging, lineage tracking, access controls, and PII management using tools like Alation, Atlan, DataHub, or Unity Catalog.

What We’re Looking For

• Bachelor’s or Master’s degree in Computer Science, Data Science, Statistics, Mathematics, or a related field.

• 3–5 years of professional experience in data engineering, analytics engineering, or a closely related role with production delivery.

• Strong proficiency in SQL and experience writing complex transformations, window functions, CTEs, and performance-tuned queries.

• Hands-on experience with at least one modern data platform: Snowflake (strongly preferred), Databricks, BigQuery, or Redshift.

• Experience with dbt (data build tool) for data transformation, testing, and documentation in production environments.

• Working knowledge of Python (Pandas, PySpark, or Polars) for data processing and pipeline development.

• Experience with workflow orchestration tools: Airflow, Dagster, Prefect, or cloud-native equivalents (AWS Step Functions, Azure Data Factory).

• Familiarity with data ingestion tools and patterns: Fivetran, Airbyte, CDC (Debezium), or streaming ingestion (Kafka, Kinesis).

• Experience with data visualization and BI tools: Tableau, Looker, Power BI, or Sigma.

• Understanding of data modeling methodologies (Kimball, Data Vault, OBT) and data warehousing best practices.

• Familiarity with version control (Git), CI/CD for data, and Agile development workflows.

Preferred Qualifications

• Snowflake SnowPro Core, Databricks Data Engineer Associate, or AWS Data Analytics Specialty certification.

• Experience with Apache Spark and Databricks for large-scale data processing and lakehouse architectures.

• Familiarity with data cataloging and governance tools: Alation, Atlan, DataHub, Collibra, or Databricks Unity Catalog.

• Experience with data observability platforms: Monte Carlo, Datafold, Soda, or Elementary.

• Exposure to streaming data pipelines using Kafka, Spark Structured Streaming, Flink, or Kinesis.

• Experience with metrics/semantic layers: dbt Semantic Layer, Cube, or Looker Modeling Language (LookML).

• Knowledge of cloud data infrastructure: AWS (S3, Glue, Athena, Redshift, Lake Formation), Azure (ADLS, Synapse, Data Factory), or GCP (GCS, Dataflow, BigQuery).

Why Join Cognify Analytics?

• Join a team of industry veterans from Google, Meta, and top-tier tech companies.

• Work on impactful, high-scale data and analytics projects with leading global clients.

• Enjoy a flexible, remote-first culture focused on innovation and excellence.

• Competitive salary, equity options, and continuous learning opportunities.

Salary Range
US East/West Coast: $108,100 - $144,100
US Remote: $91,900 - $122,500
Disclaimer: The salary ranges provided are estimates and may vary based on factors including, but not limited to, a candidate's experience, skills, education, and specific geographic location. These figures do not guarantee a specific offer of compensation.

Perks And Benefits Of Working With Us

• Unlimited PTO.

• Please ask us about our very generous parental leave, much above industry standards!.

• Entrepreneurial culture where pushing limits and taking risks is everyday business.

• Open communication with management and company leadership.

• Small, dynamic teams = massive impact.

• Medical, Dental and Vision coverage for employees.

• Access to Disability & Life insurance.

• Mental health and wellbeing support

• Annual bonus program

• Employer Stock Purchase Program (ESPP)

• Yearly Team building experiences

• Mentorship and sponsorship opportunities

• Manager resources and support

We are an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or any other protected characteristic.