Data Architect
Job Description
Location: Richmond, VA
Position Type: Full-Time
Data Architect at Texplorers Inc will design, implement, and manage the data architecture. Key responsibilities include designing databases, developing data strategies, working with IT teams and data scientists to determine data needs, creating data models, ensuring data security, and maintaining data standards.
Key Responsibilities
- Create overall application and solution architectures, component designs, and systems integration and implementations for a particular business solution.
- Create data models and xml schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions. Models will include objects, entities, attributes, their inter-relationships and dependencies in 3N and/or dimensional formats.
- Integrate disparate data models into coherent enterprise data models.
- Create data dictionaries and business glossaries to document data lineages, data definitions, and metadata for all business-critical data domains
- Work to identify master data (entities and attributes) and capture how data is interpreted by users in various parts of the organization
- Lead efforts in defining, documenting and estimating the following for enterprise applications.
Capture requirements for data, workflow, logical processes, hardware and operating system environment, on- prem, hybrid and cloud topologies, interfaces with other systems, internal and external checks and controls, system inputs and output. - Collaborate with other IT staff to assess business needs and requirements and translate them into automated solutions
- Produce relevant solution design artifacts including but not limited to technical estimates, conceptual, logical and physical system designs, sequence diagrams, and data models
will coordinate new system development to ensure it is consistent and well integrated with existing application systems and COTS solutions - Analyze and estimate feasibility and compatibility with hardware and other programs; and will consult with clients to prototype, architect, and design applications to meet needs.
- Collaborate with Business areas and cross- functional Enterprise Architects to fully understand business needs and provide strategic consultation.
- Partner with architects, other technical team members and to develop roadmaps and strategies to support agency KPIs.
- Design/Implement Enterprise Security/technology Patterns.
- Consult with teams as needed on initiatives and provide tactical direction as well as provide architecture considerations on legacy solutions
Technical Experience
Minimum Degree Requirement:
Bachelor’s degree or equivalent in Computer Science or related field.
- Broad understanding of Data Architecture and Data Management approaches and implementation methodologies
- Ability to work with business as well as IT stakeholders
- Minimum of 5+ years of experience designing large scale data models for functional, operational and analytical environments
- Demonstrated experience in Conceptual, Logical, Physical and Dimensional Modeling
- Hands-on experience with data modeling tools
- Knowledge of BI tools, such as Power BI, Tableau
- Experience with Agile/Scrum is valuable
- Ability to work creatively and analytically in a team environment
- Excellent communication and documentation skills
- 5+ years of experience as Data Modeler/Data Architect creating data models and working in Data Architecture and Data Management solutions
