Job Description
- 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).
Requirements
- Knowledge of data architecture and data lake/warehouse concepts.
- Experience with REST APIs and JSON/XML parsing.
- Familiarity with cloud platforms (AWS, GCP, Azure) and tools such as BigQuery, Redshift, Snowflake.
Tips Menjaga Diri
Perusahaan dan Lowongan di Dealls tidak meminta data pribadi, informasi rekening, atau pungutan ketika melamar. Hindari juga lowongan Google Form / Grup Telegram tanpa keabsahan yang jelas.
ITSEC is one of the leading cybersecurity companies in the APAC region, listed on the Indonesian Stock Exchange (IDX), with over 300 employees across five countries. We deliver end-to-end cybersecurity services and solutions, including Consulting Services, Security Solutions Integration, and Managed Security Services. ITSEC provides continuous IT infrastructure protection against multiplying cybersecurity threats and ensures compliance with increasingly demanding data protection and critical infrastructure regulations. Our expertise has been built over a decade of delivering thousands of high-quality cybersecurity projects, providing cutting-edge solutions in collaboration with world-class technology partners across financial, telecommunications, energy, transportation, manufacturing, and other critical industry sectors. We also have extensive experience in helping our customers with fraud prevention, Operational Technology (OT), and Industrial IoT (IIoT) security.
