86 applicants

Company

Original Job Post

Allied Consultants, Inc. · 2 days ago

Database Architect

Austin, Texas Metropolitan Area

Contract

Onsite

Senior Level

12+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

ConsultingEnterprise Resource Planning (ERP)

Growth Opportunities

Hiring Manager

John Bird

Insider Connection @Allied Consultants, Inc.

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Performs advanced (senior-level) data analysis and architecture work. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment. Employees at this level may be considered technical experts in the field and may:

Select data management tools and develop standards, usage guidelines, and procedures for those tools.

Identify appropriate data sourcing and extraction processes, and identify and nominate sources as systems of record for data usage in various applications.

Perform root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems

Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.

Obtains data model requirements, develops and implements data models for new projects, and maintains existing data models and data architectures.

Develops data structures for data warehouses and data mart projects and initiatives; and supports data analytics and business intelligence systems.

Implements corresponding database changes to support new and modified applications, and ensures that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.

Provides guidelines on creating data models and various standards relating to governed data.

Reviews changes to technical and business metadata, realizing their impacts on enterprise applications, and ensures that the impacts are communicated to appropriate parties.

Establishes measures to chart progress related to the completeness and quality of metadata for enterprise information; to support reduction of data redundancy and fragmentation and elimination of unnecessary movement of data; and to improve data quality.

Establishes database and system requirements by analyzing and evaluating business operations, applications, and programming.

Coordinates and gathers data model requirements, and assists with the analysis, design, modification, and maintenance of database structures, models and architectures.

Supports data analytics and business intelligence systems and coordinates the implementation of database changes to support new and modified applications, ensuring that new designs conform to standards and guidelines.

Recommends and develops standards, procedures, and guidelines on creating and maintaining data models and governed data, ensuring completeness and quality.

Reviews changes to logical and physical data modeling, metadata, relational database models, and prepares physical data models from logical data models.

Supports improved data quality by charting the reduction of data redundancy, fragmentation and elimination of unnecessary movement of data.

Assists in selecting data management tools and developing the standards, usage guidelines, and procedures for using those tools to ensure the integrity of the database environment.

Assists in performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.

Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Database administrationData analysisData architectureData modelingData governanceEnterprise data warehouse designData classificationCloud platformsInformation managementRelational databasesBusiness intelligenceProject monitoringDocumentationCommunicationProblem-solvingCritical thinkingRelationship building Project Delivery FrameworkIMPACTPACESABCSPEIRSNEICEE-ReportE-TravelGeneral Placement Search

Required

12 years experience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture

12 years experience in database administration, data analysis, research or architecture work in Oracle database

12 years of proven experience with data security, master data management, meta data management and support for creation of data dictionaries, data lineage flows and other documentation

12 years of identifying the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization

12 years of define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models

12 years experience with identifying and documenting data sources, risks and data controls and ability to translate privacy and information security policies into operational procedures

12 years of engaging with various business groups and technology to research, define and document proper governance and stewardship practices

8 years of Enterprise data warehouse and storage design experience on both on-premise and cloud platforms

8 years of exposure to data classification, clustering, deduplication methodologies

8 years knowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence/analytics tools, frameworks and infrastructure

8 years knowledge of database software and technologies, cloud technologies and engineered systems and enterprise software products, including Microsoft Azure AWS and Oracle

8 years of excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge

8 years of skilled in monitoring projects, and establishing measurement and tracking for project tasks

8 years ability to analyze, evaluate, and summarize data and information for accuracy and conformance to standards

8 years ability to document policies, procedures, and processes

8 years ability to exercise sound judgement, critical thinking and analytical skills

8 years ability to establish and maintain effective working relationships at all levels of the organization

Preferred

1 year knowledge of the Texas Project Delivery Framework

1 year of strong working knowledge of the following client's systems/programs (including but not limited to): IMPACT, PACES, ABCS, PEIRS, NEICE, e-Report, e-Travel, General Placement Search and Community Based Care