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's 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.