Data Engineer

In the story of Snappfood, we believe in creating value that goes beyond the ordinary. We are willing to establish innovative tendencies and are eager to have you on our team to help us get through our business challenges with creativity, intelligence, and agility.We are waiting for you to continue this story.

Responsibilities:

•  Design and develop an optimized stable solution for data infrastructure to handle all
  data user’s needs and provide custom detail-oriented tables, pipelines, cubes, and
  reports utilizing traditional and ad-hoc BI reporting tools
• Performing detailed database queries
• Develop and maintain detailed technical documentation of data pipeline processes
• Ensure that data pipeline solutions align with industry best practices
• Develop the packages and procedures to retrieve data from various resources, cubes,
  and dimensions
• Develop ETL (extract, transform, load) processes to help extract and manipulate data
  from multiple sources
• Prepare raw data in Data Warehouses into a consumable dataset for both technical
  and non-technical stakeholders
• Establish optimized pipelines connected to various data sources, including MySQL,
  SQL server, G-sheets
• Design and implement data models that support reporting and analytic needs
  specified
• Monitor data systems performance and implement optimization strategies
• Leverage data controls to maintain data privacy, security, compliance, and quality for
  allocated areas of ownership

Requirements:

• Solid knowledge of data warehouse design, implementation, and maintenance
• Ability to design fact and dimension tables according to the needs of business
  functions
• Ability to write complex and optimal T-SQL queries in order to obtain the required data
• Experience in ETL process using SSIS to implement packages’ data pipelines and
  generate automatic jobs to retain them
• Solid knowledge of database performance tuning and administration (indexing,
  partitioning, compression, and ETC)
• A passion for creating solutions with a positive attitude to change
• Communicate effectively with other teams to integrate systems or gather requirements
• Creating and maintaining documentation that includes the design, requirements, and
  user manuals for the BI team members
• Database maintenance and retaining the table states
• Experienced in creating data model in SSAS(Tabular), Microsoft PowerBI, using DAX
  to deploy required measures is plus
• Familiarity with Python,data pipeline and workflow management tools (e.g., Airflow,
  Azkaban) is a plus

Benefits: 

• Credit for: Gym, Therapy, Internet Costs 
• Social Security & Complementary Insurance 
• Educational platform of advanced courses 
• Snappfood's Discount codes
• Loans