Data Engineer

Offered.ai is helping Prescient AI find great candidates. Click the 'Apply' button to learn more and apply for the role.All applicants must be based within the U.S.What we’re looking forAs an early member of the data engineering team, you’ll create solutions and artifacts that help enable platform features for our users and marketers, while working cross-functionally with teams such as Product, Customer Success, and Platform Engineering. In this role, you will be responsible for the development and maintenance of fault-tolerant pipelines, including multiple database systems. **Responsibilities:Collaborate with engineering teams to create REST API-based pipelines for large-scale MarTech systems, optimizing for performance and reliabilityDevelop comprehensive data quality testing procedures to ensure the integrity and accuracy of data across all pipelinesBuild scalable dbt models and configuration files, leveraging best practices for efficient data transformation and analysisPartner with lead data engineers in designing scalable data modelsConduct thorough debugging and root cause analysis for complex data pipeline issues, implementing effective solutions and optimizationsFollow and adhere to group's standards such as SLAs, code styles, and deployment processesAnticipate breaking changes to implement backwards compatibility strategies regarding API schema changesAssist the team in monitoring pipeline health via observability tools and metricsParticipate in refactoring efforts as platform application needs evolve over timeCompetencies:Bachelor's degree or higher in Computer Science, Engineering, Mathematics, or a related field+3 years of professional experience with a cloud database such as Snowflake, Bigquery, Redshift+1 years of professional experience with dbt (cloud or core)Exposure to various data processing technologies such as OLAP and OLTP and their applications in real-world scenariosExposure to work cross-functionally with other teams such as Product, Customer Success, Platform EngineeringFamiliarity with orchestration tools such as Dagster/AirflowFamiliarity with ETL/ELT tools such as dltHub/Meltano/Airbyte/Fivetran and DBTHigh intermediate to advanced SQL skills (comfort with CTEs, window functions)Proficiency with Python and related libraries (e.g., pandas, sqlalchemy, psycopg2) for data manipulation, analysis, and automationBenefits:Competitive salary with ability to evolve your role for new compensation packagesCompany equity401k retirement plan + company matchHealth insurance 99% covered (+family)$100 monthly for personal happinessFamily leave time (includes Paw-ternity leave for furry loved ones)Learning budget for relevant courses of interests