We are seeking a Data Governance and Integration Specialist to join our Business Intelligence team. In this pivotal role, you will act as a bridge between technical and business teams, managing data contracts with other departments and ensuring our BI products for B2B clients remain consistent and reliable amidst changes. Your primary focus will be to oversee the quality and integrity of data flowing into our BigQuery Data Warehouse from various internal and external sources, proactively handling schema changes, and fostering strong inter-team collaboration.
**Key Responsibilities**:
- Manage Data Contracts:
- Define, document, and enforce data contracts to formalize agreements on schema stability, data quality, and change management processes.
- Establish clear escalation paths and timelines for handling schema changes impacting downstream systems.
- Facilitate Cross-Team Collaboration:
- Act as the liaison between the BI team and upstream data source teams to ensure alignment on data requirements, schema changes, and SLAs.
- Build effective communication channels for sharing updates, troubleshooting issues, and coordinating data-related changes.
- Host regular meetings with upstream teams to anticipate and plan for upcoming changes.
- Monitor and Analyze Data Pipelines:
- Use monitoring tools to track changes in data pipelines and external integrations, ensuring mínimal disruption to reporting and analysis.
- Assess backend system releases and updates to evaluate potential impacts on data flows, reporting, and B2B partner operations.
- Implement Data Governance Processes:
- Design and implement scalable workflows to manage schema changes and data updates.
- Develop and maintain documentation of data integration workflows, dependencies, and changes.
- Establish best practices for reliable and consistent data processes across the organization.
- Communicate Proactively:
- Inform B2B partners and internal stakeholders about changes affecting shared data or integrations.
- Collaborate with technical teams to communicate risks, implement solutions, and ensure smooth data operations.
**Requirements**:
- Strong understanding of data integration processes in cloud environments, preferably BigQuery.
- Proficiency in SQL and knowledge of relational databases such as PostgreSQL.
- Experience with tools that monitor data pipelines and external integrations.
- Analytical mindset to evaluate system changes and their impact on business operations and partnerships.
- Excellent communication and collaboration skills to coordinate with internal teams and external partners.
- Strong organizational skills with attention to detail in documenting workflows and changes.
- Ability to develop and enforce data governance processes and data contracts.
- Experience in project management or coordination roles is a plus.