InvoiceCloud is a fast-growing fintech leader seeking a Data Warehouse Engineer to design, standardize, and optimize data pipelines connecting all solution area source systems to the enterprise data warehouse.
Requirements
- Design, standardize, and optimize data pipelines connecting all solution area source systems to the enterprise data warehouse
- Implement automated, scalable Snowflake development workflows
- Ensure the warehouse architecture fully supports advanced data science and analytics initiatives
- Design, administer, develop, and deploy real-time, automated, and scalable data pipelines from multiple source systems into the enterprise data lake and/or data warehouse
- Develop and implement auditing, logging, and data quality strategies to ensure reliability, accuracy, and consistency of large-scale data workflows
- Diagnose and resolve issues in high-volume data processing systems, ensuring minimal downtime and data integrity
- Collaborate closely with technology teams, business stakeholders, and solution area partners to define data requirements and deliver secure, timely access to critical data
- Optimize pipeline and query performance using profiling tools, SQL, Python, and other performance tuning methods
- Translate operational and analytical requirements into effective data warehouse designs and solutions
- Maintain in-depth knowledge of source systems and downstream consumers to champion data quality and usability across the organization
- Participate in architecture reviews, contribute to best practice guidelines, and help establish data governance standards
- Continuously research and adopt emerging technologies and approaches to improve warehouse performance and scalability
Benefits
- Base salary is one component of total compensation
- Employees may also be eligible for an annual bonus or commission
- Some roles may also be eligible for overtime pay
