Data Engineer/Data Architect

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.

• 3–6-month CTH
• Hybrid - on site 2-3 days

Job Description:

• 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 is 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).

Experience & Certifications:

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).

Recommended:

• 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.