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

Key technologies and capabilities for this role

Apache IcebergSQLCDCETLELTRBACData WarehouseData LakeSchema DesignPartitioningData GovernanceIndexingTable CompactionRoot Cause Analysis

Questions & Answers

Common questions about this position

What experience level is required for the Senior Data Warehouse Admin role?

The role requires 5–8 years of experience as a Data Warehouse Administrator or Data Platform Engineer.

What are the key technical skills needed for this position?

Key skills include expert-level knowledge of data warehouse administration, proven experience with CDC tools like FiveTran or CData, strong SQL tuning and query optimization, deep knowledge of data warehousing concepts, and scripting in Python or Bash. Exposure to Apache Iceberg, AWS Glue, S3-based data lakes, CI/CD, Terraform, and data modeling is also valued.

Is remote work an option for this role?

This information is not specified in the job description.

What is the salary or compensation for this position?

This information is not specified in the job description.

What does the team structure look like for this role?

You'll join the expanding data infrastructure team, collaborating closely with data engineers and data analysts, and mentoring junior data warehouse administrators.

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