Skill diminta
AuditingCommunicationConfluencePower BISQLSnowflake
Deskripsi
- Deskripsi pekerjaan Business Intelligence IT Data Senior Jakarta Integrasi Optimal Visitama (IOV)
- Candidat must ready to work immediately (No one month notice please), On Site Jakarta.
- Core Responsibilities
- Expert in SQL for data collect and managing
- Perform daily data quality monitoring across data assets and Power BI (dataset, dataflow, semantic model) refreshes.
- Expert in PowerBI, able to detect, log, and track data quality breaches and Power BI refresh failures
- Act as first-line RCA support: analyze failures using SQL, refresh logs, and pipeline signals; escalate with clear evidence.
- Validate data timeliness, completeness, accuracy, and consistency against defined DQ rules and SLAs.
- Technical Execution
- Write and maintain SQL queries for data validation, anomaly detection, and RCA investigations.
- Implement and operate data quality checks using Pushkin, Great Expectations, or equivalent frameworks.
- Support Power BI failure analysis (refresh history, gateway issues, upstream dependency checks).
- Produce concise DQ evidence: query outputs, before/after comparisons, impact assessment.
- Operational & Administrative Ownership
- Maintain DQ documentation: Confluence pages, rule inventories, severity definitions, RCA logs.
- Update incident records, monitoring dashboards, and remediation status trackers.
- Support coordination with BI, DE, and Data Owners during incidents and post-mortems.
- Ensure DQ artifacts are audit-ready and current (rules, thresholds, ownership, SLAs).
- Operational & Administrative Ownership
- Maintain DQ documentation: Confluence pages, rule inventories, severity definitions, RCA logs.
- Update incident records, monitoring dashboards, and remediation status trackers.
- Support coordination with BI, DE, and Data Owners during incidents and post-mortems.
- Ensure DQ artifacts are audit-ready and current (rules, thresholds, ownership, SLAs).
- Reporting & Communication
- Daily operational monitoring summary (issues detected, status, next actions).
- Weekly DQ status reporting (trends, recurring issues, SLA adherence).
- Monthly DQ compilation (rule coverage, incidents, RCA themes, improvement actions).
Cross-channel collaboration
- Handle day-to-day request and new business cases from multiple stakeholders, ensuring their data needs are met promptly and accurately.
- Connect and collaborate with various teams not only internal but also 3rd party agency relates to brief and solutions.
- Ensure effective communication and collaboration to align on goals and strategies, providing data insights that support decision-making across departments.
Other
- excellent in operate PowerBI and any SQL front end tools (snowflake preferable)
- capable of operating and generating custom reporting from PowerBI .
- Having a familiarity with powerautomate or any automation orchestration tools is a bonus.