Data Engineer (Core SQL, VaultSpeed)

Hyderabad , India
contractor

AI overview

Design and maintain scalable data pipelines and solutions using Data Vault 2.0 methodology, collaborating closely with architects and business stakeholders to support data integration and governance.

Job Summary:

We are looking for a highly skilled Data Engineer with strong expertise in Core SQL and hands-on experience with VaultSpeed to join our growing data engineering team. You will be responsible for designing, developing, and maintaining scalable data pipelines and data warehouse solutions based on the Data Vault 2.0 methodology. Your work will directly support enterprise data integration, governance, and analytics initiatives.

Key Responsibilities:

  • Design and implement data models and pipelines using VaultSpeed to automate Data Vault architecture.
  • Write and optimize complex SQL queries for data extraction, transformation, and loading (ETL/ELT).
  • Work closely with data architects, analysts, and business stakeholders to ensure accurate and reliable data solutions.
  • Automate data ingestion from multiple source systems (batch and real-time).
  • Maintain and optimize data warehouse solutions using modern best practices.
  • Monitor, troubleshoot, and enhance data processes for reliability and performance.
  • Contribute to data governance and metadata management efforts.
  • Ensure data quality, lineage, and security throughout the data lifecycle.

Requirements

  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
  • 4+ years of professional experience in Data Engineering or similar role.
  • Strong expertise in Core SQL (joins, CTEs, window functions, performance tuning, etc.).
  • Hands-on experience with VaultSpeed and understanding of Data Vault 2.0 concepts.
  • Proficiency in working with modern data warehousing platforms (e.g., Snowflake, Azure Synapse, BigQuery, Redshift, etc.).
  • Familiarity with ETL/ELT tools and orchestration frameworks (e.g., dbt, Airflow, Talend, etc.).
  • Understanding of data modeling principles (3NF, Star Schema, Data Vault).
  • Experience with version control systems (e.g., Git) and CI/CD pipelines.

Unison Consulting was launched in Singapore on September 2012, the hub of the financial industry, with innovative visions in the technocratic arena. We are a boutique next-generation Technology Company with strong business-interests in Liquidity risk, Market Risk, Credit Risk and Regulatory Compliance. Unison provides technology consulting and services to implement Risk Management and Risk Analytics System for Financial Institutions. Our services suite comprises of Techno-Functional consulting, systems integration, Business Intelligence, information management, and custom development of IT solutions, plus project management expertise for financial institutions. We have expertise in latest cutting edge technology to achieve better total cost of ownership. Through our qualified professionals, we assist you drive your unique risk management strategies, whether that means efficient monitoring, improving risk appetite of the financial institutions, complying with regulations, or capturing growth opportunities through innovation, this is what maximizes your decision taking potential. At Unison Consulting, we view clients as partners, and our success is only measured by the success of our partners. So we put it all on the table in order to exceed expectations. Our staff consists of young, energetic and innovative consultants who are never afraid to challenge the conventions and push the boundaries in an effort to help our clients. For every project, no matter how large or how small, we strive to not only meet your needs, but deliver a showcase in your field.

View all jobs
Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Engineer Q&A's
Report this job
Apply for this job