Enterprise Data Architect
Will have direct responsibility for the design, organization and assessment of enterprise database structures, assuring that all enterprise database applications fit into a single documented enterprise data model that minimizes duplication of data and assures logical data access and provides accurate and consistent synchronized information across all data storage environment by design and implementation of appropriate data structures.
Responsible for ensuring the optimum design, quality, performance, integrity, and reliability of relational database applications through the application of data modeling principles, practices and software tools
Work is non-routine in that general policies or procedures must be adapted or applied and new methods devised to meet frequently changing or new situations
Will work independently with direction management to effectively implement assigned initiatives.
Will be in frequent personal contact with individuals outside the immediate work environment and execute difficult planning and/or scheduling activities to accomplish goals and objectives, which may include coordinating the work with business analysts, application developers and database administrators as projects progress through the development lifecycles.
Typical examples of work include:
Establishes the overall data management strategy, enterprise data architecture and software development methodology for data access.
Directs the design, development, review, documentation, and implementation of data models for enterprise-wide relational database applications with a special emphasis on assuring data integrity and access between major applications.
Plans for collection methods, data cleansing, and normalization of enterprise quantitative and qualitative data to support decision making and reporting
Assures the integrity of data, software, and applications.
Develops policies and procedures related to the development, maintenance, and support of On-Line Analytical Processing (OLAP) and data warehouse applications
Plans capacity and growth of new and ongoing systems
Serves as primary focal point for resolving data model design problems
Analyzes data model requirements from functional specifications
Coordinates data models, dictionaries and other database documentation across multiple enterprise applications.
Monitors and manages external access to enterprise decision support systems
Trains staff to support and utilize data access and decision support tools and techniques
Researches and analyzes new technological products supporting data modeling, data access and organization.
Education, Experience and Skills:
Bachelor’s degree in Computer Science, Management Information Systems or related field
5 years of progressively responsible technical experience in database systems design, modeling and deployment.
Strong working knowledge of project management, software management
In-depth technical knowledge of database architectures, computer aided software engineering and data modeling processes and tools, software development methodologies and quality assurance.
Specific experience with current platform specific database architectures and associated development tools is highly desired. Ability to communicate effectively in English both orally and in writing
Ability to exercise sound judgment in analyzing, appraising, evaluating and solving problems of a procedural, organizational, administrative and technical nature
Ability to exercise a high degree of initiative and resourcefulness in the development and completion of work projects
Ability to work in a team environment, share information proactively, and assist other team members
Ability to organize facts and findings, and to present such information in clear and logical form, orally, and through written media such as “white papers,” memoranda and summaries
Ability to research and understand new technologies.
Technology Platforms / Tools and Languages:
SQL Management Studio
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
OLAP Data Cube