Kalera
Data Warehouse Engineer
Kalera, Orlando, Florida, us, 32885
Description
What You'll Do
Our 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 analysisMakes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of data warehouse architectureDevelop and maintain database stored procedures, views, and functions that support data modelsWorks 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 setupProvide expert thought leadership in the development and implementation of data governance policies and processesProvide data management support and work cooperatively with the product team to resolve data and process issuesCreate 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 stackStrong familiarity with Kimball methodologies of data warehousingAbility to communicate verbally and in writing with end users and technical users to translate requirements from end users into useful visualizations and analysisComprehensive grasp of data visualization methods and data modeling for effective database architecture to streamline business analysis and reportingSSMS, ETL Tooling, Reporting experience such as Power BI or equivalent toolsIn-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)Broad business experience with proficient ability to talk in business termsExcellent verbal and written communication skills
Equal Opportunity Employer
At Kalera, Inc. all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, veteran status, sexual orientation, gender identity or any other basis protected by applicable law.
What You'll Do
Our 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 analysisMakes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of data warehouse architectureDevelop and maintain database stored procedures, views, and functions that support data modelsWorks 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 setupProvide expert thought leadership in the development and implementation of data governance policies and processesProvide data management support and work cooperatively with the product team to resolve data and process issuesCreate 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 stackStrong familiarity with Kimball methodologies of data warehousingAbility to communicate verbally and in writing with end users and technical users to translate requirements from end users into useful visualizations and analysisComprehensive grasp of data visualization methods and data modeling for effective database architecture to streamline business analysis and reportingSSMS, ETL Tooling, Reporting experience such as Power BI or equivalent toolsIn-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)Broad business experience with proficient ability to talk in business termsExcellent verbal and written communication skills
Equal Opportunity Employer
At Kalera, Inc. all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, veteran status, sexual orientation, gender identity or any other basis protected by applicable law.