Second Menu

Wednesday, January 27, 2016

Three Positions : Database Architect/Senior Data Modeler |TX |

Hello,

GREETINGS !!

This is Anupam from Apetan consulting,

Please find the below job description and send me your update resume matching to it along with Contact details, Current location, Visa and Availability ASAP.

 

POSITION: Database Architect/ Senior Data Modeler

ROLE TYPE: Contract 12+ Mon

LOCATION: Austin, TX

 

 

           

Looking for a Senior Data Modeler for Information Quest (IQ), the enterprise data warehouse team ,under the auspices of the Administrative Systems Modernization Program 2.0 ("ASMP 2.0").  ASMP 2.0 is a program comprised of several projects aimed at modernizing UTAUSTIN's administrative systems, business processes, data management, and technical architecture.  A key part of ASMP 2.0 is the Enterprise Resource Planning ("ERP") implementation of the Workday HCM/Payroll and Financials modules.

 

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.

 

Organizationally, the Worker will be part of the Information Quest team.

 

Minimum Requirements:

Years

Skills/Experience

8

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.

8

Experience with ERwin, Embarcadero, or comparable data modeling tools.

8

Experience working with relational databases (RDBMS) such as Oracle, SQL Server etc.

5

Experience architecting large scale data systems with increasing scope and responsibility. 

3

Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Microstrategy, Tableau, etc.

3

Professional working experience modeling data requirements based on complex business needs across multiple information domains.

3

Experience in skilled writing and maintaining complex SQL and PL/SQL scripts.

Strong

Verbal and written communication skills.

Strong

Analytical and problem solving skills with ability to clearly articulate solution alternatives.

Strong

Attention to detail, seasoned judgement and experience to anticipate business needs.

Strong

Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results.

Degree

Equivalent combination of relevant education and experience may be substituted as appropriate.

               

               Preferences:

Years

Skills/Experience

5

Experience architecting large scale data systems with increasing scope and responsibility and working with enterprise data warehouse projects.

5

Experience with data modeling in an Oracle environment.

5

Experience with business intelligence tools (data modeling and reporting/analysis tools) such as IBM Cognos, Business Objects, Microstrategy, Tableau etc.

5

Experience with resolving data anomalies and conducting data integration analysis.

5

Experience working with human resource, payroll and financial data.

3

Experience with data profiling techniques and tools.

3

Experience working in higher education.

3

Experience with ETL tools; especially IBM InfoSphere Information Server version 8.7 and higher.

 

 

Anupam Amita | Technical Recruiter | Apetan Consulting LLC

Tel 201-620-9700* 107 | Fax: 201-526-6869 | 72 Van

Reipen Avenue # 255 Jersey City, NJ 07306

anupam@apetan.com | www.apetan.com  

Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at remove@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.

 

--
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment