What You'll Do on a Typical Day:
- Design, implement, and maintain systems that collect and analyze business intelligence data.
- Design and architect an analytical data store or cluster for the enterprise and implement data pipelines that extract, transform, and load data into an information product that helps the organization reach strategic goals.
- Create physical and logical data models to store and share data that can be easily consumed for different BI needs.
- Develop Tableau dashboards and features.
- Create scalable and high-performance data load and management process to make data available near real-time to support on-demand analytics and insights.
- Translate complex technical and functional requirements into detailed designs.
- Investigate and analyze alternative solutions to data storing, processing, etc., to ensure the most streamlined approaches are implemented.
- Serve as a mentor to junior staff by conducting technical training sessions and reviewing project outputs
- Design develop, and maintain a data model implementing ETL processes.
- Manage and maintain the database, warehouse, cluster with other dependent infrastructure.
- Work closely with data, products, and another team to implement data analytic solutions.
- Support production application and Incident management.
- Help define data governance policies and support data versioning processes
- Maintain security and data privacy by working closely with the Data Protection Officer internally.
- Analyze a vast number of data stores and uncover insights
What We re Looking For:
- Degree in computer sciences or engineering
- Overall, 3-5 years of experience in data data warehouse, ETL, and data modeling.
- 2+ years of experience working and managing large data stores, complex data pipelines, and BI solutions.
- Strong experience in SQL and writing complex queries.
- Hands-on experience with Tableau development.
- Hands-on working experience on Redshift, data modeling, data warehouse, ETL tool, Python, and Shell scripting.
- Understanding of data warehousing and data modeling techniques
- Strong data engineering skills on the AWS Cloud Platform are essential.
- Knowledge of Linux, SQL, and any scripting language
- Good interpersonal skills and a positive attitude
- Experience in travel data would be a plus.
