Business Intelligence Analyst & Data Engineer- Remote

We're looking for a hybrid Business Intelligence Analyst & Data Engineer 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) Requirements • Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent practical experience) • 3+ 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