Note: The job is a remote job and is open to candidates in USA. IntralogisKIT provides modular warehouse software aimed at improving operations for small and growing warehouses. They are seeking a Data Warehouse Administrator to design and maintain data structures that support analytics and reporting, while collaborating with engineering and product teams.
Responsibilities
- Design, implement, and maintain data warehouse structures that support reporting, analytics, and product features
- Managing database performance
- Monitoring data integrity
- Optimizing queries and storage
- Designing and maintaining data models
- Configuring and supporting ETL pipelines
- Ensuring reliable data flows between operational systems and the data warehouse
- Collaborate closely with engineering and product teams to understand data requirements
- Implement best practices for security and backups
- Document data structures, processes, and standards
Skills
- Strong database administration skills, including setup, configuration, performance tuning, backup/recovery, and monitoring for relational databases
- Experience with data warehousing and data modeling, including star/snowflake schemas and dimensional modeling for analytics
- Hands-on experience with Extract Transform Load (ETL) processes and tools, including designing, optimizing, and troubleshooting data pipelines
- Solid understanding of databases and SQL, including query optimization and working with large datasets in cloud or on-prem environments
- Ability to document data architectures, schemas, and processes clearly for technical and non-technical stakeholders
- Experience collaborating with software engineering, analytics, or product teams in an agile or iterative environment
- Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience
- Strong problem-solving skills, attention to detail, and the ability to work independently in a remote, distributed team
- Familiarity with modern data platforms (e.g., cloud data warehouses, containerized deployments, or orchestration tools) is beneficial
Company Overview