- The Data Architect has primary administration responsibility for the logical and physical design of the data solutions and business information architecture.
- Creates physical models and participates in the modifications to it as the project moves through the design and development phases.
- Ensure all models are consistent with the enterprise data models, naming standards, etc.
- Review and update data conceptual, logical and physical models as needed (subject areas, entities, attributes, tables, constraints, etc)
- Support data integration teams and provide ETL- architectural advice to team
- Participate in design, source-to-target mapping, meta data creation, review, and testing phases of a data project/operation
- Work with ETL development team to communicate data designs, review data flow, and resolve data issues
- Provides business project support by ensuring project teams have the necessary information (documentation, policies, rules, etc) to create data solutions that align to corporate direction
- Facilitate meetings and work closely with business to gather and understand data requirements. Act as a data steward when needed
- Develop documentation and maintain as needed
- Develops and implements business intelligence tools or applications for accessing and analyzing data and meta data
- Integrate models and ensure data rules and definitions are consistent across various departments
- Anticipate and resolve data definition and integration issues for cross-functional groups
- Works with System Admin group to manage, monitor performance usage and administer the analytic server and Bl reporting tool
- Participate and/or lead in design sessions, demos and prototype sessions, testing and training workshops with business users and other IT associates
Required Experience:
7+ years of IT experience of hand-on DA experience on small to medium complexity
Data Architecture:
7+ years experience with Data Architecture, Data Warehousing and data governance.
7+ years experience with Data Modeling tools such as Erwin, ER Studio, or SAP PowerDesigner.
7+ years experience with relational databases (Oracle, MySQL, etc), highly proficient in SQL language, SQL performance tuning and DDL scripting.
Additional Experience:
Architect Business Intelligence solutions using technologies such as Tableau, QIik, Microsoft PowerBl, SAP Analytics, and Google Analytics is a plus
Strong understanding of ETL development pipeline using tools such as Informatica, SAP, IBM and API platforms
Experience with transactional data management platforms in the cloud such as Azure and AWS is a plus
Experience with Big data technologies such as Hadoop, Hive, Impala, etc is a plus
Required Education: Bachelor's Degrees