Data Architects

IBA InfoTech Inc.
Charlotte, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Charlotte, United States of America

Tech stack

Third Normal Form
Adobe InDesign
Amazon Web Services (AWS)
Azure
Databases
Data Architecture
ETL
Data Vault Modeling
Data Warehousing
IBM DB2
Database Models
IBM InfoSphere DataStage
IBM Cognos Business Intelligence
Microsoft Office PerformancePoint Servers
Microsoft SQL Server
MicroStrategy
Microsoft Business Intelligence
Online Analytical Processing
Oracle Applications
Performance Tuning
Software Tools
SAP NetWeaver Data Management
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
Tableau
Teradata
Netezza
Snowflake
Sap Business Objects
Information Technology
QlikView

Job description

  • Lead discussions with client leadership explaining architecture options and recommendations
  • Design sustainable and optimal database models to support the client's business requirements
  • Advise clients on database management, integration and BI tools
  • Assist in performance tuning of databases and code
  • Mentor development team members in design and development of complex ETL and BI implementations
  • Perform architectural assessments of the client's Enterprise Data Warehouse (EDW)
  • Work with the sales team to create and deliver client proposals and demonstrations
  • Present to client, industry and internal peer groups

Requirements

  • Successful background as an architect and/or technical lead on an Enterprise Data Warehouse or EIM team
  • Track record of successfully architecting small, medium and enterprise-scale solutions
  • Working knowledge and experience with Azure, AWS or GCP.
  • Knowledge of data warehouse principles and methodologies: Kimbal, Inmon, Data vault, etc.…
  • Knowledge and expertise of database modeling techniques: Star, Snowflake, 3NF, etc.…
  • Knowledge of best practices in the database, ETL and/or BI technologies
  • Experience with modeling tools like Power designer, ERWIN, etc.…
  • Experience working with relational or OLAP database: Oracle, SQL Server, DB2, Teradata, Netezza
  • Knowledge and experience with ETL tools: Informatica, MSBI (SSIS), DataStage, SAP Data Integrator
  • Knowledge and experience with BI reporting and visualization tools: Business Objects, MicroStrategy, Cognos, Tableau, QlikView, XLcubed, MSBI (SSAS, SSRS, Performance Point).
  • Eagerness to learn new tools and technologies
  • Experience building EIM or BI roadmaps to meet business needs
  • Strong communication skills.

Apply for this position