Data Warehouse Engineer

ZogoTech partners with community colleges and empowers them to use data to increase student success. Our Data Analytics Platform includes a data warehouse, an ETL (Extract, Transform, Load) framework that integrates data from multiple sources, and a web application with business intelligence reporting and ad hoc querying tools. As a Data Warehouse Engineer at ZogoTech, you will play a critical role in deploying, customizing, and supporting our platform. This is a hybrid engineering and support role. You will program back-end SQL and Python code as well as collaborating with customers to support their data needs. Platform Deployment & Support: Deploy, customize, and maintain the ZogoTech Analytics Platform to meet customer requirements. Customer Collaboration: Communicate with customers to understand their business needs, translate these requirements into code, and troubleshoot issues. SQL Mastery: Develop and optimize complex SQL queries and design database schemas for data integration and analysis. ETL & Integration: Integrate data from various institutional sources into our data warehouse using SQL, Python, and our ETL framework. Technical Operations: Use source code editors, version control systems, and command-line tools to manage ETL, systems administration, and troubleshooting tasks. Required Qualifications Proficiency in SQL: Deep experience with writing, optimizing, and managing SQL queries and database schemas. Programming Skills: Familiarity with Python or similar programming languages. Customer Communication: Strong verbal and written communication skills, with the ability to work directly with customers to understand and address their needs. Desired Qualifications (Pluses) Experience in higher education, particularly with institutional research or student data systems (Anthology, Ellucian Colleague, Banner, PeopleSoft). Experience with data warehousing and ETL processes. Familiarity with Windows Server, SQL Server, Linux, and PostgreSQL. Opportunities for Growth At ZogoTech, you will have the chance to grow in various technical and problem-solving domains, such as: Higher education institutional research Database performance optimization Cloud hosting and cybersecurity Data science and machine learning Competitive pay based on skills and experience Fully remote work environment Health, dental, and vision insurance options Continuing education reimbursement Additional Requirements Work Authorization : Candidates must be authorized to work in the United States. Sponsorship is not available for this role. Interview Process : Final candidates will be required to participate in an in-person interview held in Austin, Texas. Training : If selected, the candidate must be available to attend in-person training for several weeks at our Austin, Texas location. Our Culture At ZogoTech, we strive to foster a collaborative environment where team members tend to stay long-term. We value intellectual humility, guided by principles like the 10 Commandments of Egoless Programming . Our team is smart, friendly, and fun to work with, making ZogoTech a place where you can grow both personally and professionally. #J-18808-Ljbffr