Data Architect - III

Artech Information System LLC; New Brunswick (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading IT staffing company in the United States seeks a skilled professional knowledgeable in AWS services including Redshift, RDS, and S3. Candidates must possess a business understanding of P&L accounting and hands-on experience in database design and SQL programming. This role entails understanding the current data landscape and creating detailed data inventories. Ideal candidates have experience in ETL/ELT workflows and metadata management, making this position crucial for leveraging data effectively.

Qualifications

• Knowledge of AWS services such as Redshift, RDS, and S3.
• Business understanding of P&L accounting, invoices, pricing.
• Hands-on experience with database design and SQL programming.
• Ability to map current data landscape to a detailed enterprise inventory.
• Ability to review data integrations/models for standards alignment.
• Translate business use cases into technical requirements for data testing.
• Experience in ETL/ELT workflow management.
• Experience with metadata management.

Responsibilities

• Create detailed enterprise data inventory and define data flows.
• Review data integrations/models for alignment to guidelines.

Skills

Knowledge of AWS ecosystem

Business understanding of P&L accounting

Hands-on experience with database design

Ability to understand current data landscape

Ability to review data integrations/models

Understanding business use cases

Experience in ETL/ELT workflow management

Experience with metadata management

Metadata management

Job description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Must Have Skills

• Knowledge of AWS ecosystem and services such as Redshift, RDS and S3
• Business understanding of P&L accounting, Invoices, Pricing is a must
• Hands‑on experience with database design and SQL programming under various platforms is a must
• Ability to understand current data landscape and create detailed enterprise data inventory and define data flows
• Understands and ability to review data integrations/models for alignment to guidelines, standards and practices
• Understand business use cases and creates Technical requirements which will directly enable the backend test strategy
• Experience in ETL/ELT workflow management
• Experience with metadata management

Nice to have skills

• Experience in understanding functional requirements and creating Technical requirements for ETL teams and backend test strategy
• Knowledge of SAP SD, FI-GL, COPA modules is preferred

Location-