Data Architect

4 weeks ago


Alpharetta, United States MerchantE Full time

Job Summary: The Data Architect or Lead Data Engineer will be instrumental in developing the company's Data Lakehouse. This position is responsible for the design, architecture, development, and implementation of a comprehensive Data Lakehouse strategy including dimensional modeling at the enterprise level. The ideal candidate will lead the creation and governance of an advanced data integration framework, incorporating data modeling, dimensional modeling, and seamless integration of ETL/ELT processes across various platforms.

This role requires expertise in modern Data Lakehouse technologies, including AWS services like AWS Athena, AWS Redshift, AWS Glue, and AWS S3. The candidate should also have experience with Apache Spark and Apache Iceberg for building scalable, cloud-based data solutions. The focus will be on establishing a unified Data Lakehouse to support business intelligence, analytics, and data-driven decision-making across the organization.

The ideal candidate will bring a strong hands-on development background, substantial experience in data architecture and engineering, and a deep understanding of cloud-based data ecosystems to drive the company’s data initiatives forward.


US WORK AUTHORIZATION REQUIRED - No visa sponsorship is available for this position at this time.


Essential Duties and Responsibilities:

  • Design and implement integration solutions using AWS technologies, including AWS Athena, AWS Redshift, AWS Glue, AWS Data Pipeline, AWS QuickSight, and Apache SuperSet.
  • Utilize database technologies on AWS.
  • Lead the data integration aspect of mission-critical projects, ensuring hands-on delivery and adherence to best practices.
  • Define and implement standard processes and procedures for managing data integration and data exchange models, with a focus on security, traceability, audit, performance, and risk.
  • Develop a skilled team of integration engineers responsible for data integration and data quality.
  • Define effective hybrid models for integration between legacy and cloud applications (including Salesforce, Jira, REST API) for all integration methods (ETL/ELT/Data hub).
  • Architect and design scalable data solutions, ensuring alignment with business and technology strategies.
  • Oversee the development and implementation of data lakes using cloud technologies such as S3, Spark, or Cassandra.
  • Provide data modeling expertise, designing logical models/data dictionaries from business requirements.
  • Ensure compliance with data governance, data quality, data security, and data management best practices.

Qualifications:

  • Bachelor’s degree in Engineering, IT, or a related field required.
  • 5+ years of hands-on experience with data integration tools, data analytics, data governance, and master data management.
  • 5+ years of experience in API integration and code development using Python or Java.
  • 3+ years of experience in data architecture, including designing and implementing scalable data solutions.
  • Proven experience in developing and implementing data architecture strategies that align with business and technology goals.
  • Expertise in architecting data lakes and data warehouses, with hands-on experience using cloud technologies such as S3, ADW, Spark, Hadoop, or Cassandra.
  • Proficiency in data modeling, including the design of logical models/data dictionaries based on business requirements.
  • Experience with all phases of the software development lifecycle and requirements gathering within various analytical and integration technologies and applications.
  • Prior experience in defining and building an Enterprise Data Warehouse (EDW) and modeling/implementing Master Data subject areas is preferred.
  • Extensive knowledge of data governance, data quality, data security, and data management best practices.
  • Demonstrated leadership skills in guiding technology teams through data architecture and integration projects.

