NCDPI - Technical Architect- Senior

Typical Experience: 6084 months

***This is an onsite position.

Job Title:Data Engineer Azure Platform

Overview:

We are looking for an experienced Data Engineer tojoin our team. You will use various methods to import raw data into AzureCloud. You will analyze data and create rules for the ETL process. The importprocess will also include identifying the business rules and apply them to thefiles stored in staging area before moving the files to processed area.

The ideal candidate will have a strong background indata engineering along with expertise in cloud computing. This role offers anexciting opportunity to play a key role in modernizing our technology stack anddriving our organizations digital transformation journey.

Responsibilities:

Collaborate with crossfunctional business teams tounderstand requirements analyze and organize raw data import by identifyingthe ETL rules.

Identify and apply transformation rules for legacydata migration from mainframe systems to the Azure cloud platform.

Develop and implement data pipelines ETL processesand data integration solutions to facilitate the conversion of data.

Develop and maintain documentation best practicesand standards for data engineering processes and procedures.

Provide technical leadership and mentorship to teammembers guiding them in best practices for data engineering and cloudmigration projects.

Explore ways to enhance data quality and reliability.

Requirements and Skills

1. **DataModeling and Database Design:**

Proficiency in designing and implementing relational and nonrelationaldatabases.

Knowledge of data modeling techniques and tools.

2.**Azure Data Services:**

Deep understanding and handson experience with Azure data servicessuch as Azure SQL Database Azure Cosmos DB Azure Data Lake Storage AzureBlob Storage etc.

3. **ETL(Extract Transform Load) Processes:**

Expertise in designing and implementing ETL processes using tools likeAzure Data Factory or Azure Databricks.

Knowledge of data integration and transformation techniques.

4. **SQLand TSQL:**

Proficient in writing complex SQL queries and stored procedures.

Familiarity with TransactSQL (TSQL) for managing and querying SQLServer databases.

5. **DataSecurity and Compliance:**

Knowledge of data security best practices and experience implementingsecurity measures for data storage and processing on Azure.

Awareness of compliance requirements and ability to implement solutionsthat adhere to NC DPI and DIT regulations.

6. **DataMonitoring and Optimization:**

Ability to set up monitoring and logging for data pipelines anddatabases.

Skills in optimizing data storage and processing for performance andcosteffectiveness.

7.**Scripting and Automation:**

Proficiency in scripting languages like Python or PowerShell forautomating data engineering tasks.

Knowledge of Azure Resource Manager (ARM) templates for infrastructureas code.

Additionally obtaining relevant certifications such as theMicrosoft Certified: Azure Data Engineer Associate can further validate andenhance these skills.

Qualifications:

Bachelor s degree in computer science Engineering ora related field

Proven experience as a data engineer with a strongfocus on data migration ETL and data integration.

Handson experience with data warehousing conceptsdatabase technologies (SQL on Azure)

Strong problemsolving skills attention to detailand the ability to work effectively in a fastpaced environment.

Excellent communication and interpersonal skills withthe ability to collaborate effectively with crossfunctional teams andstakeholders.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceProficiency in designing and implementing relational and nonrelational databases.Required5YearsKnowledge of data modeling techniques and tools.Required5YearsHandson experience with Azure data services such as Azure SQL Database Azure Cosmos DB Azure Data Lake Storage Azure Blob Storage etc.Required5YearsExpertise in designing and implementing ETL processes using tools like Azure Data Factory or Azure Databricks.Required5YearsKnowledge of data integration and transformation techniques.Required5YearsProficient in writing complex SQL queries and stored proceduresRequired5YearsKnowledge of data security best practices and experience implementing security measures for data storage and processing on Azure.Required5YearsAbility to set up monitoring and logging for data pipelines and databases.Required5YearsSkills in optimizing data storage and processing for performance and costeffectivenessRequired5YearsProficiency in scripting languages like Python or PowerShell for automating data engineering tasksRequired5YearsKnowledge of Azure Resource Manager (ARM) templates for infrastructure as codeRequired5Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2All work must be completed onsite. Do you accept this requirementQuestion3Candidate must be able to attend an inperson interview. Do you accept this requirementQuestion4Please list candidate s email address. Question5Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.Question6Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirementQuestion7Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirementQuestion8Candidates submitted above the rate of $$$ will not be considered. Do you accept this requirement Question9Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirementQuestion10Please confirm you have thoroughly validated and attest to the accuracy of the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS009440. Do you confirm