Data Architect

Data Architect
We’re seeking a Data Architect who is motivated by variety, is seeking a challenging environment for professional growth, and is interested in supporting large information technology projects for one of our clients in the northeast.
The Data Architect will design and manage the organization's data infrastructure, creating blueprints for how data is collected, stored, and integrated to meet business goals. They will work with data engineers, analysts, business leaders, and compliance teams to align data strategy with business objectives and ensure successful implementation.
Location: This position located in Newark, NJ. Ideal candidate must be local to the area and able to go into the office periodically when needed. If not local, they must be willing to travel as needed.
Responsibilities:

• Work with business SMEs to understand analytical and reporting requirements
• Translate business and reporting needs into conceptual, logical, and physical data models
• Define data standards, relationships, and data pipeline transformation requirements for data engineering implementation
• Design and implement and Redshift data models, including tables, views/materialized view to ensure optimal performance and scalability

• Bachelor's degree in related field with 8+ years of experience as a data engineer Additional years of experience may be considered in lieu of a degree.
• Experience in transformation business requirements into optimal data model. Ideally experience working with customer analytics.
• Expertise in dimensional modeling (Star and Snowflake schemas)
• Experience with AWS Redshift and performance optimization
• Knowledge of AWS Glue, Redshift, Step Functions for data architecture
• Familiar with AWS DataZone for data lineage and governance
• Self-driven and have demonstrated the ability to work independently with minimum guidance
• Demonstrated multitasking ability, problem solving skills and a consistent record of on time delivery and customer service
• Excellent organizational and communication skills

• Utilities experience
• AWS Certified Solutions Architect – Professional (or Associate)
• AWS Certified Data Engineer – Associate

Position Details:

• Pay Rate / Range: $55 - $65

This program requires US Citizenship

• Benefits (Regular, Full Time Employees):
  1. Medical, Dental, and Vision offerings
  2. Weekly Direct Deposit
  3. Paid Holidays and Personal Time Off
  4. 401(k) with match
  5. Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages
  6. Pre-Paid Legal and Employee Assistance Programs
  7. Northwest Federal Credit Union Membership
  8. BB&T @ Work Program