Database Management / Architecture (competent):
Maintains awareness of modelling techniques covering full range of analysis
situations in the context of business analysis.
Selects appropriate modelling techniques for meeting assigned objectives,
and models current and desired future scenarios as directed.
Works with clients/users and development groups to identify most appropriate
and effective use of DB facilities and set strategy and standards for whole
application areas.
Data Management (competent)
Leads the quality assurance of corporate data structures, and project
developed data structures and associated components (e.g. Entity
descriptions, Relationship descriptions, Attribute definitions).
Works with data management colleagues to ensure that modelling is carried
out consistently, and that corporate standards for repository administration
and data dictionaries are observed.
Contributes to the setting of standards for database objects (e.g. naming
conventions) and ensures conformance to these standards.
Application Maintenance & Delivery (competent)
Within a project environment, assists in the investigation of application
data and process requirements, documenting them according to the required
standards utilising the prescribed methods and tools.
Programming & Application Development (competent)
Interprets design architecture to meet specification e.g. assistive
technology, parallel processing.
Takes responsibility for the design, coding, testing and documentation of
particularly large, complex or mission critical programs.
Analysis (competent)
Analyses requirements for fitness for purpose as well as adherence to
business objectives and consistency, challenging positively as appropriate.
Communication lines
Scrum Team, Business Owner, Scrum Master
Architecture Team
IT Experts and Teams
Support Teams (Platform, Operations)
Business SMEs, Stakeholders
Qualifications:
Minimum University / College degree in preferably IT domain, or
Business/Economics
4-5+ years of relevant work experience in data engineering and/or business
intelligence
Experience/Requirements:
Solid expertise in many areas of data engineering, including: data
modelling, ETL design and development, data and metadata managements., query
design/development/tuning, database optimization, data governance, data
quality, best practices
Understanding of databases and data technologies including: traditional
RDMBS, noSQL, data stream solutions
Strong understanding of cloud (AWS) platforms and design patterns
Regularly makes commitments and consistently meeting targets
The role requires to have eagerness and ability to learn and adapt
technologies, industry practices, tools, and trends
Solid experience with Python/SQL and Redshift or Postgres
Experience processing JSON, Avro JSON and other file formats
Nice to have: Experience with BI tools: Tableau, PowerBI, Airflow or other
ETL tool