Remote Senior Data Engineer — Pipelines & Analytics

OpenKrill; United States; Hybrid; USD 150,000 - 190,000; Full time

Job summary

Juniper Square is hiring a Senior Data Engineer to scale and evolve data and reporting experiences. You will build pipelines from multiple sources, shaping internal and external analytics products to guide business-critical decisions and improve decision-making across teams.

You will work on designing data models, pipelines, and analytics platforms, collaborating with software engineers and stakeholders. A fast-paced startup environment values adaptability, with opportunities to work remote or

Qualifications

• Bachelor's degree in Computer Science, or equivalent work experience
• 7-11 years of experience building ETL (Extraction Transform Load) or ELT (Extraction Load Transform) pipelines from scratch
• Strong command of relational databases (Postgresql preferred), data modeling and database design
• Strong command of Python and experience building production web applications using Python
• Experience with cloud-based services (AWS RDS preferred)
• Experience developing on (or administering) BI/data visualization platforms (ex. Looker, Tableau, PowerBI, Mode, Data Studio, Domo, QlikView etc.).
• Basic understanding of data warehouses such as Amazon Redshift, Google BigQuery, Snowflake etc.
• Demonstrated history of translating data into clear and actionable narratives and communicating opportunities and challenges relevant to stakeholders.
• You must be flexible and adaptable – you will be operating in a fast-paced startup environment.
• Familiarity with data catalog or data governance platforms – open source (e.g. OpenMetadata) or commercial.
• Experience building backend services using Python/FastAPI and designing and implementing scalable RESTful and GraphQL APIs
• Mandatory Experience authoring modern web applications using ReactJS and TypeScript, and designing reusable UI components and scalable frontend architecture.
• Familiarity with patterns such as tool-calling agents, planning/execution loops, and RAG
• Demonstrated ability to use modern AI tools to improve velocity and code quality

Responsibilities

• Design and implement sophisticated data models in SQL.
• Work closely with the other Software Engineers to ensure sound, scalable implementation.
• Act as a technical expert on our team regarding all things data, especially as the data team grows and evolves.
• Introduce new technologies to evolve and enhance our data pipeline capabilities.
• Document data models, architectural decisions and data dictionaries to enable collaboration, maintainability and usability of our analytics platforms and code.
• Assist with governance, guidance, code reviews, and access controls so that we maintain consistency, quality, and business confidentiality as we scale analytics access across the company and to customers.
• Externally: learn our application data schema, and develop a fluency in how to transform it to enhance customers’ decision-making with data.
• Internally: guide product and development teams, advising on instrumentation and laying development foundations for product usage reporting.
• Fulfill projects with minimal guidance but with an appropriate sense of when and how to collaborate with others.
• Build scalable, highly performant infrastructure for delivering clear business insights from a variety of raw data sources.

Skills

ETL pipelines

Data modeling

Python programming

API design

AI tooling

Data governance

FastAPI

React/TypeScript

Education

Bachelor's degree in Computer Science

Tools

PostgreSQL

AWS RDS

Looker

Tableau

PowerBI

Mode

Data Studio

Domo

QlikView

Amazon Redshift

Google BigQuery

Snowflake

OpenMetadata

Job description

Juniper Square is hiring a Senior Data Engineer to scale and evolve data and reporting experiences. You will build pipelines from multiple sources, shaping internal and external analytics products to guide business-critical decisions and improve decision-making across teams.

You will work on designing data models, pipelines, and analytics platforms, collaborating with software engineers and stakeholders. A fast-paced startup environment values adaptability, with opportunities to work remote or