Data Warehouse Developer/Architect
1 view
Skip to first unread message
irfan khan
Nov 1, 2010, 3:12:46 PM11/1/10
to
Dear Business pertner,
Hope you are doing good today,
Hope you are doing good today,
I have a requirement for a ASP.Net Developer
with my client in Austin, TX. Please let me know if you have anyone fit for the
below position,
Job Title: Data Warehouse
Developer/Architect
Location : Frankfort, Kentucky
Duration: Longterm Contract
Location : Frankfort, Kentucky
Duration: Longterm Contract
Job Description:
The Data Warehouse Architect's role is to design, maintain, and develop the P-20 Data Collaborative’s data warehouse. The individual will be responsible for effectively starting from scratch to create a new data warehouse which will be composed of data that has been extracted from other state agency databases incrementally and will be merged together into a separate P-20 data warehouse to create a longitudinal database for running reports and analyses. The individual must be experienced in all aspects of database development on the Microsoft SQL Server platform including the ability to design data models, create a database structure, and write stored procedures and other aspects of database development.
The Data Warehouse Architect's role is to design, maintain, and develop the P-20 Data Collaborative’s data warehouse. The individual will be responsible for effectively starting from scratch to create a new data warehouse which will be composed of data that has been extracted from other state agency databases incrementally and will be merged together into a separate P-20 data warehouse to create a longitudinal database for running reports and analyses. The individual must be experienced in all aspects of database development on the Microsoft SQL Server platform including the ability to design data models, create a database structure, and write stored procedures and other aspects of database development.
Responsibilities:
· Design, develop, and implement database solutions (creating tables, performance tuning, writing stored procedures) in a Microsoft SQL Server environment
· Design, develop, and implement data warehouse infrastructure including ETL processes, OLAP cubes, etc. with other agency staff
· Create the data warehouse database and optimize it for growth
· Perform data quality analyses and develop data cleansing strategies
· Develop ETL strategies for integrating data from additional sources into the warehouse
· Develop and evolve the logical and physical database design for our application
· Create data models and conceptual models
· Manage multiple database environments (production, QA, and development)
· Provide technical leadership to the team in all aspects of database design, structure, and usage
· Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
· Design, develop, and implement database solutions (creating tables, performance tuning, writing stored procedures) in a Microsoft SQL Server environment
· Design, develop, and implement data warehouse infrastructure including ETL processes, OLAP cubes, etc. with other agency staff
· Create the data warehouse database and optimize it for growth
· Perform data quality analyses and develop data cleansing strategies
· Develop ETL strategies for integrating data from additional sources into the warehouse
· Develop and evolve the logical and physical database design for our application
· Create data models and conceptual models
· Manage multiple database environments (production, QA, and development)
· Provide technical leadership to the team in all aspects of database design, structure, and usage
· Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
Qualifications:
· 5+ years experience working in database development - exposure to large, state level data systems and/or education data preferred
· Database-related software development on a windows platform on the Microsoft SQL Server environment
· Experience working with database security
· Solid experience working with developers to create database designs based on their features
· Hands-on experience with reporting, ETL, BI and dashboard tools
· Ability to manage tasks and work independently as well as part of a team and provide development estimates
· Must be an expert in SQL queries, stored procedures, reports, database design, security and performance tunin
· Must thoroughly document work so other developers can easily understand it
· Experience designing OLTP and DSS data models with at least 20 tables
· Experience combining records from different data sources together to create records of data about the same individual with elements derived from different sources. Prefer experience utilizing a variety of records matching processes including use of a clear identifier as well a methods for matching records in the absence of an identification number using other elements such as names, addresses, or demographic characteristics.
· Experience analyzing and documenting complex source systems
· Self-motivated with good organizational skills
· Demonstrate strong team skills and have good oral and written communication skills
· 5+ years experience working in database development - exposure to large, state level data systems and/or education data preferred
· Database-related software development on a windows platform on the Microsoft SQL Server environment
· Experience working with database security
· Solid experience working with developers to create database designs based on their features
· Hands-on experience with reporting, ETL, BI and dashboard tools
· Ability to manage tasks and work independently as well as part of a team and provide development estimates
· Must be an expert in SQL queries, stored procedures, reports, database design, security and performance tunin
· Must thoroughly document work so other developers can easily understand it
· Experience designing OLTP and DSS data models with at least 20 tables
· Experience combining records from different data sources together to create records of data about the same individual with elements derived from different sources. Prefer experience utilizing a variety of records matching processes including use of a clear identifier as well a methods for matching records in the absence of an identification number using other elements such as names, addresses, or demographic characteristics.
· Experience analyzing and documenting complex source systems
· Self-motivated with good organizational skills
· Demonstrate strong team skills and have good oral and written communication skills
*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/
Warm Regards,
Irfan Khan |
Warm Regards,
Irfan Khan |
Reply all
Reply to author
Forward
0 new messages