Senior Data Warehouse Admin

We are looking for a Senior Data Warehouse Administrator to bolster our expanding data infrastructure team. You'll bring substantial expertise in architecting, managing, and optimizing large-scale data warehousing environments. Hands-on experience with modern data lake architectures, specifically leveraging Apache Iceberg for data organization and schema evolution, is essential. We're also looking for solid practical experience in building and maintaining robust data ingestion pipelines, ideally incorporating awareness of various Change Data Capture (CDC) tools to ensure efficient and timely data flow. Your deep SQL performance tuning skills will be critical, as will your ability to drive the efficiency and reliability of our data platform.

What You'll Do::
• 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 our 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.
• Tooling and Automation: Building and maintaining 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.

What You'll Bring:
• 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.
• 2+ Years of MongoDB DBA experience will be a must have.
• Exposure to Apache Iceberg, AWS Glue, and S3-based data lakes is a 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.

Preferred Qualifications::
• AWS Certification(s).Experience in a regulated or enterprise-scale data environment
• Prior work with event-driven pipelines, streaming, or CDC mechanisms.

About FloQast:
FloQast is the leading Accounting Transformation Platform in accounting workflow automation created by actual former accountants for accountants. By streamlining and modernizing daily accounting tasks, FloQast helps teams collaborate more effectively and complete their work with greater efficiency and precision. This cloud-based, AI-powered software is trusted by over 3,000 accounting teams, including those at Snowflake, Twilio, Instacart, and The Golden State Warriors—and continues to grow. Our mission is to continuously elevate the accounting profession, enhancing both its practice and perception.

By applying for this position, you acknowledge and consent to FloQast’s collection, use, processing, and storage of your personal information and application materials in accordance with our privacy policy and applicable law, including, but not limited to, your resume, cover letter, contact information, employment history, references, and any other details or information provided during the application and interview process. Your information may be shared with hiring managers, HR personnel, and other employees involved in the hiring process, as well as authorized third-party service providers who assist with our hiring process. You have the right to access, correct or request the deletion of your personal information at any time. To exercise these rights, or for other questions related to our data practices, please contact us at [email protected]. Your consent is voluntary, but please note that providing this consent is necessary for us to process your application and consider you for employment opportunities. For more details, please see our privacy policy at https://www.floqast.com/legal/privacy-policy.

FloQast, Inc is committed to operating fair and unbiased recruitment procedures allowing all applicants an equal opportunity for employment, free from discrimination on the basis of religion, race, sex, age, sexual orientation, disability, color, ethnic or national origin, or any other classification as may be protected by applicable law. We aim to recruit the right people for the jobs we have to offer, and to assess applications on the basis of relevant skills, education, and experience. We welcome people of different backgrounds, experiences, abilities, and perspectives. We are an equal opportunity employer and strive to provide a professional and welcoming workplace for all employees.