Consulting – Data Engineer Full Time

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.