Sr ETL Datawarehouse Architect

Contract

Intratek

Apply Now

Job title: SR ETL Datawarehouse Architect

Intratek Computer, Inc., an Irvine, California based company, was founded and incorporated in 1989 as a computer service, support, and networking firm to provide state-of-the-art customized information technology solutions for Federal, State and County agencies, as well as leading private commercial accounts. We have comprehensive experience providing IT support services, including hardware and software support, maintenance and repair, programming, professional staffing, networking, web design and development, and helpdesk implementation and management.

 

Intratek Computer, Inc. is looking for a SR ETL Datawarehouse Architect to support us in Orange, CA. We offer great benefits and everyone has a stake in our success. Where else can you get medical insurance with no out of pocket cost? Here, with us!!

  • Work location will be hybrid to include remote and on-site as needed.
  • Pay Rate DOE, W2 per hour
  • Paid medical benefits
  • Paid vacation
  • Paid holidays
  • PTO
  • 401K

 

Overview:

Under general guidance, provides for the creation, maintenance, development, enhancement, and overall performance and function of the data warehouse and dashboard environment. Responsible for quality control and auditing of data marts. Develops data warehouse backup and recovery strategies. Provides technical assistance in trouble-shooting and debugging of data warehouse and dashboard related problems.

  • Translates business needs into long-term architecture solutions. Defines, designs, and builds complex dimensional databases. Evaluates reusability of current data dimensions for additional uses and analyses.
  • Develops data mappings, data extractions, data transformations that support the agency’s data warehouse environment. Confers with end users to ensure alignment between the data warehouse/dashboard environment and user needs.
  • Plans and oversees the technical transitions between development, testing, and production phases of data warehouse deployment. Facilitates change control and problem management among data warehouse development and support teams.
  • Expands and improves the data warehouse environment to include data from all function of the organization using data manipulation, transformations, and cleansing tools.
  • Sets design specifications for end-users semantic layers and multi-dimensional models across all Business Intelligence tools and environments to meet user needs.
  • Troubleshoots and tunes the existing data warehouse environment to maintain optimum performance. Conducts research to determine the viability of new data warehouse applications. Recommends changes in data warehouse software environment.
  • Coordinates the efforts of consultant development support to efficiently deliver data warehouse and dashboard solutions. Enforces processes to ensure a consistent, well designed, and integrated data warehouse and dashboard environment.
  • Oversees the design of the data and technical architecture for the data warehouse environment to ensure that the designs maintain an enterprise model.

 

Knowledge of:

  • Database design considerations that support the data warehouse deployed methodologies.
  • Data warehouse design method and techniques.
  • Informatica, Oracle, Sql Server, SQL, Unix, Vi editor, shell scripting and Toad.
  • Data modeling using ERWIN, data warehouse development, database structure and implementation techniques, table and index management, SQL tuning for Oracle.

 

Ability to:

  • Interface and resolve problems with various agency departments.
  • Reduce complex data issues to their respective data entities and design and develop data warehouse environments.

 

Education and Experience:

  • Any combination of education and experience equivalent to a bachelor’s degree in the area of information systems with a minimum of approximately five years increasingly complex analysis in programming or system administration, most of which are in warehouse development and support, three of which are at the journey level. Certified Business Intelligence Professional (CBIP) preferred.

 

Benefits:

Paid Medical, dental, vision, insurance

Paid vacations, sick, and holidays (after probation period)

401K

 

Equal Opportunity Employer:

Intratek Computer Inc. is an equal opportunity employer. “All qualified applicants will receive consideration for employment without regard to their race, religion, ancestry, national origin, sex, sexual orientation, age, disability, marital status, domestic partner status, or medical condition.”

 

Veterans Preference:

Special preference will be given returning war veterans when hiring new employees in an attempt to recognize their service, sacrifice, and skills.

 

Apply Now

Tagged as: Sr ETL Datawarehouse Architect