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 237 days!

Submit A Proposal

Share this project with your friends

Freelancers You May Hire

Here are our top professional picks for you to hire

Similar Projects

MS sql server ETL integration

Complete green field development from installation to develop ETL jobs

Hourly, $16.00

Data/JSON + Mongo DB expert

We are national a chain of restaurants. We have a strong digital presence with apps and a responsive website to support ordering and our loyalty program with a development team has builds and more

Hourly, $28.00

use AI and ML data analysis to valu...

1. Perform research on used vehicle pricing and feedbacks/comments from public websites. 2. For used vehicle, analysis on the information from websites and apply the depreciation rate for the used more

Hourly, $36.00

Database Architect

1.Design and implement effective database solutions and models to store and retrieve data.
2.Examine and identify database structural necessities by evaluating client operations, applications, more

Hourly, $20.00

Easy Job if you're Familiar wi...

We have created over 30,000 books which are to be sold on Amazon.

We need someone who is familiar with FTP and SFTP to upload our books onto Kindle Enterprise Publishing (KEP) through bulk more

Hourly, $16.00