ETL BI Analysts Needed Job in Bedford 76180, Texas Us

 ETL DATA MODELING DIMENSIONAL SPECIALIST  Bedford, TX

EXPERIENCE BUILDING FROM SCRATCH -DATA MODELING (DIMENSIONAL), REPORT DESIGN, AND ETL. Transitional is not the main need. We MUST HAVE DIMENSIONAL DATA MODELING. SEND RESUME TO RECRUITER@FWTCONSULTING.COM NO THIRD PARTY. MUST BE ABLE TO DO DIRECT HIRE WITH GREEN CARD OR CITIZENSHIP.

The primary objective for this position is to build support data stores that would enable COMPANY to take the reporting to the next level by providing self service capabilities to the business users. This also involves strong skills around ETL creations and working with Informatica cloud.

 

•      Understand business requirements and design data stores to support the reporting.

•      Design Create dimensional data models.

•      Develop cubes to enable self-service.

•      Ensure quality and integrity of data

•      Perform data transformations using ETL for data migration between Sources and warehouse.

•      Investigate issues during processing of data

•      Support production system by handling tickets from clients.

•      Follow standards during validation and processing of data

•      Assist mentor staff in the areas of data warehousing.

  

•      Should have at least 3 years of experience in understanding business requirements around reporting and designing a dimensional data store.

•      Should have at least 3 years of experience with dimensional data Modeling, relational data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, logical and physical data Modeling.

•      Strong enterprise ETL skills with experience on SSIS (Informatica Power Center is  a plus).

•      Should be able to bring in standards, processes best practices in the areas of ETL, data modeling, dimensional modeling and data warehousing.

•      Should have strong knowledge experience on SQL Server 2005/2008.

•      Ability to be a mentor to the team members in the area of data warehousing.

•      Analytical mind to help during the processing of data

•      Attention to detail

•      Written and verbal communication skills

•      Must be able to work with minimal supervision

•      Ability to interact with account executives and clients