Remote Network And System Administration Job In IT And Networking

Data Warehouse Engineer and Analyst

Find more Network And System Administration remote jobs posted recently Worldwide

If youre 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

Shapermint, Trafileas largest brand, is a shapewear-exclusive, online retailer offering curated styles from top-rated brands. Weve 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 businesss database and table schemas for new and existent data sources for the data warehouse.
- Plays a key role in technological decision making for the businesss future data storing, analysis, and reporting needs. Adjust resources to seasonable difference in data volume and information requirements.
- Defines and promotes the departments 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.
- Bachelors degree in Computer Science, Engineering, Statistics or quantitative focused study.

Nice to have:

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

Benefits

- Live Where You Want: Proximity doesnt 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!
About the recuiter
Member since Aug 15, 2017
Martin D.
from Maharashtra, India

Skills & Expertise Required

"Extract, Transform and Load (ETL)" 

Open for hiringApply before - May 27, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$19.19

Cost

Offer to work on this project closes in 28 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Support for ElasticSearch and Logstash

We look for an EKL expert to help our team occasisonally to set up ELK servers and logstash imports of Databases and CSV files.
Your good communication skills in English and availability are important factors.

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 maintains it.

We are also integrated into vario...read more

Azure SQL ETL Architect Needed - Data Factory & Logic Apps

We are looking for someone that has extensive experience using Azure services

We have setup an Azure SQL Database and would like to use Data Factory, Data Flow, and/or Logic Apps to pull in data from FTP CSV files as well as REST APIs into o...read more

Ebay Products Lister/Researcher

We are looking for Ebay products lister and researcher.
Full coaching - no experience needed.
We are waiting for you if you believe you are fast learner.

Looking for Java, VBA, SQL Server PL/SQL expertie

What I have:

1. Different kinds of source files needs to loaded into database tables.
2. Source file may be a flat file or excel or xml etc. with different kinds of delimiters.

What I need for the above requirement:

1...read more