Senior Business Intelligence Analyst & Data Engineer- Remote

DeepSource Technologies; United States; Remote; USD 78,000 - 123,000; Full time

Job summary

DeepSource Technologies is seeking a remote Business Intelligence Analyst & Data Engineer to own the full data lifecycle from pipelines to dashboards. The role spans data infrastructure, analytics, and AI-driven insights, with a focus on reliable data products for stakeholders across the organization.

You’ll work across ETL/ELT design, data quality, modeling optimization, and governance, collaborating with Sales, Finance, Operations, and IT.

Qualifications

• Ownership of end-to-end data products from pipelines to dashboards.
• SQL-heavy with large datasets and complex queries.
• Experience with ETL/ELT pipelines and BI tools.
• Ability to translate business questions into data analyses.
• Storytelling and analytics mindset with AI/LLM awareness.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines integrating data from multiple sources into centralized warehouses or marts.
• Ensure data quality, consistency, and integrity across pipelines via validation, testing, and monitoring.
• Optimize data models (star/snowflake) for reporting performance.
• Automate manual data processes and reduce ad hoc spreadsheet work.
• Manage data source connections, credentials, and refresh schedules.
• Troubleshoot and resolve data pipeline failures and discrepancies.
• Build and maintain dashboards/reports in Tableau/Power BI/Looker highlighting actionable insights.
• Partner with stakeholders to gather reporting requirements and translate them into specs.
• Define and maintain a single source of truth for key metrics and data dictionary.
• Conduct ad hoc analyses to inform strategic decisions.

Skills

SQL proficiency

Data engineering

Analytical mindset

Stakeholder communication

AI/LLM awareness

End-to-end data lifecycle

Education

Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or related field

Tools

Tableau

Power BI

Looker

ETL tools (Fivetran, dbt, Airflow)

Snowflake / BigQuery / Redshift

Job description

We’re looking for a remote Business Intelligence Analyst & Data Engineer for our client in Ireland, who can operate across the full data lifecycle - from building and maintaining reliable data pipelines to designing dashboards and reports that drive business decisions. This role sits at the intersection of data infrastructure and analytics: you’ll own how data flows into our systems and how it’s ultimately consumed by stakeholders across the organization.

This is a great fit for someone who enjoys both the technical rigor of data engineering and the storytelling/analytical side of BI work, and who wants ownership over an end-to-end data product rather than sitting in just one lane. AI-driven analytics is a growing part of our roadmap, so we’re especially interested in candidates who are curious about applying AI/LLM tools to make data more accessible and self-service across the business.

Key Responsibilities

Data Engineering

• Design, build, and maintain ETL/ELT pipelines that integrate data from multiple source systems (CRM, ERP, project management tools, spreadsheets, APIs) into centralized data warehouses or data marts
• Ensure data quality, consistency, and integrity across pipelines through validation, testing, and monitoring
• Optimize data models (star/snowflake schemas) for reporting performance
• Automate manual data processes and reduce reliance on ad hoc spreadsheet work
• Manage data source connections, credentials, and refresh schedules
• Troubleshoot and resolve data pipeline failures, latency issues, and discrepancies

Business Intelligence & Analytics

• Build and maintain dashboards and reports (e.g., in Tableau, Power BI, or similar) that translate raw data into clear, actionable insights
• Partner with business stakeholders to gather reporting requirements and translate them into technical specifications
• Define and maintain a single source of truth for key business metrics (a data dictionary / metrics glossary)
• Conduct ad hoc analysis to answer business questions and support strategic decision-making
• Monitor dashboard usage and proactively improve reports based on stakeholder feedback
• Document data lineage, business logic, and calculation methodology for transparency and auditability

AI-Enabled Analytics

• Design and maintain data structures (clean schemas, semantic layers, metric definitions) that are well-suited for consumption by AI agents and natural-language query tools, not just human-facing dashboards
• Build or support AI-powered reporting assistants/chatbots that let stakeholders ask business questions in plain language and get accurate, governed answers
• Evaluate and integrate LLM-based tools into the analytics stack (e.g., automated insight generation, anomaly detection, natural-language-to-SQL interfaces)
• Establish guardrails for AI-generated analysis - certified data sources, citation of underlying data, and validation processes to ensure trustworthy outputs
• Stay current on AI/BI tooling trends and proactively recommend where automation or AI can reduce manual reporting work

Cross-Functional Collaboration

• Work closely with department leaders (Sales, Finance, Operations, Professional Services, etc.) to understand data needs and pain points
• Act as a technical liaison between business teams and IT/engineering on data-related initiatives
• Support the rollout of new tools, data sources, or automation initiatives (e.g., AI-powered reporting agents, workflow automation platforms)
• Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent practical experience)
• 6+ years of experience in a data engineering, BI analyst, or analytics engineering role
• Strong SQL skills, including experience writing complex queries, optimizing performance, and working with large datasets
• Experience building and maintaining ETL/ELT pipelines (custom scripts, or tools like Fivetran, dbt, Airflow, Workato, or similar)
• Hands-on experience with a BI/visualization tool (Tableau, Power BI, Looker, or similar)
• Solid understanding of data modeling concepts (dimensional modeling, normalization, star schemas)
• Experience working with cloud data warehouses (Snowflake, BigQuery, Redshift, or similar)
• Strong analytical mindset with the ability to translate ambiguous business questions into structured data analysis
• Excellent communication skills - able to explain technical concepts to non-technical stakeholders

Preferred Qualifications

• Experience with Python or another scripting language for data manipulation and automation
• Familiarity with CRM/ERP systems (Salesforce, NetSuite) and how operational data flows from them
• Experience with API integrations and workflow automation platforms (Workato, Zapier, or similar)
• Hands-on experience building or integrating AI/LLM-powered tools (e.g., Claude, ChatGPT, Copilot) into data workflows - such as natural-language querying, automated report generation, or AI-driven data agents
• Familiarity with prompt engineering, retrieval-augmented generation (RAG), or agent-based architectures as applied to analytics
• Experience establishing data governance practices (certified data sources, metric definitions, documentation standards) suitable for both human and AI consumers
• Prior experience in a Professional Services, Finance, or Operations analytics function