As a Senior Data Warehouse Administrator, you will design, optimize, and manage scalable data warehousing environments, ensuring efficient data ingestion, performance tuning, and collaboration with data teams.
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.
- 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 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.
Top Skills
Apache Iceberg
Aws Glue
Bash
Cdata
Change Data Capture Tools
Elt Tools
Fivetran
MongoDB
Python
S3
SQL
Terraform
Similar Jobs at FloQast
Artificial Intelligence • Fintech • Software
The Senior AI Engineer will architect and develop AI products for an accounting automation platform, leading technical direction and mentoring the AI team.
Top Skills:
Ai FrameworksAPIsAWSChatbotsPython
Artificial Intelligence • Fintech • Software
The Tech Lead Manager will oversee system architecture, manage a team of engineers, and improve code quality and technical decisions while mentoring teammates.
Top Skills:
AILangchainLanggraphVector Databases
Artificial Intelligence • Fintech • Software
As a Senior Software Engineer, you will architect and develop resilient services, drive technical direction, mentor engineers, and solve complex technical challenges in a cloud-native environment.
Top Skills:
AWSContainer OrchestrationGoInfrastructure As CodeJavaMongoDBNoSQL
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
