The Data Architect designs data flows, defines standards, ensures data quality, and collaborates on data strategies while integrating advanced technologies.
Data Engineer/ Data Architect
Data Architects define standards and design the flow of data throughout both the enterprise and the external ecosystem (customers, channels, etc.). They work closely with users, systems designers, and developers on a delivery team. They have an end-to-end vision, to see how a logical design will translate into one or more databases and recognize how data will flow through the successive stages involved. Data Architects address issues of data migration (including validation, clean-up, and mapping), and understand the importance of data dictionaries.
Required:
Data Architects define standards and design the flow of data throughout both the enterprise and the external ecosystem (customers, channels, etc.). They work closely with users, systems designers, and developers on a delivery team. They have an end-to-end vision, to see how a logical design will translate into one or more databases and recognize how data will flow through the successive stages involved. Data Architects address issues of data migration (including validation, clean-up, and mapping), and understand the importance of data dictionaries.
- 3–6-month CTH
- Hybrid- on site 2-3 days
- Acts as the subject matter expert in our business data domains or subject areas (i.e. Sales, Inventory, Promotions, etc.).
- Defines certified datasets for data consumption (i.e. Reporting, Data Science, APIs, etc.).
- Develops the enterprise data strategy and architectural standards for maintaining the performance, quality, data security, and compliance of certified data sets.
- Builds, optimizes, and maintains conceptual and logical database models and are responsible for partnering with the Data Platform teams for translating to the physical model.
- Develops integration documentation that records how data should flow from source systems to consumption layer (i.e. Source to Target Mappings).
- Supports Data Stewards in the Delivery Team(s) in capturing and documenting business metadata (i.e. definitions)
- Evaluates existing data architectures to improve data velocity.
- Brainstorms ideas with Database Developers, Data Engineers, Data Scientists and Platform Engineers to generate new data products.
- Stays current on data industry trends for data related technologies, architectures, and methodologies.
- Documents and provides recommendations resulting from data quality analysis.
- Participates in production delivery of operational business performance monitoring capabilities.
- Analyzes and translates business requirements into conceptual and fully detailed logical data models.
- Advises team on translating business needs into long-term architecture solutions.
- Develops and maintains reference architectures for data services.
- Works with data engineering and data platform teams to conduct ongoing performance enhancement by troubleshooting and introducing new technologies.
- Assists in defining data integration, storage, replication, and transformation protocols for the data layer of technical solutions supported by enterprise architecture.
- Regular and reliable workplace attendance at your assigned location.
- Ability to operate vehicles, equipment, or machinery.
- Computer, phone, printer, copier, fax
Required:
- Strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
- Experience architecting and delivering data integration and ETL solutions.
- Experience working with data modeling tools (Erwin data modeling tool).
- Experience working with Cloud database(s).
- 3+ years’ experience in data architecture with large and complex datasets.
- 3+ years’ experience working with Cloud technologies such as ADLS, Azure Databricks, Spark, Azure Synapse, Cosmos DB, and other big data technologies.
- Familiar with data modeling standards, guidelines, and tools. (ERWIN - Data modeling tool).
- Exposure to designing and developing performance-optimized data models.
- Experience in developing a big picture view of data needs of business and builds the architecture based on a strong technical foundation.
- Experience leading data architecture and data solutions through agile software development methodologies.
- Exposure to Membership and Marketing domains within our organization
- Exposure to Membership systems (MGLO, CRM, iSeries).
- Experience leading software development teams.
- Excellent verbal and written communication skills.
- Successful internal candidates will have spent one year or more on their current team.
Top Skills
Adls
Azure
Azure Databricks
Azure Synapse
Cosmos Db
Erwin
ETL
Spark
Similar Jobs
Artificial Intelligence • Cloud • Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
You will design and optimize cloud-based data pipelines in AWS, develop automation frameworks, and enhance data architecture for financial reporting and actuarial modeling.
Top Skills:
AWSDockerGlueLambdaPysparkPythonRedshiftS3SQLStep FunctionsTerraform
Analytics • Business Intelligence • Consulting
The role involves architecting and delivering data engineering and analytics solutions on Google Cloud Platform, leading projects, mentoring juniors, and managing SDLC cycles.
Top Skills:
App EngineBig TableBigQueryCloud ComposerCloud Data FusionCloud FilestoreCloud Source RepositoriesCloud StorageCompute EngineContainer RegistryData PipelinesDataflowDatalabDataprocDatastoreETLFirestoreGoogle Cloud PlatformMemorystorePersistent DiskVmware Engine
Artificial Intelligence • Information Technology • Machine Learning • Software • Virtual Reality • Analytics
Develop and implement a data management strategy, oversee data governance and architecture, ensure compliance, and manage vendor relationships to support organizational goals.
Top Skills:
AWSDenodo
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
