Data Architects

IBA InfoTech Inc.

Charlotte, NC, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

Third Normal Form Adobe InDesign Amazon Web Services Microsoft Azure Databases Data Architecture Extract Transform Load (ETL) Data Vault Modeling Data Warehousing IBM DB2 Database Models IBM InfoSphere DataStage

+20 more

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 (Software) Teradata SQL 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.