Database Architect/Informatica MDM Architect

$145,600 - $156,000/Yr

Dutech - Austin, TX

Full-time - Mid Level

Austin, TX

Merchant Wholesalers, Durable Goods

About the position

We are seeking a skilled Data Warehouse Architect to join our team in Austin, TX. The ideal candidate will be responsible for designing and implementing data warehouse solutions that support our business intelligence needs. This role requires a strong background in data modeling, SQL, and Java, as well as experience in database administration and architecture. The Data Warehouse Architect will work closely with various business groups and technology teams to analyze and evaluate business operations, applications, and programming to establish database and system requirements. In this position, you will coordinate and gather data model requirements, assist with the analysis, design, modification, and maintenance of database structures, models, and architectures. You will support data analytics and business intelligence systems, ensuring that new designs conform to established standards and guidelines. Additionally, you will recommend and develop standards, procedures, and guidelines for creating and maintaining data models and governed data, ensuring completeness and quality. The role also involves reviewing changes to logical and physical data modeling, preparing physical data models from logical data models, and supporting improved data quality by reducing data redundancy and fragmentation. You will assist in selecting data management tools and developing standards and procedures for their use to ensure the integrity of the database environment. Furthermore, you will perform root cause analyses related to information issues and non-conformance to published data standards, working under minimal supervision with considerable latitude for initiative and independent judgment.

Responsibilities

• Establishes database and system requirements by analyzing and evaluating business operations, applications, and programming.
• Coordinates and gathers data model requirements, assisting with the analysis, design, modification, and maintenance of database structures, models, and architectures.
• Supports data analytics and business intelligence systems, coordinating the implementation of database changes to support new and modified applications.
• 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.

Requirements

• 3 years of experience in database administration, data analysis, research, or architecture work in Oracle database.
• 3 years of proven experience with data security, master data management, metadata management, and support for creation of data dictionaries, data lineage flows, and other documentation.
• 3 years of experience identifying the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization.
• 3 years of experience defining and governing data modeling and design standards, tools, best practices, and related development for enterprise data models.
• 3 years of experience identifying and documenting data sources, risks, and data controls, with the ability to translate privacy and information security policies into operational procedures.
• 3 years of experience engaging with various business groups and technology to research, define, and document proper governance and stewardship practices.
• 3 years of experience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture.
• 3 years of design and implementation experience of Informatica MDM and its integration with hybrid cloud and on-prem environments.
• 2 years of enterprise data warehouse and storage design experience on both on-premise and cloud.
• 2 years of exposure to data classification, clustering, deduplication methodologies.
• 2 years of knowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence/analytics tools, frameworks, and infrastructure.
• 2 years of knowledge of database software and technologies, cloud technologies, and engineered systems and enterprise software products, including Microsoft Azure, AWS, and Oracle.
• 2 years of excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge.
• 2 years of skill in monitoring projects, and establishing measurement and tracking for project tasks.
• 2 years of ability to analyze, evaluate, and summarize data and information for accuracy and conformance to standards.
• 2 years of ability to document policies, procedures, and processes.
• 2 years of ability to exercise sound judgment, critical thinking, and analytical skills.
• 2 years of ability to establish and maintain effective working relationships at all levels of the organization.

Nice-to-haves

• Knowledge of the Texas Project Delivery Framework
• Strong working knowledge of the following DFPS systems/programs: IMPACT, PACES, ABCS, PEIRS, NEICE, e-Report, e-Travel, General Placement Search, and Community Based Care.

Benefits

• Competitive hourly pay of $70 - $75 per hour
• Full-time contract position
• Monday to Friday work schedule
• Opportunity to work in a dynamic team environment
• Potential for professional growth and development opportunities