Data Warehouse Architect @ Amtex Systems Inc. | Jobright.ai
JOBSarrow
RecommendedLiked
0
Applied
0
External
0
Data Warehouse Architect jobs in United States
128 applicants
expire-info-iconThis job has closed.
company-logo

Amtex Systems Inc. · 1 week ago

Data Warehouse Architect

ftfMaximize your interview chances

Amtex Systems is a global company established in 1997, headquartered in New York. They are seeking a Data Warehouse Architect who will be responsible for designing and implementing data warehousing solutions using Azure technologies, ensuring optimal performance and security of database deployments.

CRMInformation Technology
check
Actively Hiring

Insider Connection @Amtex Systems Inc.

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Beyond your network

FFF
& 2 connections

From your previous company

FFF
& 2 connections
Previously@undefined and...

from your School

FFF
& 2 connections
@undefined and...

Responsibilities

5+ years proven experience working with Azure Databricks, Azure SQL, and other relational database technologies supported in Azure
Strong experience with relational and/or dimensional data modeling
Experience with Azure Data Factory, Azure Data Lake, Azure Data Explorer, Azure Event Hubs, Spark Pools, Dedicated/Serverless SQL Pools, PowerBI, Azure Landing Zones, Azure Networking Services, AAD/EntraID
Strong familiarity with NoSQL technologies such as Azure Cosmos DB is a plus
Experienced with Azure geo-redundancy, HA/failover, Datasync technologies
Experienced with log-shipping and database disaster recovery
Strong experience with performance tuning and optimization (PTO)
Strong expertise and experience with Azure DevOps tools in an Azure production setting.
Strong experience with Azure Data Studio, Visual Studio database management/projects/design capabilities, Azure CLI, and Powershell
Azure Database Administrator will need to have expertise in T-SQL and Stored Procedures.
Experience with SQL Server versions 2005 – 2022 is a plus
Experience running and troubleshooting SSIS packages
Experience with Oracle, either in Azure or on-prem, is a plus
Strong and current familiarity with Azure platforms and services, including Azure App Services, Azure API Management, Azure Monitor, Azure Application Insights, Azure SQL, etc.
Familiarity and hands-on experience with Infrastructure as Code (IaC) tools such as Terraform is a plus
Familiarity with programming languages such as Visual Studio, C# or Python and data constructs such as JSON or XML is strongly desired
Strong understanding of security best practices for Azure database deployments, including, access controls, IAM, data encryption (TDE), Azure key vaults and masking.
Awareness of FedRAMP, FISMA, and/or Zero Trust Architecture strongly desired.
Experience with CI/CD pipelines and deployment automation using tools like Azure DevOps
Experience with Agile methodologies
Excellent problem-solving skills and a proactive approach to identifying and resolving issues
Strong teamwork and communication skills, with the ability to collaborate effectively with cross-functional teams

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Azure DatabricksAzure SQLData modelingAzure Data FactoryAzure Data LakeAzure Data ExplorerAzure Event HubsPerformance tuningAzure DevOps toolsT-SQLSpark PoolsPowerBIAzure Networking ServicesAAD/EntraIDAzure geo-redundancyHA/failoverDatasync technologiesAzure Data StudioVisual StudioStored ProceduresAzure App ServicesAzure API ManagementAzure MonitorAzure Application InsightsSecurity best practicesCI/CD pipelinesAgile methodologiesNoSQL technologiesLog-shippingDatabase disaster recovery

Required

5+ years proven experience working with Azure Databricks, Azure SQL, and other relational database technologies supported in Azure
Strong experience with relational and/or dimensional data modeling
Experience with Azure Data Factory, Azure Data Lake, Azure Data Explorer, Azure Event Hubs, Spark Pools, Dedicated/Serverless SQL Pools, PowerBI, Azure Landing Zones, Azure Networking Services, AAD/EntraID
Experienced with Azure geo-redundancy, HA/failover, Datasync technologies
Experienced with log-shipping and database disaster recovery
Strong experience with performance tuning and optimization (PTO)
Strong expertise and experience with Azure DevOps tools in an Azure production setting
Strong experience with Azure Data Studio, Visual Studio database management/projects/design capabilities, Azure CLI, and Powershell
Azure Database Administrator will need to have expertise in T-SQL and Stored Procedures
Strong and current familiarity with Azure platforms and services, including Azure App Services, Azure API Management, Azure Monitor, Azure Application Insights, Azure SQL, etc.
Strong understanding of security best practices for Azure database deployments, including, access controls, IAM, data encryption (TDE), Azure key vaults and masking
Excellent problem-solving skills and a proactive approach to identifying and resolving issues
Strong teamwork and communication skills, with the ability to collaborate effectively with cross-functional teams

Preferred

Strong familiarity with NoSQL technologies such as Azure Cosmos DB
Experience with SQL Server versions 2005 – 2022
Experience running and troubleshooting SSIS packages
Experience with Oracle, either in Azure or on-prem
Familiarity and hands-on experience with Infrastructure as Code (IaC) tools such as Terraform
Familiarity with programming languages such as Visual Studio, C# or Python and data constructs such as JSON or XML
Awareness of FedRAMP, FISMA, and/or Zero Trust Architecture
Experience with CI/CD pipelines and deployment automation using tools like Azure DevOps
Experience with Agile methodologies

Company

Amtex Systems Inc.

company-logo
Amtex Systems was officially started in 1997 by Sunny Pokala with its headquarters in Wall Street, New York, and currently has offices across four continents.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Amritesh Upadhyay
Associate global talent acquisition (Working with Direct client and Implementation partners)
linkedin
leader-logo
Apoorv Jain
Client Partner
linkedin
Company data provided by crunchbase
This job has closed, but we ve got plenty more lined up for you. 
SIGN IN
logo

Orion

Your AI Copilot

Hi,