Job ID :
9549
Company :
State Of Michigan
Location :
LANSING, MI
Type :
Contract
Duration :
10+ Months
Salary :
Open
Status :
Active
Openings :
1
Posted :
09 Dec 2016
Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:  Seeking a full-time Data Architect with knowledge and experience designing, implementing, updating and monitoring databases with a geospatial component.

Complete Description:  Position will serve as Data Architect designing the data tier for systems with an emphasis on geospatial data.  Responsibilities include:

• Develop geospatial data models
• Meet with business owners and developers to understand data requirements and project needs
• Design, develop and manipulate databases
• Create scripts to promote data through development, test, and production environments
• Design and implement data views and triggers
• Develop, implement, and monitor data update processes
• Create and maintain central registry of metadata
• Document existing data workflows and update processes
• Manage data maintenance calendar for data updates
• Coordinate with DBA for database monitoring, event management, and incident response
• Troubleshoot database performance incidents
• Coordinate with Enterprise Geospatial Architect and DBA to integrate a variety of data sources into Enterprise Geospatial Data Warehouse
• Provide support for application development teams for the integration of geospatial data


Skill
Required / Desired
Amount
of Experience
Data Modeling
Required
4
Years
Microsoft SQL Server
Required
4
Years
Geospatial Data Structure
Required
2
Years
ESRI ArcSDE
Required
2
Years
SQL Server Profiler
Required
4
Years
SQL Server Integration Services
Required
4
Years
SQL Reporting Services
Desired
1
Years
ESRI Roads & Highways data Model
Desired
1
Years