Data Architect I (Enterprise Data Architect)

Job Title
Data Architect I (Enterprise Data Architect)

Opened:

05/06/2022

Closes:

Open Until Filled

Position Title:      

Data Architect I (Enterprise Data Architect)

Class/Group:

0317/B28

Military Occupation Specialty Code:

Army 25B, Navy 182X, 682X, Coast Guard ISM, Marine Corps 2659, 8846, Airforce 3D0X1, 3D0X4 

FLSA:     

Exempt

Number of Vacancies:

1

Division/Section:

Chief Technology Office / IT Services

Salary Range:

$6999.25 - $9583.33 per month

Duration:

Regular

Hours Worked Weekly:     

40

Shift:     

Days

Travel:   

None

Agency Address: 

300 W. 15th, Austin, Texas 78701

Web site:

https://dir.texas.gov/

Refer Inquiries to:              

Human Resources

Telephone:

(512) 475-4612 or (512) 463-5920

How to Apply:

  • You must create a CAPPS Career Section candidate profile or be logged in to apply
  • Update your profile and apply for the job by navigating through the pages and steps
  • Once ready, select “Submit” on the “Review and Submit” page

Special Instructions: 

  • Applicants must provide in-depth information in the EXPERIENCE & CREDENTIALS section to demonstrate how they meet the position qualifications. Incomplete applications may result in disqualification.
  • Resumes may be uploaded as an attachment but are not accepted in lieu of the information required in the EXPERIENCE & CREDENTIALS section of the application.

Interview Place/Time:

Candidates will be notified for appointments as determined by the selection committee.

Notice:

Section 651.005 of the Government Code requires males, ages 18 through 25 years, to provide proof of their Selective Service registration or proof of their exemption from the requirement as a condition of state employment.

Equal Opportunity Employer

The Department of Information Resources does not exclude anyone from consideration for recruitment, selection, appointment, training, promotion, retention, or any other personnel action, or deny any benefits or participation in programs or activities, which it sponsors on the grounds of race, color, national origin, sex, religion, age, or disability.  Please call 512-463-5920 to request reasonable accommodations.

The Opportunity

The Texas Department of Information Resources is the state agency charged with protecting the state’s data and critical technology infrastructure, managing a multi-million-dollar cooperative contracts program, and providing strategic technology leadership, solutions, and innovation to all levels of Texas government.  DIR is a fast-paced and collaborative environment with highly motivated and engaged employees dedicated to achieving the best value for the state.

Performs highly complex (senior-level) data analysis and architecture work. Work involves data modeling and data analytics. Implements and managing database systems and data warehouses. Designs strategies and setting standards for operations, programming, and security. This is an Enterprise Architecture position with a focus on data, but duties will be broad and spread across multiple disciplines. May supervise the work of others. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment. This position reports to the Division Director of Information Technology Services.

What We Do

The ideal candidate will have the ability to highlight their strengths in the following functions:

  • Collaborates with business and technical teams to determine standards and systems designs based on best practices while maintaining a security focus. Designs and documents essential IT processes and procedures. Leads, participates in, and tracks projects to ensure adherence to standards and design specifications.
  • Supports the organization’s business strategies and priorities by defining the data management strategy in collaboration with key business and technical stakeholders. Evaluates internal functions, business development strategies, and IT processes and suggests improvements. Creates business architecture models to reflect the organization's strategies and goals.
  • 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 and structures for new and existing data warehouse and data mart projects, supports data analytics and business intelligence systems, and maintains existing data models and data architectures.
  • Designs, implements, and supports a robust, sustainable, and scalable data warehouse architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources.
  • Identifies appropriate data sourcing and extraction processes and identifies and nominates sources as systems of record for data usage in various applications. Implements corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines; are consistent, appropriate for their intended use, and perform as required; and are secure from unauthorized access or update.
  • Develops governance, data warehouse guidelines, and a communication plan to enforce standards and conformity for creating data models; and assesses the impact of changes to technical and business metadata on enterprise applications.
  • Performs other duties as assigned.

