Data Architect
Company Name:
Open Systems Technologies
Summary
We are seeking a Data Architect for our Purchase, NY office. The data architect defines a business driven vision for data supported by policies, principles and guidelines that are aligned with data management and data governance. This person will lead all aspects of the design, development, and deployment of the Endurance data warehousing solution. The position will work within IT to help create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company?s operations. The Data Architect will participate in analyzing data, developing visualizations, and interacting with internal employees to deliver meaningful improvements to the data.
Essential Duties and
Responsibilities:
? Develops strategies for data acquisitions, archive recovery, and implementation of a database.
? Design and develop Databases, Data Warehouses and Multidimensional Databases
? Design the ETL processes to ensure the optimized flow of data within the organization along with error handling strategies.
? Develop and maintain a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata.
? Work directly with all application development teams to ensure that data is aligned between systems
? Create and implement the corporate data strategy including data security, data retention and data stewardship
? Work directly with the Data Governance team to ensure that data policies are aligned throughout the organization.
? Monitor and guide design of a semantically rich business model of the enterprise domain, independent of any technology solution
? Work closely with business analysts, end-users, all other IT groups on delivering common solutions and effectively utilizing existing skills and resources.
? Identify risks, communicate status to all stakeholders, manage scope and delivery
?
? Encourage and empower others to achieve, creating enthusiasm and a desire to excel
? Promote an environment of innovation and experimentation
? Lead organizational change and deliver business results by working across the organization and developing employees
? Coach, mentor, and develop team members.
? Maintain an environment that focuses on excellent customer service. Build and maintain relationships with business partners and work collaboratively with them to ensure a high level of satisfaction
Qualifications:
? 10 ? 15 years of BI/DW and data architecture experience.
? Familiarity with development methodologies including the AGILE development approaches
? 5 years P&C Insurance experience
? 5
years? experience in data warehousing
? 3
years? experience with MS SSIS
? Strong PL/SQL development experience with the ability to write and optimize complex and nested SQL queries
? Data warehouse modeling experience and strong schema design knowledge (Star, snowflake, multi-dimensional)
? Experience working in a software development environment
? Microsoft Sql Server 2008 and 2012
? Clear, logical, and effective verbal/written communication skills.
? Clearly demonstrated sense of urgency and bias for action.
? Ability to work well under pressure and independently.
? Ability to forge strong working relationships at senior levels.
? Ability to effectively negotiate with other teams to create a mutually beneficial solution
? Ability to effectively direct the work of others.
? Demonstrated ability to interpret technical material.
? Takes ownership of problems and develops sound solutions.
? Demonstrates sound analytical and diagnostic skills dealing with issues that are not readily defined and/or conflict with available information. Has the ability to reach sound decisions quickly.
? Able to fully research business situation, identify areas of concern and present solution.
? Have a solid working knowledge of capabilities and direction of technology, coupled with an in-depth knowledge of the technology required and the needs of the business environment necessary to support assigned projects.
? Skilled at identifying flat areas and providing feedback to employees for performance improvement
Estimated Salary: $20 to $28 per hour based on qualifications.
Open Systems Technologies
Summary
We are seeking a Data Architect for our Purchase, NY office. The data architect defines a business driven vision for data supported by policies, principles and guidelines that are aligned with data management and data governance. This person will lead all aspects of the design, development, and deployment of the Endurance data warehousing solution. The position will work within IT to help create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company?s operations. The Data Architect will participate in analyzing data, developing visualizations, and interacting with internal employees to deliver meaningful improvements to the data.
Essential Duties and
Responsibilities:
? Develops strategies for data acquisitions, archive recovery, and implementation of a database.
? Design and develop Databases, Data Warehouses and Multidimensional Databases
? Design the ETL processes to ensure the optimized flow of data within the organization along with error handling strategies.
? Develop and maintain a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata.
? Work directly with all application development teams to ensure that data is aligned between systems
? Create and implement the corporate data strategy including data security, data retention and data stewardship
? Work directly with the Data Governance team to ensure that data policies are aligned throughout the organization.
? Monitor and guide design of a semantically rich business model of the enterprise domain, independent of any technology solution
? Work closely with business analysts, end-users, all other IT groups on delivering common solutions and effectively utilizing existing skills and resources.
? Identify risks, communicate status to all stakeholders, manage scope and delivery
?
? Encourage and empower others to achieve, creating enthusiasm and a desire to excel
? Promote an environment of innovation and experimentation
? Lead organizational change and deliver business results by working across the organization and developing employees
? Coach, mentor, and develop team members.
? Maintain an environment that focuses on excellent customer service. Build and maintain relationships with business partners and work collaboratively with them to ensure a high level of satisfaction
Qualifications:
? 10 ? 15 years of BI/DW and data architecture experience.
? Familiarity with development methodologies including the AGILE development approaches
? 5 years P&C Insurance experience
? 5
years? experience in data warehousing
? 3
years? experience with MS SSIS
? Strong PL/SQL development experience with the ability to write and optimize complex and nested SQL queries
? Data warehouse modeling experience and strong schema design knowledge (Star, snowflake, multi-dimensional)
? Experience working in a software development environment
? Microsoft Sql Server 2008 and 2012
? Clear, logical, and effective verbal/written communication skills.
? Clearly demonstrated sense of urgency and bias for action.
? Ability to work well under pressure and independently.
? Ability to forge strong working relationships at senior levels.
? Ability to effectively negotiate with other teams to create a mutually beneficial solution
? Ability to effectively direct the work of others.
? Demonstrated ability to interpret technical material.
? Takes ownership of problems and develops sound solutions.
? Demonstrates sound analytical and diagnostic skills dealing with issues that are not readily defined and/or conflict with available information. Has the ability to reach sound decisions quickly.
? Able to fully research business situation, identify areas of concern and present solution.
? Have a solid working knowledge of capabilities and direction of technology, coupled with an in-depth knowledge of the technology required and the needs of the business environment necessary to support assigned projects.
? Skilled at identifying flat areas and providing feedback to employees for performance improvement
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
