What are the responsibilities and job description for the Data Architect - III position at Ampcus, Inc?
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Data Architect - III. Location: Richmond, VA. Job Description:
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.
* 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 collaborates 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 ensure traceability of the design to the business requirements.
Qualifications and Skills: * 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 collaborates 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 ensure traceability of the design to the business requirements.
- Experience using core AWS services to build and support data solutions leveraging architecture best practices [S3, Glue, Lambda].
- Expertise in AWS Storage (S3, EBS), AWS Databases (Aurora Postgres), AWS Data Integration (Glue).
- Good understanding of AWS Identity and Access management, AWS Networking and AWS Monitoring tools.
- Proficiency in CI/CD and deployment automation using GITLAB pipeline.
- Proficiency in Cloud infrastructure provisioning tools e.g., Terraform.
- Strong technical skill in software engineering for Java EE /Cloud technologies and proficiency in Java Lambdas, Java Streams API, Java functional programming.
- Proficiency in one or more programming languages e.g., Python, Scala.
- Knowledge in Workday data tools including Adaptive & Prism desirable, but not required.
- Knowledge in Ariba desirable, but not required.
- 9 years of relevant work experience.
- Bachelor's or higher degree in a 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.
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.