Experience:
No experience
Employment Type:
Full time
Posted:
2/2/2018
Job Category:
Software Development
Data Architect
(This job is no longer available)
Alans Group LLC | Chicago, IL
loading
loading
School
Major
Grad Date
 
 

Not sure what types of jobs you are interested in?


Explore Jobs
Based on Your Education

Follow This Company
Share

Job Description

Location: Chicago, IL

Duration: Long-term Contact or Full-Time

Nature of work:

Ongoing Adhoc database changes to help Integration developers

Implement new changes in the tables or views

Keep Data Models updated

PowerShell Scripts if necessary to keep Azure costs low, automate some DB maintenance tasks

Monitoring Azure DB usage

Work closely with Integration developers and help with tuning & monitoring table loads

Implement Delta processing logic

Implement automated deployment methods

Requirements:

Datamodelling concepts, best practices & patterns

Azure SQL DW

Azure SQL DB

Azure Data Factory functionality & usage to assist with creating workflows and schedules

Familiarity reading and writing to NoSQL databases

Be able to assist with data modelling to suit data integration stream of work and also in area of Azure Analysis Services cubes

Azure Performance tuning

Azure databases deployment methods

Database CI/CD

Powershell Scripting for DB activities within Azure

Azure AD and how to apply that to the DW

Data Migration experience from on-premise and cloud

Specific to Azure SQL DW:

Data distribution methods

Indexing Methods (Column Store, Heap etc)

Data Loading Options

Concept of Polybase to load data and export data, right use cases to apply this

Best Practices pertaining to cost reduction mechanisms, scaling, maintaining statistics etc..

Recommendation on what method to use for delta processing within a Azure SQL DW

Qualifications

Applicants must be eligible to work in the specified location