Azure Data Architect

At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Scope of work:

• The ideal candidate will be a hands-on developer on Azure Cloud Technology stack.
• The candidate is expected to understand the existing systems landscape in detail and design and develop an application on Azure cloud.
• The candidate should have very good knowledge of Azure cloud, to help leverage cloud-based architectures that will enable it to consolidate discrete data solutions into a secure cloud landscape that provides scalability, resiliency, and best-in-class data science toolkits/ services.
• The candidate will be well versed to identify the various technology components (front to back) needed to deliver a robust, secure, scalable and high availability solution.
• Candidate should help establish a data and reporting strategy that utilizes industry set of practices, tools and frameworks to consistently and efficiently deliver information to our clients, through this custom built application.
• The candidate will work closely with the business counterparts and IT teams, across geo-locations and to create the IT and functional architecture.
• The candidate will also make presentation (using PowerPoint, vision or any other tool) to various stakeholders and management on a need basis or as and when requested.
• Create various architecture blueprints and work with the development team to deliver the vision.

Skills/Experience Required:

• The ideal candidate will have good understanding of Azure cloud and reporting for application hosted on Azure cloud, using ADF and Azure SQL.
• Experience working with Azure Services like Azure Data Factory, Logic App, Functions, Azure SQL DB, Blob Storage, Azure DevOps.
• Experience working with other Azure Services like Azure Database Migration Service, ADLS Gen2, Synapse Analytics is an added advantage.
• Experience creating Azure Data Factory pipelines leveraging Data Movement activities, Data Transformation activities like Data Flow, Stored Procedure, Custom Activity, Azure Functions etc. and Control Flow Activities like web activity, lookup activity etc.
• Deploy, schedule and monitor pipelines using Azure Data Factory.
• Identify optimal data ingestion methods and develop batch processing solutions using Azure Data Factory.
• Design, Develop, Migration, Integration and configuring an Azure infrastructure.
• Determining workloads requirements for Azure cloud.
• Running workloads securely on Azure.
• Implementing Azure authentication and securing data on the cloud.
• Designing a business continuity strategy.
• Experience working with RDBMS preferably Azure SQL, Microsoft SQL Server.
• Proficient in SQL, Transact-SQL and experience in developing Stored procedures.
• Experience in any programming language, preferably C#, Python.
• Expert level knowledge and usage of Azure Web Apps, Application Insights and Azure Active Directory
• Must have expert level knowledge of Key Vault for application security for data in transit and rest.
• Implementing Azure authentication and securing data on the cloud using Key Vaults and Azure AD.
• Good knowledge of Agile, DevOps delivery methodologies.
• Interface with the business client to understand business needs and requirements, and to help develop and maintain the client relationship on a need basis.
• Interface with the various IT teams to ensure that the reporting application meets all the requirements of the stakeholders from multiple perspectives, including (but not limited to) Security, Redundancy, Storage, Performance, Mobile Readiness, etc.
• Build stakeholder consensus and ensure everyone is on the same page, in agreement, and can visualize the solution being proposed.
• The candidate should have Advanced understanding of data integration, data virtualization, data federation, and database design techniques.
• The candidate should have Advanced knowledge of dimensional modeling, modeling for reporting applications, normalization techniques, forward-engineering, and reverse-engineering techniques
• The candidate should have Knowledge of various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)
• Maintain a comprehensive chronological trail of solution footprint and agreements and actively contribute to the technology stream of the project change control process.
• Designing a business continuity strategy.
• Interface with the business client to understand business needs and requirements, and to help develop and maintain the client relationship on a need basis.
• Interface with the various IT teams to ensure that the application meets all requirements from multiple dimensions, including (but not limited to) Security, Redundancy, Storage, Performance, Mobile Readiness, Reporting etc.
• Build stakeholder consensus and ensure everyone is on the same page, in agreement, and can visualize the solution being proposed.
• Develop business cases, requirements, enterprise architecture blueprint, detailed blueprint and be the principle evangelize for the bespoke solution.
• The candidate should be able to identity various solutions for a problem and provide the recommendation for a solution, based on identifiable and measurable factors.
• Identify business and functional requirements by working with application end-users, and lead the collection, analysis, documentation, and coordination of those requirements.
• Maintain a comprehensive chronological trail of solution footprint and agreements and actively contribute to the technology stream of the project change control process.
• Provide overall support to ensure the successful Analysis, Design, Development and Deployment of a cloud solution. Also, provide support in developing training materials and conducting training from a technology platform perspective to various stakeholders.
• Document and manage issues and actions for the various IT components in the solution.
• Prepare and make presentations using MS PowerPoint and Visio to project stakeholders and management.
• Participate in the evaluation of new products or initiatives to determine the technology support required.
• Evaluate applications and IT environments, and analyze gaps between current and desired states.
• Propose recommendations based on industry best practices.
• Provide estimates of level of work effort and time for completion.
• Provide fully documented work, instruction, and training to peers, as required.
• Interact with the Enterprise Architecture and Enterprise Platform teams to ensure that solutions are built in adherence with the defined enterprise standards in collaboration with the IT team.

Skills/Abilities:

• The candidate should Preferably be a Microsoft Certified.
• Strong process analysis skills and ability to suggest improvements for efficiency and effectiveness of solutions based on industry best practices.
• Proven conceptual, analytical, and judgmental skills.
• Should have a positive attitude and Excellent verbal and written communication skills and ability to communicate well with all stakeholders at all levels, technical as well as non-technical stakeholders.
• Ability to work directly with clients and management without supervision and to facilitate and navigate discussions with stakeholders to ensure clarity, prioritization, and consensus.
• Leadership skills and ability to work well with diverse team members, often in multiple locations.
• Ability to work with different points-of-view and lead the team to convergence, while always keeping the project objectives in sight.
• Strong presentation and facilitation skills.
• Excellent personal organization and ability to take things to closure without follow-ups.

Desired Skills/Abilities:(Not Mandatory, but a Plus)

• Experience of having worked in an Enterprise Data Wearhouse project.
• Understanding of Data Governance process and ability to identify data quality issues.
• Knowledge of project management.