Provides team leadership in the creation of high-level comprehensive data designs that address the needs of key stakeholders from the business, solution delivery and operations areas. Works with peers to conduct Data Architecture Reviews for a broad set of projects. Reviews and provides input into key aspects of the business case and work effort for a specific project. Reviews and provide input into functional & non-functional requirements. Provides consulting and conduct reviews through the development lifecycle. The Data Architect also performs gap analysis between planned data architecture functions and already established data architecture functions, particularly as previously handled by Application Structure and Integration Services.Researches data sources for new and better data feeds. Assists in continuous improvement efforts in enhancing performance and providing increased functionality.Oversees the supervision of personnel, which may include:work allocation, training, promotion and enforcement of internal procedures and controls and problem resolution; evaluates performance and makes recommendations for personnel actions; motivates employees to achieve peak productivity and performance. Performs miscellaneous job-related duties as assigned.
The job duties and responsibilities of this position include a variety of functions including: • Partner with clients to translate business needs and requirements into technical solutions • Perform analysis of designs and write moderate to complex design specifications • Develop and integrate software solutions for cross functional systems • Perform analysis of large complex enterprise-wide projects and provide direction and solutions • Develop, implement and maintain enterprise-wide applications • Analyze and identify testing issues for designs, implementations and deployments of applications
Five (5) years of experience directly related to the standard duties as outlined.
Strong knowledge of database design principals. Knowledge of data architecture concepts such as OLTP and OLAP systems, operational data stores, data warehouses, data marts, staging databases and data servicing layers; experience in designing these data architectures. Understanding of data modeling concepts such as use of conceptual, logical and physical data models. Demonstrated experience in relational database query tuning and indexing strategies. Experience with report development tools, Microsoft Business Intelligence Studio, Microsoft Reporting Services is desired. Knowledge of data integration strategies and technologies, such as hub and spoke messaging architectures. Familiarity with SQL Server replication and distributed database architecture. Systems analysis experience and capabilities.
Short- and long-term planning; problem analysis and resolution; report preparation and presentation; interpersonal and organizational communication, both oral and written.
Develop and maintain effective working relationships; maintain accurate and orderly records; use independent judgment and initiative; organize and direct activities.