MerchantE is committed to creating a diverse work environment and is proud to be an Equal Opportunity Employer.



  • Alpharetta, United States Advanced Tech Placement Full time

    ***Contract to Hire***The Chief Enterprise Data Architect uses, develops and maintains descriptive representations (strategy, principles, design patterns, model and languagespecifications) critical for effective data management in and among systems to enable the enterprise’s business. Effective data management in theenterprise necessitates a focus on data...


  • Alpharetta, United States Advanced Tech Placement Full time

    ***Contract to Hire***The Chief Enterprise Data Architect uses, develops and maintains descriptive representations (strategy, principles, design patterns, model and languagespecifications) critical for effective data management in and among systems to enable the enterprise’s business. Effective data management in theenterprise necessitates a focus on data...

  • Azure Data Architect

    3 weeks ago


    Alpharetta, United States Infinite Computer Solutions Full time

    Skill: Azure Data ArchitectLocation: Alpharetta, GA (Onsite Mon – Fri)W2 PositionWe are seeking an Azure Data Architect who has data architecture expertise and who has good experience with Azure Cosmos DB, Azure SQL (all flavors), Azure Redis, Snowflake, Kafka. The candidate should have good experience with Azure Databricks, Data Factory experience,...

  • Azure Data Architect

    3 weeks ago


    Alpharetta, United States Infinite Computer Solutions Full time

    Skill: Azure Data ArchitectLocation: Alpharetta, GA (Onsite Mon – Fri)W2 PositionWe are seeking an Azure Data Architect who has data architecture expertise and who has good experience with Azure Cosmos DB, Azure SQL (all flavors), Azure Redis, Snowflake, Kafka. The candidate should have good experience with Azure Databricks, Data Factory experience,...

  • Senior Data Architect

    4 weeks ago


    Alpharetta, United States Infinite Computer Solutions Full time

    Skill: Data ArchitectLocation: Alpharetta, GA(Mon - Fri Onsite)W2 PositionJob Description:The Data Architect is responsible for all database-related aspects of the systems in scope and is accountable for providing technical leadership to project-wide teams, ownership of non-functional requirements, and acts a technical consultant to both the development and...

  • Data Architect

    4 weeks ago


    Alpharetta, United States MerchantE Full time

    Job Summary: The Data Architect or Lead Data Engineer will be instrumental in developing the company's Data Lakehouse. This position is responsible for the design, architecture, development, and implementation of a comprehensive Data Lakehouse strategy including dimensional modeling at the enterprise level. The ideal candidate will lead the creation and...


  • Alpharetta, United States Automatic Data Processing Full time

    About the RoleWe are seeking an experienced Principal Architect to join our team at Automatic Data Processing (ADP). As a key member of our architecture team, you will play a critical role in shaping the technical direction of our organization and driving the development of innovative solutions.Key ResponsibilitiesBlueprints and Strategy: Influence and...


  • Alpharetta, United States RTA US Full time

    Job Description**Job Title:** Snowflake Cloud Data Platform DBA**Job Type:** Full-time**Industry:** Financial Services**Location:** Remote (Hybrid)**Job Summary:** We are seeking an experienced Snowflake Cloud Data Platform DBA to join our team at RTA US. The successful candidate will be responsible for designing and architecting database solutions on...


  • Alpharetta, United States RTA US Full time

    Job Description**Job Title:** Snowflake Cloud Data Platform DBA**Job Type:** Full-time**Industry:** Financial Services**Location:** Remote (Hybrid)**Job Summary:** We are seeking an experienced Snowflake Cloud Data Platform DBA to join our team at RTA US. The successful candidate will be responsible for designing and architecting database solutions on...


  • Alpharetta, United States Cedent Consulting Full time

    Title: Sr Enterprise Data Architect @ Atlanta, GA / Bloomington, IllinoisTerms of Hire: Full Time. Salary: $ 150 K/ YR + Benefits.Role DescriptionSeeking an experienced Data Architecture Leader to join the Enterprise Architecture team. This role will be responsible for developing data architecture plans and driving the plans to fruition in collaboration...

  • MDM Data Architect

    1 month ago


    Alpharetta, United States Mativ Full time

    Description Mativ is a global leader in specialty materials headquartered in Alpharetta, Georgia. The Company offers a wide range of critical components and engineered solutions to solve our customers’ most complex challenges.  This MDM Data Architect role will be a key leader in our Data team reporting into our BI & Analytics Director. The Architect...


  • Alpharetta, GA, United States Cedent Consulting Full time

    Title: Sr Enterprise Data Architect @ Atlanta, GA / Bloomington, IllinoisTerms of Hire: Full Time. Salary: $ 150 K/ YR + Benefits.Role DescriptionSeeking an experienced Data Architecture Leader to join the Enterprise Architecture team. This role will be responsible for developing data architecture plans and driving the plans to fruition in collaboration...


  • Alpharetta, United States Equifax Inc. Full time

    The Big Data Cloud Architect will lead the architecture design of the Quality Management Platform (event monitoring). You will work closely with development segments in our Data Fabric Data Services (DFDS) organization to guide the design and implementation for the data quality event monitoring system. You will partner with Product Owners and the...

  • Solutions Architect

    5 days ago


    Alpharetta, United States GRIFFIN Global Technologies Full time

    Job DescriptionJob DescriptionGRIFFIN Global Technologies, based in Atlanta since 2009, is looking for a Solutions Architect to join our team in Alpharetta, GA. In this role you will work with GRIFIFN clients on a variety of projects. Clients come to GRIFFIN to solve some of their most complex business problems. You must enjoy the challenge that comes with...


  • Alpharetta, United States Zealogics.com Full time

    Job DescriptionJob DescriptionDescription:Database Platforms Services - Analytics team is looking for a proactive, enthusiastic, and knowledgeable individual who is a self-starter and is passionate about Engineering Database solutions.This position will be focused on building automation pipelines around database platforms (on-prem and cloud) which will...


  • Alpharetta, United States ADP Full time

    ADP is hiring a Chief Enterprise Architect to be focused on integration. As a Chief Enterprise Architect, you will be at the forefront of architecting and implementing sophisticated integration solutions that align with our strategic objectives. You will leverage your deep technical expertise to design state-of-the-art systems that enhance data flow,...


  • Alpharetta, United States ADPMN INC Full time

    Job DescriptionJob DescriptionJob title:Salesforce Architect (ONLY W2/Own Corp)Location:Remote(EST)Duration ::Long TermContractJOB Description ::We are seeking a dynamic and experienced Salesforce Architect to join our team. This role goes beyond traditional technical responsibilities, blending deep technical expertise with strategic leadership. The idea...


  • Alpharetta, United States RTA US Full time

    Job DescriptionJob DescriptionDetails:Job Title: Snowflake Cloud Data Platform DBADuration: 12 months (Possible Conversion)Location: Jersey City, NJ (Hybrid)Domain: Investment Banking company Primary Responsibilities:Design and Architect database solution on Snowflake data cloud platform, AWS, Azure and Databricks.Manage and optimize the performance,...


  • Alpharetta, United States LexisNexis Risk Solutions Full time

    Lead Solutions Architect Position at LexisNexis Risk SolutionsEnsure compliance with enterprise and architectural standards and methodologiesDevelop sophisticated code for software systems and provide expert-level supportOversee system and user acceptance testing phases to ensure high-quality business solutionsEstablish technical guidelines and mentor junior...


  • Alpharetta, United States Mitchell Martin Inc. Full time

    Our client, a leading financial services organization is seeking a Data System Engineer who will be responsible for tasks such as data engineering, data modeling, ETL processes, data warehousing, and data analytics & science. Their platform runs both on-premise and on the cloud (AWS/Azure). Knowledge/Skills: • Able to establish, modify or maintain data...