Data Warehouse Engineer and Analyst




Sam L.United Kingdom


OpenAug 15, 2019
If you're a rockstar Data Warehouse Engineer and analyst, creative, passionate about internet marketing and e-commerce who would like to work in a start-up environment and grow exponentially, read on!

We are looking for dynamic, dedicated and committed individuals with a strong desire to grow, that can drive the brand forward on its truly exciting journey.

About Trakileam

Trakileam is a global company that builds communities and transformative brands. We own the brands and take care of the entire customer journey, to deliver wow-worthy experiences that influence and empower millions of people globally.

Our culture is fast-paced and dynamic. We are data-driven enthusiasts, passionate about marketing, exponential technologies and innovation.

We have over 150 employees working around the world, connected by the same purpose and core values. Our support for this new way of working has led to being featured in Forbes and FlexJobs as one of the Top 25 Companies for Remote Workers.


Shapermint, Trafilea's largest brand, is a shapewear-exclusive, online retailer offering curated styles from top-rated brands. We've grown the brand to 1+ million customers in the first 9 months and are aiming to build one of the biggest communities on body positivity, self-love & confidence. Our main purpose is to empower women across the world.

We are looking for dynamic, dedicated and committed individuals with a strong desire to grow, that can drive the brand forward on its truly exciting journey.

Key Responsibilities

- Designs and supports the business's database and table schemas for new and existent data sources for the data warehouse.
- Plays a key role in technological decision making for the business's future data storing, analysis, and reporting needs. Adjust resources to seasonable difference in data volume and information requirements.
- Defines and promotes the department's best practices and design principles for data warehousing techniques and architecture.
- Guide the business in identifying any new data needs and deliver mechanisms for acquiring and reporting such information as well as addressing the actual needs.
- Strives to improve data organization and accuracy. Continuously improve the accuracy and efficiency of the analytics and reporting infrastructure.
- Monitors and troubleshoots performance issues on data warehouse servers and assists in the development of business intelligence, business data standards, and processes. Develop control alerts.
- Provides day-to-day support of the data warehouse and troubleshoots existing procedures and process.
- Plays an analytical role in quickly and thoroughly analyzing business requirements for reporting and analysis and subsequently translating the emanating results into good technical data designs.
- Establishes the documentation of reports, develops, and maintains technical specification documentation for all reports and processes. Implement reports using a modeling tools, based on metrics and dimensions.
- Define and implement self BI service strategic, developing data models and end users tool.

Requirements Required

- Experience in design, build, implement, and maintain BI databases and solutions.
- Experience in Data modeling in relational database schemas. Traditional modeling and normal forms.
- Knowledge in data warehouse modeling (star and snowflake schemes).
- SQL knowledge expert level. Must be able to write complex SQL queries.
- Experience in access and manage different databases (PostgreSQL). It must be able to connect and interact with the Databases without supervision. OLTP.
- Experience in transformation data processes (ETL)
- Multidimensional reports development. Knowledge slice / dice and management of dimensions.
- Bachelor's degree in Computer Science, Engineering, Statistics or quantitative focused study.

Nice to have:

- Management reports construction (KPI's, Dashboards, Timeseries, etc.) Desirable.
- Have experience in modeling OLAP multidimensional semantic schemes (Cubes, Tabular Models).
- Knowledge of Redshift.


- Live Where You Want: Proximity doesn't influence productivity. As a global distributed team, you can live and work wherever you want.
- Up Your Game: We love to see our people growing fast. We budget for it! Think courses, conferences, events.
- Paid vacation
- Competitive salary.
- Company performance bonus based on results.
- Get paid to exercise and meditate
- Family leave and dismissal protection

If After Reading This Job Post You Feel this Opportunity Is for You .. Please, Apply Now!

Skills & Expertise Required

"Extract, Transform and Load (ETL)" 

Offer to work on this project closes in 15 days!

Submit A Proposal

Share this project with your friends

Other jobs by this client

Wordpress Developer for a 10-page refresh of an existing desktop and mobile responsive website. - Hourly
Expert at Preventing Source Code Discovery/Copy - Hourly
Need someone to help create and add items to a website for small business - Fixed
Escrow payment app - Hourly
Math Tutor Needed for Stats and Deep Learning (backprop, gradient decent, etc.) - Hourly
web scraping python job on vps ubuntu 16.04 - Fixed
Setup jumpcloud & zerotier network for laptops (Must be available to work onsite initially - Delhi) - Fixed
Sr. MS SQL Server DBA / SQL Server Expert (On-going) - Hourly
AI engineer needed for interactive application - Fixed
VueJs Developer - long term - $8 per hour - Hourly
360 degree Camera live and record & review stitching application - Hourly
Need label designer for candle and bath soak jars - Fixed
furniture for the closed patio - Hourly

Freelancers You May Hire

Here are our top professional picks for you to hire

Similar Projects

Snowflake Data warehouse

I am looking for someone that has experience working with Snowflake - the cloud based data warehouse.

You should have experience with ETL/ELT
You should have experience loading data more

Hourly, $18.00

MS sql server ETL integration

Complete green field development from installation to develop ETL jobs

Hourly, $16.00