Job Role: SQL Developer
Reporting Line: Tech Lead
Industry: Insurance
Working Arrangement: Full-time, Contract (Third-party agency)
Working Location: Sentral Semanggi
Working Hours: Effective 8:00 AM – 5:00 PM (Paid overtime based on operational requirements)

Roles and Responsibilities

Logic & Automation: Build and maintain calculation logic using Stored Procedures, SSIS packages, and SQL Job Scheduler.
Collaboration: Collaborate with business and technical teams to understand requirements and deliver accurate data solutions.
Analytics: Provide analytical insights and support for data-driven decision-making.
ETL Pipeline: Design, build, and optimize ETL (Extract, Transform, Load) processes to ensure efficient data pipelines.
Data Integration: Perform data integration across multiple systems.
Data Governance: Ensure data quality and integrity through validation, error handling, and continuous improvements in data management processes.
Database Optimization & Solutions:
Write and optimize complex SQL queries.
Design staging tables, indexes, and partitions.
Monitor query performance and tune for efficiency.

Job Requirements

SQL Proficiency: Mandatory strong ability to write/read complex queries and perform query tuning.
Tools: Experience using SQL Server Integration Services (SSIS).
Cloud & Platform: Familiarity with Microsoft Azure Databricks, Azure SQL Database, and SQL Managed Instance (SQLMI).
Skills: Strong logical thinking, calculation skills, and troubleshooting abilities.
Education: Bachelor’s degree (S1) in Information Technology or a related technical field.

Experience & Qualifications

Years of Experience: 4–6 years as a SQL Developer (Experience in the insurance industry preferred).
Technical Knowledge: Extensive knowledge of SQL Server tools, database performance, development, and maintenance.
Security & Infrastructure: In-depth understanding of database security, backup/recovery, performance monitoring, and working knowledge of Windows Server infrastructures.
Cloud Services: Prior experience with Microsoft Azure cloud services.
Languages: Fluent in English (written and spoken).
Soft Skills: High attention to detail, proactive, accountable, highly motivated, adaptable, and capable of working independently or in a team.

SQL Developer

Terkait