BI Architect/Lead

company banner
Tentek, Inc.
BI architecture, Snow flake schema, Data warehouse, Agile, ERwin, Architecture, IBM InfoSphere DataStage, Teradata, ER/Studio, Security architecture, Data modeling, Data integration, MDM, Amazon Web Services, Cloud architecture, bi techno-functional background, teradata and erwin required, business objects/tableau, powerbi, agile/scrum, teradata or bi related or teradata master certs plus
Contract W2, 6 Months
$70 - $90
Work from home not available Travel not required

Job Description

BI Architect/Lead

This is a Techno-Functional role with skills around core BI Architecture with hands-on and a functional head to lead a team.

Background needed:

  • Experience in implementing consumer data warehouse or maintained w/ encrypted data and industry standard key rotation policy.
  • Experience in managing ETL and database backend teams and supporting front end users including data scientists with various tools like python, R and BI tools.
  • Able to construct and analyze both functional and business requirements and design solutions based on existing BI solution tool sets following Agile methods.
  • Highly skilled in profiling the data sources and conceptualizing and guiding technical team.
  • Familiarity with Big Data stack is desired and must have been involved in AWS Cloud Architecture and hands-on is a plus.
  • Highly skilled in driving enterprise standards for report design, development and deployment into BI Platform in compliance with Industry and SPE Security Architecture best practices.
  • Teradata and Erwin experience are a must.
  • Experience in any Master Data Management product, cloud and Big Data Technologies is an added skill set.
  • Experience in running BI projects in Agile Methodology is preferred.
  • Experience in BI Tools like Tableau and Alteryx is a plus along with Managing Resources and Projects.

Responsibilities include:
Interacting with Business Users/ Business Relationship Managers to understand the BI needs

  • Identify the right data sources / data completeness to meet the BI needs
    Data profiling to build the entity relationships across multiple sources
  • Build and Review conceptual and logical data models based on the BI needs
    Develop and maintain Business Glossary across the organization LOBs
  • Recommend Data Quality Management methodologies for various projects
  • Develop optimized database design to achieve acceptable performance by tuning views, tables and indexes for proper response time rollup to Teradata in depth skillset (see below)
    Provides consultation to ETL teams on the data load strategy
    Identify the right End User Reporting/Strategy solutions.
  • Maintain the data lineage for the data acquisitions and reporting done

    Key outputs include:
    Data entity relationship and models for new data sources
    Data integration solutions for syndicate data with internal data
    Reporting recommendations considering the analytical nature of the BI solutions
    Recommend best practices to manage Data Quality and Data integrity
    Contribution of documentation to IT knowledge database

10+ of years of IT work experience and 5+ years in the similar role of BI Data Modeler/Architect.

  • Any Teradata or BI related Certification is a plus.
  • Teradata Master Certification is a plus.
  • Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models)
  • Data modeling tools Erwin is a must and familiarity with ER studio, Visio and Embardigo
    Data Warehouse database platforms Teradata is a must and any experience with EDW platforms like Exadata, HP blade or Netezza or Greenplum is and added advantage.
    Experience with Business Objects/Tableau and any BI Reporting tools is required
  • Knowledge of BI tools like PowerBI is a plus and any familiarity with Tools that interact and interface with Big Data is a plus; such as Alteryx
    Knowledge and experience of any data profiling tool is required
    Familiar with any major ETL tools is required; DataStage / Informatica, Talend
  • Experience with any Data Quality Management full life cycle is an added advantage.
    In depth hands on experience with SQL programming skills
    Both Traditional RDBMS and Document Oriented databases
    Excellent Analytical skills
    Excellent communication skills with both business and technical customers

Posted By

Joe Elizondo

101 N. Brand Blvd., Suite 1660 Glendale, CA, 91203


Company Information

Providing quality resources and services to the Information Technology industry since 1989.
Dice Id : tentekgl
Position Id : JE14142
Originally Posted : 2 months ago

Similar Positions at Tentek, Inc.

BI/Data Analyst (Alteryx/Tableau)
  • West Hollywood, CA
  • 3 weeks ago