Business Intelligence Analyst, Data Engineer

This is a fully remote position, open to applicants in Ireland, +5 more countries.

📋 Description

• Design, develop, and maintain ETL/ELT pipelines that integrate CRM, ERP, project management tools, spreadsheets, and APIs into centralized data warehouses or data marts.

• Ensure data quality, consistency, and integrity through validation, testing, and ongoing monitoring.

• Optimize star/snowflake data models to enhance reporting performance.

• Automate manual data processes to minimize reliance on ad hoc spreadsheets.

• Manage data source connections, credentials, and refresh schedules effectively.

• Troubleshoot issues related to data pipeline failures, latency, and discrepancies.

• Create and maintain dashboards and reports using Tableau, Power BI, or similar tools.

• Collect reporting requirements from stakeholders and convert them into technical specifications.

• Define and uphold a single source of truth for essential business metrics.

• Conduct ad hoc analysis to support business inquiries and strategic decisions.

• Monitor dashboard usage and enhance reports based on stakeholder feedback.

• Document data lineage, business logic, and calculation methods thoroughly.

• Design data structures that are suitable for AI agents and natural-language query tools.

• Build or assist in the development of AI-powered reporting assistants and chatbots.

• Evaluate and integrate analytics tools based on large language models (LLMs).

• Establish guardrails for AI-generated analysis and ensure the reliability of outputs.

• Stay updated on AI/BI tools and suggest automation opportunities.

• Collaborate with stakeholders from Sales, Finance, Operations, Professional Services, IT, and engineering.

• Support the implementation of new tools, data sources, and automation initiatives.

⛳️ Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent practical experience).

• Over 3 years of experience in data engineering, BI analysis, or analytics engineering roles.

• Proficient in SQL, with experience in writing complex queries, optimizing performance, and handling large datasets.

• Experience in building and maintaining ETL/ELT pipelines using custom scripts or tools like Fivetran, dbt, Airflow, Workato, or similar.

• Practical experience with a BI/visualization tool (Tableau, Power BI, Looker, or similar).

• Strong understanding of data modeling concepts (dimensional modeling, normalization, star schemas).

• Experience with cloud data warehouses (Snowflake, BigQuery, Redshift, or similar).

• Analytical mindset with the ability to convert ambiguous business questions into structured data analysis.

• Excellent communication skills, capable of explaining technical concepts to non-technical stakeholders.

• Preferred: Experience with Python or another scripting language for data manipulation and automation.

• Preferred: Familiarity with CRM/ERP systems (Salesforce, NetSuite) and operational data flows.

• Preferred: Experience with API integrations and workflow automation platforms (Workato, Zapier, or similar).

• Preferred: Hands-on experience building or integrating AI/LLM-powered tools (Claude, ChatGPT, Copilot) into data workflows.

• Preferred: Familiarity with prompt engineering, retrieval-augmented generation (RAG), or agent-based architectures for analytics.

• Preferred: Experience in establishing data governance practices suitable for both human and AI consumers.

• Preferred: Prior experience in Professional Services, Finance, or Operations analytics.

🏝️ Benefits

• Competitive salary and performance-based incentives.

• Comprehensive health and wellness benefits.

• Opportunities for professional development and career advancement.

• Flexible working hours and remote work options.

• Collaborative and inclusive work environment.