Job DescriptionResponsibilities: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.
RequirementsExperience and Skill Set Requirements:Must Have:- Demonstratedexperience reviewing and analyzing business needs and requirements forexisting IT applications and related data and designing target data models.
- Strongexperience in research, data analysis and development of effective IT datamodel designs.
Skill Set Requirements:Core Skills and Experience (8+ years):- Demonstratedexperience reviewing and analyzing business needs and requirements forexisting IT applications and related data and designing target data models.
- Strongexperience in research, data analysis and development of effective IT datamodel designs.
- Workwith related IT initiatives as required to align with the enterprise datamodeling standards and requirements.
- Expertanalytical skills and experience to analyze and understand source datamodels and data including developing data mappings for source and targetsystems.
- ExcellentRDBMS knowledge including SQL skills for carrying out deep analysis and/orto confirm/validate data.
- Ableto work and effectively engage with a multi-functional (e.g. BusinessAnalysts, SME, Developers, Architects etc.) team to ensure IT deliverablesproduced are of high quality.
- Ableto understand the problem domain and target IT/business requirements andcommunicate data modeling outputs as required.
- Quicklearner with ability to adapt and work independently with little or nosupervision.
- Ableto carry out research from a variety of sources to ensure alignment withcurrent IT trends and best practices.
- Expertskills and experience with the use of data modeling tools.
- Abilityto engage and provide information sharing support to IT architects(Business, Information, Solution, and Technology) as may be required.
- Ensuresintegration with related corporate and client cluster policies andstandards, and incorporation of best practices in the industry.
- Knowledgeand experience in creating, developing and managing logical and physicaldata models.
Desirable Skills and Experience:- Experiencewith similar MECP applications covering environmental (inspections,compliance, enforcement) systems, and hazardous waste management systems
- Experiencewith Computer Aided Software Engineering (CASE) tools
- Experiencewith use of Python in aiding data processing activities.
- Knowledgeand understanding of Information Management principles, concepts,policies, and practices.
- Knowledgeof Parquet, Delta-Lake data formats.
- Knowledgeof Azure Data Lakehouses, Star schema, Snowflake.
