- Design, build, and maintain ETL/ELT pipelines that integrate data from source systems into data warehouses or data marts.
- Validate, test, and monitor pipelines to ensure data quality, consistency, and integrity.
- Optimize data models for reporting performance and troubleshoot pipeline failures, latency, and discrepancies.
- Automate manual data processes and manage data source connections, credentials, and refresh schedules.
- Build and maintain dashboards and reports that translate raw data into actionable insights.
- Gather reporting requirements from stakeholders and translate them into technical specifications.
- Define and maintain business metrics, a data dictionary, and a metrics glossary.
- Conduct ad hoc analysis and improve reports based on dashboard usage and stakeholder feedback.
- Document data lineage, business logic, and calculation methodology.
- Design data structures for AI agents and natural-language query tools, and build or support AI-powered reporting assistants.
- Evaluate and integrate LLM-based analytics tools and establish guardrails for AI-generated analysis.
- Collaborate with department leaders and act as a technical liaison between business teams and IT/engineering.
PythonSQLMicrosoft Power BI+4 more