Ayan Infotech urgently needs a Data Modeller with a Baseline security clearance for an initial 6-week remote contract.
The data modeller designs, implements, and documents data architecture and data modelling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.
Responsibilities will include:
- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualisation, analytics, and machine learning).
- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
- Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualisation.
- Hands-on modelling, design, configuration, installation, performance tuning, and sandbox POC.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
Required Skills & Experience
- Previous experience translating Business rules into Conceptual, Logical & Physical models for OLTP / OLAP / Graph / NoSQL databases.
- Minimum 3+ years' experience with Data Warehouse modelling techniques like Data Vault 2.0 and Dimensional (Star/Snowflake).
- Minimum 5+ years' experience with DBMS (MySQL, SQL Server, Postgres, Oracle, Teradata, Snowflake, DB2, Netezza).
- Minimum 3+ years' experience with cloud-based Data Warehouse and Data Lake environments.
- Software Development experience with SQL and preferably Python or JavaScript is required
- Experience in converting relational data models to semi-structured data (XML, JSON) or vice versa is required
- 5+ years' experience with modelling tools such as ERWin or ER/Studio or Power Design.
- Must be able to work independently and collaboratively on large scale data projects.
- Experience in Agile / Scrum projects advantageous.
- Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience
- Strong inter-personal skills and ability to work as part of a team
- Ability to utilize Business Intelligence tools (Power BI) to represent insights
- Experience working with dimensionally modelled data
- Experience in translating/mapping relational data models into XML and Schemas
This contract will provide the opportunity to work in a large-scale enterprise IT environment with a highly experienced and competent global IT delivery team. Our client invests millions of dollars in their IT environment, which will allow the contractor to work with the latest releases to what technology offers.
A competitive rate is on offer that is relevant to experience.
If interested, click the 'APPLY NOW' button or email your CV.
www.ayaninfotech.com
