Job Summary

Needs to have the ability to work with business and technical stakeholders to understand the business requirements, extract the analysis needed, study the data available and produce a data product that can support a company\xe2\x80\x99s decision-making process and advanced analysis of information. Able to design, build, operationalize, secure and monitor data processing systems with emphasis on security and compliance; scalability and efficiency; reliability and fidelity; and flexibility and portability.

Key Technical Skills

• Collect, manage, analyze and visualize data.
• Develop, construct, test and maintain architectures (such as databases and large-scale processing systems)
• Ability to work with multiple data sources and databases.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (T-SQL, PL/SQL, etc.) as well as working familiarity with a variety of databases (SQL Server, Oracle, etc.)
• Functional and technical design of DW (star schema and snowflakes)
• Advanced working experience in data ingestion tools, such as ADF, SSIS, Informatica for ETL pipelines development.
• Advanced working experience in dimensional data modelling, data model optimization and model performance tuning.
• Build and verify new data models that aid decision-making.
• Practical experience with Visualization and Reporting tools such as Qlik, Tableau, Power BI and Excel (Power Pivot)
• Capable of collaborating with Team Leads in understanding and contributing to the technical solution from design through implementation level.

Leadership, Management and Other Skills

• Partner with Team Leads and Product Owners in understanding all data requirements.
• Proven ability to suggest and implement creative, innovative solutions which are aligned to the business requirements.
• Work with technical teams to build/improve data analytics and business intelligence techniques.
• Excellent spoken and written English skills, with ability to communicate clearly and concisely with QA, other developers and Team Lead
• Interpersonal skills to interact with team members.
• Follow defined methodology and standards including preparation and maintenance of documentation for all stages of an Analytics project execution.
• Strong analytical and problem-solving skills.
• Positive attitude with ability to see through to completion.

Technologies and Tools:

• Relational SQL and NoSQL databases, including some of the following: Azure Synapse/SQL DW and SQL Database, SQL Server and Oracle.
• Data pipeline and workflow management tools: Data Factory, Informatica Data Engineering, Databricks, etc.
• Core cloud services from at least one of the major providers in the market (Azure, AWS, Google)
• Data visualization tools, mainly Power BI.
• Agile Methodologies, such as SCRUM.
• Task tracking tools, such as TFS and JIRA.

Edarabia