Data Architect - III

Ampcus Inc; Richmond; On-site; GBP 80,000 - 110,000; Full time

Job summary

A technology company in Richmond is seeking a Data Architect – III to oversee complex data design and database architecture. The role demands extensive experience in data analysis, troubleshooting, and database management. Candidates should possess a Bachelor's degree or higher in a relevant discipline and have at least 9 years of work experience, alongside strong knowledge in SQL and data warehouses. This position offers opportunities to implement new strategies and collaborate within an Agile team environment.

Qualifications

• 9 years of relevant work experience.
• Certification related to Information Technology preferred.
• Broad knowledge of programming, SQL queries, and data warehouses.

Responsibilities

• Responsible for complex data design and database architecture.
• Leads troubleshooting and product support related to database applications.
• Establishes integrity of complex data definitions and monitors data quality.

Skills

Programming

SQL queries

Data analysis

Project management

Education

Bachelor’s degree or higher in relevant discipline

Job description

Overview

Job Title: Data Architect – III.

Location: Richmond, VA.

Job Description

This ESO Cloud Data Architect role will be responsible for all aspects of business intelligence structure including analysis of requirements, design, troubleshooting, support and administration of schemas, data definitions, meta data, and architecture of all data analytic models, databases, and repositories used to create, retain, and analyze business intelligence data.

Responsibilities

• Responsible for complex data design, database architecture, metadata and repository creations, repository management, construction, and administration.
• Configure database parameters, allocate database resources, and review data loaded into databases for accuracy.
• Leads trouble shooting database applications, product support, analysis of data requirements, maintenance of application and processing architectures, and database schemas.
• Establishes integrity of complex data definitions and underlying data models, and monitors/audits overall data quality.
• Leads improvements to increase efficiency of infrastructure and automation processes.
• Produce complex data analytic models, ad-hoc queries, and reports for distribution to Audit and business management. Performs basic SQL queries for analysis of existing metrics and the development of new metrics.
• Leads software testing including code-level/unit testing, ETL processes, SQL or reporting tools, code-level unit testing, and script development of moderate complexity.
• Work and collaborate as a part of an Agile team to develop and implement capabilities to enable decision making processes and procedures including data, reporting, dashboards, metadata collection processes, metric collection processes, resolve data issues, data governance and data clean up and maintenance, data sharing agreement processes, etc.
• Develops conceptual, logical, and physical IT engineering designs that support the infrastructure requirements of varying levels of technical and business application projects.
• Completes analysis of business requirements, as it relates to technical infrastructure design, and ensures traceability of the design to the business requirements.

Qualifications

• 9 years of relevant work experience.
• Bachelor’s or higher degree relevant discipline.
• Certification related to Information Technology preferred.
• Broad knowledge of programming, SQL queries, data warehouses, relational databases, and quantitative/qualitative data analytic techniques.
• Broad familiarity with analyzing performance measures and metrics and developing balanced scorecards and dashboards.
• Excellent project management ability.
• Broad and deep familiarity with developing business strategies, fostering internal support for new ideas, independently collaborating across multiple organizations, and engaging senior leadership support to execute new strategies.

Equal Opportunity

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.