Data Warehouse Engineer and Analyst

Job description

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 Trafilea

Trafilea 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

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.

Benefits

  • 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!