Senior Azure Data Warehouse Architect at Pantude Infratech Pvt Ltd
Harrisburg, Pennsylvania, USA -
Full Time


Start Date

Immediate

Expiry Date

29 Nov, 25

Salary

60.0

Posted On

30 Aug, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Python, Etl, Analytics, Sql Server, Apache Spark, Sql Server Integration Services, Design, Pipelines, Data Engineering, Computer Science, Azure, Maintenance

Industry

Information Technology/IT

Description

The Architect can design, develop, and implement data and ELT application infrastructure in Azure to provide reliable and scalable applications and systems to meet the organization’s objectives and requirements. The Architect is familiar with a variety of application and database technologies, environments, concepts, methodologies, practices, and procedures
The candidate must have significant, hands-on technical experience and expertise with Azure, Azure Delta Lake, Azure Databricks, Azure Data Factory, Pipelines, Apache Spark, and Python.
· Significant, hands-on technical experience and expertise with the design, implementation and maintenance of business intelligence and data warehouse solutions, with expertise in using SQL Server and Azure Synapse.
· Experience producing ETL/ELT using SQL Server Integration Services and other tools.
· Experience with SQL Server, T-SQL, scripts, queries.
· Experience as an Azure DevOps CI/CD Pipeline Release Manager who can design, implement, and maintain robust and scalable CI/CD pipelines, automate the build, test, and deployment processes for various applications and services, troubleshoot and resolve pipeline issues and bottlenecks, and has experience with Monorepo-based CI/CD pipelines
· Experience with data formatting, capture, search, retrieval, extraction, classification, quality control, cleansing, and information filtering techniques.
· Experience with data mining architecture, modeling standards, reporting and data analysis methodologies.
· Experience with data engineering, database file systems optimization, APIs, and analytics as a service.
· Analyzing and translating business requirements and use cases into optimized designs and developing sound solutions.
· Advanced knowledge of relational databases, dimensional databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology.
· Creates and maintains technical documentation, diagrams, flowcharts, instructions, manuals, test plans, and test cases. Follows established SDLC best practices, documents code and participates in peer code reviews.
· Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision.
· Demonstrated ability to communicate and document clearly and concisely
· Ability to work collaboratively and effectively with colleagues as a member of a team.
· Ability to present complex technical concepts and data to a varied audience effectively.
· More than 5 years of relevant experience.
· 4-year college degree in computer science or related field with advanced study preferred.

OF EXPERIENCE

Technical experience and expertise with Azure, Azure Delta Lake, Azure Databricks, Azure Data Factory, Pipelines, Apache Spark, and Python.
Required
5
Years
Design, implementation, and maintenance of business intelligence and data warehouse solutions, with expertise in using SQL ServerAzure Synapse
Required
5
Years
Experience producing ETL/ELT using SQL Server Integration Services and other tools.
Required
5
Years
Experience with SQL Server, T-SQL, scripts, queries
Required
5
Years
Experience as an Azure DevOps CI/CD Pipeline Release Manager who can design, implement, and maintain robust and scalable CI/CD pipelines
Required
5
Years
Experience with data formatting, capture, search, retrieval, extraction, classification, quality control, cleansing, and information filtering
Required
5
Years
Experience with data engineering, database file systems optimization, APIs, and analytics as a service
Required
5
Years
Experience with data mining architecture, modeling standards, reporting and data analysis methodologies
Required
5
Years
4-year college degree in computer science or related field with advanced study preferred.
Required
Job Types: Full-time, Contract
Pay: $50.00 - $60.00 per hour
Expected hours: 37.5 per week

Application Question(s):

  • Email Address -

Education:

  • Bachelor’s (Preferred)

Experience:

  • Azure, Azure Delta Lake, Azure Databricks, Azure Data : 5 years (Preferred)
  • business intelligence and data warehouse solutions: 5 years (Preferred)
  • ETL/ELT using SQL Server Integration Services: 5 years (Preferred)
  • SQL Server, T-SQL, scripts, queries: 5 years (Preferred)
  • Azure DevOps CI/CD Pipeline Release Manager : 5 years (Preferred)
  • data formatting, capture, search, retrieval, extraction: 5 years (Preferred)
  • data mining architecture, modeling standards, reporting : 5 years (Preferred)

Work Location: On the roa

Responsibilities

Please refer the Job description for details

Loading...