Skip to main content

IT SQL Developer | Project based

Technology
NISPI
Makati, Philippines2 days ago
Full timeOn-site

Job description

The SQL Developer will work with Data Analytics team to enhance and support the ADaM ODS and other SQL development on data analytics. This role will primarily focus on the operational data store to accommodate the data requirements of downstream applications.

Responsibilities include:

  • Work with Data Engineers, ETL developers and Data Analytics team to build a robust data pipelines for our data platforms via stored procedures, views and SQL queries
  • Execute on technical requirements and document new ones when needed
  • Diagnosing and resolving defects of ODS and other data platform
  • Document technical requirements, architecture diagrams, data dictionaries, and pipeline operational procedures.
  • Proactively monitor data workflows, identify bottlenecks, and resolve operational issues.
  • Extract and ingest data from diverse sources including production databases, and third-party systems.
  • Implement data validation routines to enforce high data governance, integrity, and cleanliness standards.
  • Apply best practices for development of stored procedures, views, indexes and SQL queries
  • Understanding the technical architecture of ADaM ODS and other data platforms
  • Protect the confidentiality and security of client data
  • Understand business processes and requirements from the business and mapping documents
  • Work both independently and as part of a team
Required Qualifications:
  • 5 to 10+ years of work experience as a SQL Developer
  • Proven ability to learn new tools and technology
  • Expert level SQL with the ability to create and evaluate complex SQL statements, stored procedures, and index tables
  • Strong programming skills in Python, Scala, or similar languages for scripting and data manipulation.
  • Demonstrated ability to work in a fast paced and changing environment with short deadlines, interruptions, and multiple tasks/projects occurring at once
  • Knowledge and understanding of ETL workflow is a plus
  • Excellent communication skills to work effectively across cross-functional engineering and business teams.
  • Proven ability to work both independently with minimal supervision and collaboratively as a proactive part of a team.
Working Arrangement: 3x onsite per week.

Pay: Php80,000.00 - Php90,000.00 per month

Work Location: In person

Keywords
information-technologysqlanalyticsdata-analyticsoperational-data-store-odstraining-and-developmentextract-transform-and-load-etldata-pipelinedata-platformdata-validationdata-governancepolicies-and-practicescustomer-datainsurance-consulting-and-technologypythonscalascriptingdata-processingenvironment-health-and-safety-hsseecology-environment

Interested in this role?