Heads Talent Solutions has partnered with Ananas E-commerce. We are looking for a Senior BI Developer who will be responsible for designing and constructing critical components of the BI platform, including dataflows, datasets, automated reports, DWH, advanced analytics visuals, and dashboards.
You have a unique opportunity to leverage data from different sources of Ananas ecosystem and transform them into valuable insights which help us make data driven decisions, support our business and improve customer experience.
Key responsibilities:
- Using cloud storage and analytics services Amazon Redshift, MS Power BI, AWS Glue, Amazon S3, and so on, in order to build a modern BI platform as part of our analytics system.
- Using BI tool on expert level, currently we use MS Power BI and it is one of the crucial tools for our users to gain insights to the business. You will get to design and build all the most important components like dataflows, datasets, automated reports, advanced analytics visuals and dashboards.
- Modeling different analytical data layers as a basis for the reporting needs, intensively using and contributing to developing DWH built on Amazon Redshift, and developing basic ETL solutions.
- Designing and developing end to end BI products and solutions, dealing with complete data lifecycle. It will go through data extraction, cleansing and preparation, transformation, modeling, processes automation, and so on.
- Analyzing end users’ requirements, and acting as an advisor on getting the best value out of our data.
- Supporting in setting company-wide key metrics related to different business areas e.g. logistic, marketing, sales, finance, etc.
- Providing training to business end users, advocating self-serve reporting concept, and improving data literacy of the company.
- Collaborate closely with data engineers and other departments in order to build a highly effective BI platform and to identify opportunities for data process improvement and automation.
Essential skills:
- Academic degree in informatics, mathematics, economics, or similar
- 5+ years of working experience in BI Development, DWH, Analytics Engineering, or related role
- Strong and active knowledge of SQL related to data extraction, transformation, and modelling
- Relevant experience in any cloud-based data warehousing platform (preferably AWS Redshift, or Snowflake)
- Expert in at least one BI tool, e.g. Power BI (preferably), Tableau, Google Looker
- Relevant experience in any SQL based DBMS (preferably PostgreSQL, but not limited to, MS SQL Server, Oracle are also welcome)
- Understanding of relational DB principles, ETL workflows, and DWH concepts
- A curiosity and interest in data, fast data, big data, data governance, data insights
- Goal-oriented self-starter, who is a proactive in driving the results
- Analytical and scientific approach mindset
- Fluency in English
Nice to have:
- Experience in using Python programing language and libraries for querying and processing data such as Pyspark, Pandas, NumPy, etc.
- Experience in using of AWS cloud data storage and analytics services such as Redshift, Glue, RDS, S3,
- Familiar with Data Lake or Data Lakehouse concepts.
We offer:
- The opportunity to work on a complex, scalable in-house product from scratch.
- A fast-paced, corporate start-up environment.
- Modern engineering practices and standards.
- Competitive compensation package.
