Foundational Data Engineer - Remote Position

About the Role

We are hiring a Foundational Data Engineer to join our team at HelpGrid, where you will play a crucial role in building the technical backbone that unifies our data. This Foundational Data Engineer remote position is perfect for someone who is technical, meticulous, and systems-driven, ready to architect a long-term foundation for how data flows, transforms, and supports our business decisions.

What You’ll Do

• Evaluate and restructure existing data architecture to support scalability and performance.
• Design new schemas, relationships, and data models that align with business logic and analytics needs.
• Build and maintain a HelpGrid-centric data layer that consolidates fragmented sources into a central structure.
• Provide strategic guidance on how data should be organized, named, and modeled for long-term sustainability.
• Establish best practices for schema versioning, documentation, and change control.
• Design and implement the company’s first ETL framework, defining how data is extracted, transformed, and loaded from multiple sources.
• Build automated, reliable pipelines that move data from the centralized database and external tools into analytics-ready structures.
• Standardize transformation logic to clean, normalize, and enrich data for business use.
• Implement pipeline monitoring, error handling, and validation for data quality assurance.
• Provide architectural and workflow recommendations for how data should flow between systems and teams.
• Define how analysts should access, refresh, and use data safely and consistently.
• Partner with the Data & Analytics Manager to align the engineering roadmap with BI and reporting priorities.
• Develop scalable, reusable scripts and frameworks that simplify ongoing data management.
• Integrate data from internal and third-party platforms into a centralized environment.
• Optimize query and pipeline performance for high-volume operations.
• Build APIs or microservices for data synchronization and access.
• Collaborate with DevOps to ensure infrastructure stability, backup policies, and monitoring.
• Document data lineage, schema definitions, and system dependencies.
• Implement data access controls, validation checks, and compliance standards.
• Maintain transparent documentation for analysts, developers, and leadership.
• Promote data stewardship and governance best practices across departments.

Requirements

• 3–5 years of experience in data engineering, architecture, or backend development.
• Proven success building or restructuring data environments for scalability and reliability.
• Strong command of SQL and at least one programming language (Python, NodeJS, or similar).
• Experience designing and implementing ETL/ELT frameworks from scratch.
• Hands-on experience with data warehouses or data lakes (Azure, Microsoft Fabric, Snowflake, or AWS Redshift).
• Solid understanding of data modeling principles, including star schema and normalization.
• Familiarity with APIs, data validation, and version control (Git).

Nice to Have

• Experience with Clickhouse, Redis, or Cassandra.
• Familiarity with BI tools like Power BI, Looker, or Tableau.
• Experience with orchestration tools (Airflow, Docker, Kubernetes).
• Strong documentation habits and systems-thinking skills.
• Ability to translate technical concepts into clear recommendations.

What We Offer

• Competitive salary and benefits.
• Fully remote work environment, allowing for flexibility and work-life balance.
• Opportunities for professional growth and development.
• Collaborative team culture focused on performance and people.
• Access to cutting-edge technologies and tools.