Data Architect

OP Consulting Group LLC

Saint Paul, United States

10 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Testing (Software) Query Performance Data Analysis Microsoft Azure Cloud Computing Data Architecture Data Security Data Transformation Services Data Warehousing Digital Assets Disaster Recovery Network Security

+18 more

SQL Azure Oracle Databases Windows PowerShell Role-Based Access Control SQL Databases Systems Integration Teradata SQL Backup and Restore Azure Data Factory Cloud Monitoring Database Optimization Azure Powershell Data Lakes Data Analytics Non-relational Database Data Management Azure Resource Manager Databricks

Job description

Support design and implementation to improve, modernize, and transform data-driven service delivery.
Ensure data assets are structured, accessible, secure, and align with Client, MNIT, and Enterprise goals.
Recommend data platforms and tools to support enterprise data architecture.
Develop data models.
Ensure data access patterns are optimized.
Maintain necessary documentation.
Coordinate with necessary teams to meet security standards.
Support design and development of disaster recovery solutions.
Provide knowledge transfer.

Requirements

Strong experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
Strong experience with Databricks.
Strong experience with Oracle databases.
Experience developing and implementing data transformation solutions and cloud infrastructure integrations.
Experience coding and testing programs and scripts to load data using Azure data load utilities.
Experience with CI/CD pipelines.
Experience with cloud computing concepts.
Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, Pearl, and Azure CLI/PowerShell for infrastructure management.
Experience in mentoring others in the needed technologies.
Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
Experience with role-based access control, encryption, and network security.
Strong organizational and time management skills.
Desired 10 years’’ experience in data architecture or data management.
Knowledge of data concepts, data modeling, schema design, and indexing strategies.
Knowledge of Azure SQL instances, managed instances, and elastic pools.
Knowledge of Data Warehouse Administration and Teradata Data Warehouse.
Work Environment The work is expected to be done remotely or hybrid at Client’’s offices.