Business Intelligence Developer

This is a fully remote position, open to applicants in Ireland.

📋 Description

• Develop and sustain ETL/ELT pipelines utilizing APIs, SFTP, and third-party integrations such as Salesforce, Zuora, RevenueCat, affiliate platforms, and legacy systems.

• Extract and transform data from Salesforce to facilitate B2B funnel reporting and attribution.

• Oversee pipelines, troubleshoot problems, resolve errors, and document ETL logic and data models.

• Validate data and investigate inconsistencies across various sources and pipelines.

• Assist in the creation of clean, well-organized datasets for dashboards, campaign tracking, and lifecycle reporting across our cybersecurity brands.

• Conduct data validation and ensure consistency across platforms and reports.

• Contribute to reusable datasets and uphold data warehouse standards.

• Utilize key marketing and sales metrics (MRR, funnel stages, LTV, churn) to verify data accuracy.

⛳️ Requirements

• A minimum of 2 years of experience in data processing or data engineering.

• Proficient in Python and SQL.

• Experience handling Salesforce data through APIs and batch ingestion pipelines (e.g., Talend or comparable ETL tools).

• Familiarity with AWS data services (S3, Glue, Redshift, Athena, Lambda) for building and operating pipelines.

• Understanding of B2B and SaaS metrics and their application in reporting.

• Excellent communication skills and the ability to collaborate with business stakeholders.

• Eagerness to learn and advance within broader data engineering initiatives.

• Nice to Have: Experience with ETL tools such as Talend or similar.

• Experience in optimizing batch pipelines from full refresh to incremental updates.

• Knowledge of Redshift-based transformations (stored procedures, staging layers).

• Exposure to advertising platforms, affiliate, or partner data.

• Experience in supporting dashboarding for marketing or sales teams.

• Interest in marketing analytics, attribution, or lifecycle reporting.

• Exposure to BI tools (Looker, QuickSight).

🏝️ Benefits

• Competitive salaries.

• Health and wellness-focused benefits.

• Work-life balance with paid time off.

• Employee Resource Groups.

• Company-sponsored events.

• Professional growth opportunities through educational support, mentorship programs, and career development resources.

• Employee engagement programs and recognition awards.