[Remote] Analytics Engineer

Note: The job is a remote job and is open to candidates in USA. Celigo is a modern Integration and Automation Platform (iPaaS) focused on simplifying how companies integrate, automate, and optimize processes. They are seeking an Analytics Engineer to own business logic and architect the 'Gold' data layer, transforming complex datasets into reliable insights for decision-making across various teams.ResponsibilitiesDevelop and maintain scalable data models using dbt / Coalesce to transform raw data into clean, documented, and production-ready schemasCollaborate with Data Engineering and Data Analytics to ensure technical architecture supports business logic and reporting requirementsImplement automated testing, data documentation, and observability frameworks to ensure a 'single source of truth.'Optimize SQL queries and warehouse configurations to improve performance and manage compute costsMaintain version control workflows, CI/CD pipelines, and coding standards across the data teamSupport the semantic layer and BI data catalogs to enable self-service explorationSkillsStrong belief in applying software engineering best practices (testing, versioning, peer review) to data workflowsAbility to design modular data models (Star Schema, Kimball) that balance flexibility with system performanceProficiency in communicating technical trade-offs to both analysts and infrastructure engineersDegree in Computer Science, Mathematics, Statistics, or a related quantitative field3+ years of experience in Analytics Engineering, Data Engineering, or a technical Data Analyst roleExpert-level proficiency in SQL with a focus on writing efficient, maintainable, and readable codeHands-on experience with dbt / Coalesce and modern cloud data warehouses like Snowflake or BigQueryFamiliarity with Git, pull request workflows, and command-line interfacesExperience with Python for data orchestration (e.g., Airflow) or advanced data manipulationUnderstanding of Fintech or SaaS-specific metrics such as ARR, churn, and financial reconciliationBenefitsThree weeks of vacation (starting year one)Wellness days and holidays to rechargeParental leave and a generous benefits packageMonthly tech stipendRecognition and career development opportunitiesRemote-first culture, built on trust, collaboration, and transparencyA high-growth, inclusive work environment where innovation thrives and ideas are implementedLightspeed learning opportunities to keep you at the leading edge of your fieldExceptional coworkers who challenge and inspire you dailyCompetitive compensation and benefits, including:Company OverviewCeligo is the AI-driven integration platform(iPaaS) that allows applications to work together for both IT and business users. It was founded in 2011, and is headquartered in San Mateo, California, USA, with a workforce of 501-1000 employees. Its website is http://www.celigo.com.Company H1B SponsorshipCeligo has a track record of offering H1B sponsorships, with 9 in 2025, 6 in 2024, 7 in 2023, 6 in 2022, 6 in 2021, 8 in 2020. Please note that this does not guarantee sponsorship for this specific role.