Database Architect

PSG Global Solutions; Austin (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT recruitment consultancy is seeking a data modeling expert to work on the IQ enterprise data warehouse in Austin, Texas. The role involves collaborating with ETL, BI, and DBA teams to develop data models and reporting structures while ensuring data quality and integrity. Candidates should possess strong SQL skills and experience with data modeling tools. This opportunity offers a dynamic environment to contribute to significant data initiatives.

Qualifications

• Experience with conceptual, logical and physical data model design.
• Experience designing tables and views for efficiency.
• Professional working experience modeling data requirements.
• Experience working with relational databases.
• Skilled in writing and maintaining complex SQL and PL/SQL scripts.

Responsibilities

• Work on the IQ enterprise data warehouse and modernization initiatives.
• Collaborate with the IQ team for data model creation and management.
• Identify and address data quality issues.
• Perform performance monitoring and query tuning.
• Document developed solutions for team continuity.

Skills

Data modeling

Metadata management

SQL

Analytical skills

Communication skills

Problem-solving

Attention to detail

Education

Relevant education or equivalent experience

Tools

ERwin

SQL Server

IBM Cognos

Tableau

Job description

Computer Futures is a leading IT recruitment consultancy, specialising in placing IT experts in permanent and contract roles across Asia, Europe and the US.

With a proven track record in IT recruitment, we enjoy success within all sectors and business types, placing a candidate every 38 minutes. From single job vacancies to large-scale projects, our proficiency in providing exceptional professionals across the board has carved our reputation as a secure and significant supplier partner.

A robust and financially strong business we have grown organically from our first office in London in 1986, to 18 offices in Europe; including Amsterdam, Brussels, Dublin, Edinburgh, Frankfurt, Hamburg, Munich and Paris as well as one office in San Francisco and Tokyo.

Gaining market share, year-on-year, we have the largest client base of any IT recruitment business across Europe. We work with a range of clients, from SMEs to large multi-nationals and high-profile names.

Passionate about recruitment, our 350+ specialist IT recruitment consultants’ priority is to secure the right person for the right role, within a specified timeframe and budget. Through Computer Futures’ methodology, our consultants – who focus on a specific IT technical market and geographical area - create a bespoke service to meet our individual clients’ recruitment needs.

Job Description

The Worker shall work on the IQ enterprise data warehouse and team as part of the Administrative Systems Modernization Program 2.0 and related initiatives. Work with IQ's ETL (extract/transform/load), BI (business intelligence), and DBA (data base administrator) teams to develop models and reporting structures to support current and projected reporting and data requirements.

The Worker will work collaboratively with the IQ team to create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Bill Inmon and/or Ralph Kimball. The Worker will work closely with database administrator(s) to establish and maintain highly resilient, scalable and high performance architecture when the data model is implemented physically on the target databases.

The Worker will identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. The Worker will take an organization-wide view of the business and its data, (e.g. maintain re-usable or enterprise data models) while providing detailed project-specific modeling and analysis support. Perform performance monitoring and query tuning as needed. Thoroughly document developed solutions and communicate knowledge to team to ensure continuity and maintainability.

Qualifications

• Experience with data modeling (conceptual, logical and physical data model design) and metadata management. Experience designing tables and views for efficiency, flexibility, maintainability and performance.
• Experience with ERwin, Embarcadero, or comparable data modeling tools.
• Experience working with relational databases (RDBMS) such as Oracle, SQL Server etc.
• Experience architecting large scale data systems with increasing scope and responsibility.
• Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Microstrategy, Tableau, etc.
• Professional working experience modeling data requirements based on complex business needs across multiple information domains.
• Experience in skilled writing and maintaining complex SQL and PL/SQL scripts.
• Verbal and written communication skills.
• Analytical and problem solving skills with ability to clearly articulate solution alternatives.
• Attention to detail, seasoned judgement and experience to anticipate business needs.
• Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results.
• Equivalent combination of relevant education and experience may be substituted as appropriate.

Additional Information

All your information will be kept confidential.