RQ11485 - Data Architect/Modeller - Senior

Job summary

Develop and implement data architecture for complex distributed environments, including database location and data access methods. Collaborate with business stakeholders to analyze requirements and design logical data model specifications for target systems.

Job details

Responsibilities: Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods. Review data models for source MECP applications and databases, analyze and design/develop logical data model specifications for target systems. Collaborate with business to ensure coverage of data needs for target systems. Work with development supporting the development of technical artefacts. Requirements Experience and Skill Set Requirements: Must Have: Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data and designing target data models . Strong experience in research, data analysis and development of effective IT data model designs. Skill Set Requirements: Core Skills and Experience (8+ years): Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data and designing target data models . Strong experience in research, data analysis and development of effective IT data model designs. Work with related IT initiatives as required to align with the enterprise data modeling standards and requirements. Expert analytical skills and experience to analyze and understand source data models and data including developing data mappings for source and target systems. Excellent RDBMS knowledge including SQL skills for carrying out deep analysis and/or to confirm/validate data. Able to work and effectively engage with a multi-functional (e.g. Business Analysts, SME, Developers, Architects etc.) team to ensure IT deliverables produced are of high quality. Able to understand the problem domain and target IT/business requirements and communicate data modeling outputs as required. Quick learner with ability to adapt and work independently with little or no supervision. Able to carry out research from a variety of sources to ensure alignment with current IT trends and best practices. Expert skills and experience with the use of data modeling tools. Ability to engage and provide information sharing support to IT architects (Business, Information, Solution, and Technology) as may be required. Ensures integration with related corporate and client cluster policies and standards, and incorporation of best practices in the industry. Knowledge and experience in creating, developing and managing logical and physical data models. Desirable Skills and Experience: Experience with similar MECP applications covering environmental (inspections, compliance, enforcement) systems, and hazardous waste management systems Experience with Computer Aided Software Engineering (CASE) tools Experience with use of Python in aiding data processing activities. Knowledge and understanding of Information Management principles, concepts, policies, and practices. Knowledge of Parquet, Delta-Lake data formats. Knowledge of Azure Data Lakehouses, Star schema, Snowflake.

What you’ll do

Develop and implement data architecture for complex distributed environments, including database location and data access methods. Collaborate with business stakeholders to analyze requirements and design logical data model specifications for target systems.

Requirements

Requires over 8 years of experience in data modeling, research, and analysis within IT application environments. Candidates must possess expert SQL skills and proficiency in data modeling tools to ensure alignment with enterprise standards.

Listed skills

• SQL · Preferred
• Data analysis · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Architecture
• Data Modeling
• SQL
• RDBMS
• Data Analysis
• Logical Data Modeling
• Physical Data Modeling
• Data Mapping
• Azure Data Lakehouse
• Star Schema
• Snowflake
• Python
• Information Management
• Delta-Lake
• Parquet
• CASE Tools
• SQL (Programming Language)
• Business Requirements
• Snowflake (Data Warehouse)
• Analytical Skills
• Research
• Data Processing
• Python (Programming Language)
• Microsoft Azure
• Quick Learning
• Information Sharing
• Application Development
• Hazardous Waste Management
• Data Access
• Apache Parquet
• Relational Database Management Systems
• Computer-Aided Software Engineering

Job areas

• Data & Analytics
• Technology
• Software
• Government & Public Sector
• Consulting
• Data Modeler/Architect
• Data Architect
• Database Designers and Administrators
• Database Architects

More jobs from Maarut Inc