Senior Data Warehouse Admin at Floqast

Pune, Maharashtra, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

N/AIndustries

Requirements

5–8 years of experience as a Data Warehouse Administrator or Data Platform Engineer
Expert-level knowledge of Data Warehouse administration
Proven experience with CDC tools, FiveTran, CData or similar ELT tools (e.g., Stitch, Airbyte)
Strong understanding of SQL tuning, partitioning, and query optimization
Deep knowledge of data warehousing concepts and modern data platforms
Exposure to Apache Iceberg, AWS Glue, and S3-based data lakes (plus)
Experience with CI/CD, infrastructure-as-code (e.g., Terraform), and monitoring tools
Familiarity with data modeling (star/snowflake schemas) and governance practices
Strong scripting skills in Python or Bash for automation
MongoDB DBA experience (plus)
AWS Certification(s) (preferred)
Experience in a regulated or enterprise-scale data environment (preferred)
Prior work with event-driven pipelines, streaming, or CDC mechanisms (preferred)

Responsibilities

Design, implement, and maintain scalable and secure data warehouse environments
Optimize data warehouse performance, including fine-tuning complex SQL queries, managing indexing, and monitoring workloads to ensure peak efficiency
Lead all administration tasks, encompassing user access control, Role-Based Access Control (RBAC), schema design, partitioning strategies, and ongoing cost optimization
Manage and monitor data ingestion pipelines, ensuring reliable ETL/ELT processes and demonstrating awareness of Change Data Capture (CDC) tools for efficient data flow
Collaborate closely with data engineers and data analysts to design and implement efficient data models and robust data transformations
Contribute significantly to modern data lake architecture, specifically leveraging Apache Iceberg for data organization and schema evolution
Implement and enforce data governance and compliance policies across the data warehouse and data lake environments
Build and maintain tools to automate common administrative tasks, such as table compaction, data expiration policies, and health checks
Lead troubleshooting and Root Cause Analysis (RCA) efforts for critical data issues, ensuring rapid resolution and preventing recurrence
Mentor junior data warehouse administrators and actively share best practices across the broader data and engineering teams

Skills

Apache Iceberg

SQL

CDC

ETL

ELT

RBAC

Data Warehouse

Data Lake

Schema Design

Partitioning

Data Governance

Indexing

Table Compaction

Root Cause Analysis

Floqast

Financial close management software for accounting teams

About Floqast

FloQast offers Financial Close Management Software that helps accounting teams automate and streamline the financial close process at the end of a fiscal period. The cloud-based solution integrates with existing ERP systems and Excel, allowing for automated reconciliations and organized financial documentation for audits. Unlike competitors, FloQast can be fully implemented and trained within two weeks, making it easier to adopt. The company's goal is to improve the efficiency and accuracy of financial reporting, reducing the workload for accounting teams.

Los Angeles, CaliforniaHeadquarters

2013Year Founded

$294.6MTotal Funding

SERIES_ECompany Stage

Enterprise Software, FintechIndustries

501-1,000Employees