Deskripsi Pekerjaan
- Identify various data sources (internal and external), such as ERP, CRM, financial applications, HRIS, and legacy systems.
- Design and implement ETL (Extract, Transform, Load) pipelines to combine data from various systems into a single data warehouse or lake.
- Work with APIs, middleware, or database connections (ODBC, JDBC) to automate cross-platform data integration.
- Standardize data formats to be uniform and can be analyzed (data cleaning, mapping, normalization).
- Define and monitor data quality metrics to ensure the integrity and accuracy of analytical results.
- Manage metadata and create documentation of data integration flows.
- Use tools (SQL, Python, R, Power BI, Tableau, Looker) for complex cross-system analysis.
- Create cross-division dashboards (finance, operations, sales) from combined data for business decision making.
- Work closely with IT/developer teams to ensure integrations are secure and efficient.
- Coordinate with business users to understand data needs and suggest relevant integrations.
- Develop integration automation scripts (e.g. in Python or using tools such as Apache Airflow, Alteryx).
- Provide input on new system designs to ensure smooth future data integrations (design for integration).