Education

  • Graduation from an accredited four-year college or university with major coursework in computer information systems, computer science, management information systems, or a related field; or 
  • Additional work-related experience may be substituted for each year of formal education on a year-for-year basis. (High-school diploma or equivalent certificate required).

Experience & Training Required

  • Three (3) years of experience with full life cycle development, architecture, and implementation, of an enterprise data warehouse.
  • Experience with enterprise information management processes and methodologies, relational database management systems.
  • Experience in dimensional modeling and design for data warehouse development.
  • Experience designing Master Data Management solutions.
  • Experience with Extract, Transform, and Load (ETL) and Extract, Load, and Transform (ELT) development.
  • Experience with Relational Online Analytical Processing (ROLAP) and Multidimensional Online Analytical Processing (MOLAP) development.

Experience & Training Preferred

  • Experience with the Erwin Data modeling or similar tool.
  • Experience with cloud providers and technologies; Azure, AWS and/or Google
  • Experience with development following the Agile formal/structured methodology.
  • Experience in dimensional modeling and design following Kimball, Inmon, or DataVault methodologies to data warehouse development.
  • Experience with creating and implementing Data Governance solutions.

Knowledge, Skills & Abilities

  • Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and processes, including the technical architecture of enterprise information management processes and methodologies, relational database management systems, metadata management, business intelligence, and business analytics tools.
  • Knowledge of local, state, and federal laws and regulations relevant to data management and data governance.
  • Knowledge of the limitations and capabilities of computer systems.
  • Knowledge of technology across all network layer and computer platforms.
  • Knowledge of operational support of networks, operating systems, Internet technologies, databases, and security applications.
  • Knowledge of project management software and system development life cycle concepts.
  • Ability to apply analytical, trouble shooting, and problem-solving skills in data related projects.
  • Demonstrated ability to communicate effectively with all project stakeholders, including executive leadership, business subject area leaders, and project staff. 
  • Demonstrated ability to communicate effectively to individuals and groups; to make effective presentations in formal and informal settings.
  • Demonstrated ability to communicate effectively, both verbally and in writing, to a variety of audiences. Must be an articulate and persuasive leader, able to communicate concepts to a broad range of technical and non-technical staff.
  • Ability to make critical decisions in the best interest of the agency and its mission and goals, while following agency procedures.
  • Ability to effectively prioritize and manage multiple tasks and directional changes under short and firm deadlines.
  • Ability to understand, follow and convey brief oral and/or written instructions.
  • Ability to establish and maintain effective and cordial working relationships at all organizational levels, including agency management, direct supervisors, co-workers, internal and external customers.
  • Ability to exercise courtesy, tact, and diplomacy in all communications; including the ability to exercise discretion when handling confidential information.
  • Ability to communicate both verbally and in writing, in a clear and concise manner.
  • Ability to work independently and as part of a team, and to support and contribute to a cohesive team environment.
  • Ability to work with limited supervision and to schedule workload to meet requirements and deadlines of the position.
  • Ability to work under pressure and exacting schedules to complete assigned tasks.
  • Ability to comply with all agency policies and applicable laws.
  • Ability to comply with all applicable safety rules, regulations, and standards.

Computer Skills

  • Skilled in the use of a personal computer and applicable software to perform job duties (Microsoft Office, e.g., Word, Excel, Outlook, etc.)

Other Requirements

  • Regular and punctual attendance
  • Criminal background check

Work Environment

  • Frequent use of a personal computer, copiers, printers, and telephones
  • Frequent work under stress, as a team member, and in direct contact with others
  • Frequent standing, walking, sitting, listening, and talking
  • Occasional bending and stooping
  • Occasional lifting and climbing
  • Occasional overtime required

 

About File Formats

Some documents on this page are in the PDF format. Please download the Adobe Reader in order to view these documents.