Data Engineer

Frida•Miami, FL

1d•Hybrid

About The Position

Frida is seeking a Data Engineer to design, build, and maintain scalable data pipelines and the underlying database infrastructure that supports analytics and reporting across the organization. This role sits within the Data Integration and Architecture team and is central to our ongoing data lake buildout. This role will focus on ensuring database stability, proper indexation, reliable backups, performant pipelines, and sound data model and schema design. Strong collaboration with the analytics team will be essential to ensure they have a reliable, well-governed platform to build on.

Requirements

5+ years of experience in a data engineering role or a closely related function.
Strong proficiency with Azure Data Factory, including pipeline orchestration, linked services, and integration runtimes.
Solid SQL skills with hands-on experience managing PostgreSQL databases, including indexing strategies, partitioning, query optimization, backup and recovery, and performance tuning.
Familiarity with Azure data services such as Azure Data Lake Storage, Azure Containers, or Synapse Analytics.
Experience with Python or another scripting language for data transformation and automation tasks.
Experience administrating Azure environments, including resource management, access controls, and service configuration.
Understanding of data modeling concepts (star schema, Medallion structure, normalization/denormalization).
Comfort working with version control and implementing CI/CD practices for data pipeline deployment.
Strong communication skills and the ability to translate technical concepts for non-technical stakeholders.

Nice To Haves

Experience with database monitoring tools, automated alerting, and infrastructure-as-code practices for data environments.
Exposure to EDI data flows or ERP systems such as NetSuite.
Background working in a consumer products, retail, or e-commerce environment.

Responsibilities

Build, optimize, and maintain data models and schemas within PostgreSQL, ensuring proper indexation, partitioning, and structural integrity to support downstream consumption.
Own database backup, recovery, and disaster recovery procedures to ensure data durability and business continuity.
Monitor database health, query performance, and resource utilization, proactively addressing issues before they impact downstream systems.
Contribute to the architecture and continued buildout of the organization's data lake on Azure, including storage design, lifecycle policies, and environment reliability.
Take ownership of deployment, security, and environment configuration from vendor teams, partnering with infrastructure and DevOps resources to bring these capabilities in-house.
Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory to ingest, transform, and load data from a variety of source systems.
Implement and enforce data quality checks, monitoring, and alerting across pipelines.
Troubleshoot pipeline failures and performance bottlenecks, performing root cause analysis and implementing lasting fixes.
Partner with business stakeholders and the analytics team to understand data ingestion requirements, ensuring data models and schemas are designed to meet current and future needs without duplicating tables or data across the environment.
Drive standardization and templatization of data structures, pipeline patterns, and ingestion processes to ensure consistency, reduce technical debt, and make the platform easier to scale.
Ensure the analytics team has access to clean, performant, and well-documented data by maintaining reliable data structures and pipeline outputs.
Document data flows, lineage, and pipeline logic to support governance and knowledge sharing.

Benefits

Robust health benefits including:
Comprehensive medical, vision, and dental plans
Employer paid life insurance
Supplemental insurance options including Accident Insurance, Short-Term Disability and Long-Term Disability
FSA & HSA
401k matching up to 4% with immediate vesting.
Generous paid time off program including elective PTO days, federal holidays, sick/wellness days, and a birthday floater.
Flexible paid pregnancy and parental leave.
Weekly wellness programming designed to maximize personal time and minimize time spent investing in personal care outside of work hours. This includes a variety of programming such as in-office manicures & pedicures, blowouts, massages, and carwash services.
Dog friendly office - feel free to bring your best buddy with you to work!
Learning & development opportunities for professional and personal growth
Company-wide events & outings. Team engagement is at the center of our culture. This ranges from small department-specific teambuilding or informal outings to our annual Fam Jam family carnival that celebrates the people in your life who support you in bringing your best self to work each day. We also host an annual Day of Service to support our local Miami community, and provide a variety of volunteer opportunities throughout the year that support our mission to serve parents and children.
Exclusive employee product discounts.