What Data Architects Do
- 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
What We Look For
- 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.