• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 6th Jan 2024

**This position is mostly remote, however candidates are required to be on site day one and as needed periodically for meetings. Local candidates given highest priority.**

OPERATIONAL REQUIREMENTS

The Architect is a senior level resource with advanced, specialized knowledge and experience in data warehousing, database, and programming concepts and technology. The selected contractor must have proven experience in the development, maintenance, testing, and maintenance of Azure production systems and projects. This position designs, develops, tests, and implements data lakes, databases, extract-load-transform programs, applications, and reports. This position will work with business analysts, application developers, DBAs, network, and system staff to achieve project objectives - delivery dates, cost objectives, quality objectives, and program area customer satisfaction objectives.

REQUIRED SKILLS: 
The Architect has the ability to design, develop, and implement data and ETL 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 the application technologies, environments, concepts, methodologies, practices, and procedures.

•    Candidate must have significant, hands-on technical experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python.
•    Significant, hands-on technical experience and expertise with leading the design, implementation and maintenance of business intelligence and data warehouse solutions, with expertise in using the SQL Server and Azure.
•    Producing ETL/ELT using SQL Server Integration Services and other tools.
•    Experience with SQL Server, T-SQL, scripts, queries.
•    Experience with data formatting, capture, search, retrieval, extraction, classification, and information filtering techniques. 
•    Experience with data mining architectures, modeling standards, reporting and data analysis methodologies. 
•    Experience with data engineering, database file systems optimization, API’s, 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.
•    Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision.
•    Ability to work and communicate collaboratively and effectively with colleagues, and as a member of a team.
•    Ability to present complex technical concepts and data to a varied audience effectively.
•    More than 12 years of relevant experience.
•    4-year college degree in computer science or related field with advanced study preferred. 

•    Experience working in the public health or healthcare industry with various health data sets.