DescriptionWhat You'll DoOur Data Warehouse Engineer will be part of a team that will manage the operations and analytics of the product data warehouse at Kalera. The Data Warehouse Engineer role is to develop and maintain reporting and analysis databases using SQL, A/L, MS Synapse, and PowerBI ensuring high levels of data accessibility and availability. They will also evaluate and advise on database architecture in the product data warehouses. If you love cross-departmental collaboration, data warehouse design, technical execution, and thrive in an environment of project ownership then we want to hear from you.
Take a peek!- Works closely with IT partners and the product teams to lead and participate in the identification, planning, prioritizing, requirements gathering, design, development and implementation of all Data Warehousing and BI projects.
- Architect and maintain data warehouses to support ease of data modeling, reporting, and analysis using dimensional model architecture (such as star schemas and OLAP cubes)
- With support from the product team you will gather requirements to grow and improve the data warehouse for reporting, BI integration, and ad hoc analysis
- Makes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of data warehouse architecture
- Develop and maintain database stored procedures, views, and functions that support data models
- Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
- Develop and maintain ETL processes, diagnose and resolve database access and performance issues, and plan and coordinate backup and disaster recovery setup
- Provide expert thought leadership in the development and implementation of data governance policies and processes
- Provide data management support and work cooperatively with the product team to resolve data and process issues
- Create and maintain technical documentation
What you'll have!- Bachelor's degree in Computer Science, Computer Engineering or relevant field.
- At least five years or more of experience in ETL processes, data warehouse architecture and or administration within the Microsoft/SQL stack
- Strong familiarity with Kimball methodologies of data warehousing
- Ability to communicate verbally and in writing with end users and technical users to translate requirements from end users into useful visualizations and analysis
- Comprehensive grasp of data visualization methods and data modeling for effective database architecture to streamline business analysis and reporting
- SSMS, ETL Tooling, Reporting experience such as Power BI or equivalent tools
- In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
- Broad business experience with proficient ability to talk in business terms
- Excellent verbal and written communication skills
