Data Architect

Primary Job Duties and Tasks

The activities this candidate will be tasked with include, but are not limited to the following:

• This position is to provide technical guidance and expertise in supporting the department
  
in developing, architecting, and maintaining Azure Synapse Analytics solution, Azure SQL
Database, Master Data Management (MDM), Azure Databricks, spark pool, and
monitoring of high-volume of complex data warehouse processes.

Specific Knowledge, Skills and Abilities (KSAs)

The submitted candidate must be able to apply common knowledge, skills, and abilities inthe following areas:

Minimum Required KSAs:

• 5+ years of experience in advanced database design and administration with AzurebSQL /SQL Server
• 5+ years of experience in DDL, DML T-SQL skills, advanced stored procedure writing skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process logging, and error handling
• 3+ years of experience with Data Warehouse solutions like Microsoft Synapse Analytics or Snowflake
• 3+ years of experience with MDM tools/ Architecture.
• 3+ years of analyzing and interpreting large datasets, including cleaning, transforming, and visualizing data.
• 3+ years of Experience with implementing MDM consumption patterns like Analytical,Operational, Real-time, and bulk consumption patterns
• 2+ years of experience in predictive models to drive decision-making and improve
• business outcomes.
• Familiarity with system catalog views, Azure Cloud, experience with Microsoft Synapsededicated SQL pools and pipelines
• Ability to provide excellent customer support, meticulous quality of work and work
• product

General Knowledge, Skills and Abilities

The submitted candidate(s) must be able to apply common knowledge, skills, and abilities in
the following areas:

1. Communication: Able to clearly convey information, in both written and verbal formats,to individuals or groups in a wide variety of settings (i.e., project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others.
2. Customer Service: Works well with clients and customers (i.e., business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.
3. Decision Making: Makes sound, well-informed, and objective decisions.
4. Flexibility: Is open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others.
5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
6. Leadership: Motivates, encourages, and challenges others. Is able to adapt leadership styles in a variety of situations.
7. Problem Solving: Able to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly.
8. Team Building: Encourages, inspires, and guides others toward accomplishing the common goal.

Education and Certifications

Education: Bachelors or Masters Degree in Computer Science, Information Systems, oranother related field. Or equivalent work experience. (Required)

Remote Work :

No