Azure Data Architect

Azure Data Architect

Location: Princeton NJ / REMOTE ok but need to travel 1-2 in Quarter.

Duration: Long term

P&C Must

Responsibilities:

Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support databases, platforms, and analytical applications.

Maintains database by determining structural requirements adherence to regulations / mandates

Develop database solutions to store and retrieve company information

Install and configure information systems to ensure functionality

Analyze structural requirements for new software and applications

Migrate data from legacy systems to new solutions

Design conceptual and logical data models and flowcharts

Improve system performance by conducting tests, troubleshooting and integrating new elements

Optimize new and current database systems

Define security and backup procedures

Coordinate with the Data Science department to identify future needs and requirements

Provide operational support for Management Information Systems (MIS)

Assist in defining infrastructure for design and integration of analytical platforms / systems by analyzing requirements, studying business operations and user-interface requirements, and directing database development

Determines platform architecture, technology, and tools.

Skills:

Proven work experience as a Data Architect, Lead Data Analyst or similar role

Expertise in SQL and data visualization tools (Power BI , IBM Cognos)

In-depth understanding of database design principles

Knowledge of data mining and segmentation techniques

Knowledge of database modelling techniques like hierarchical, relational, entity-relationship, and dimensional

Good knowledge of Bill Inmon and Ralph Kimball methodologies

Hands-on knowledge of Azure

Proficiency in MS Excel

Proven analytical skills

Ability to improvise and find workarounds

Adaptability and curiosity with strong problem-solving attitude

Presentation and communication skills

Skills :