We are looking for a Senior Data Warehouse Administrator to bolster our expanding data infrastructure team. Youll 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. Were 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 Youll 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 Youll Bring
58 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 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.
MongoDB DBA experience will be a plus.
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 3000 accounting teams including those at Snowflake Twilio Instacart and The Golden State Warriorsand 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 FloQasts 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 . 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
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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.