Data Architect

$187,200 - $208,000/Yr

Pyramid Consulting - Duluth, GA

Full-time - Mid Level

Duluth, GA

Professional, Scientific, and Technical Services

About the position

The Data Architect will play a crucial role in developing and implementing the enterprise data strategy for a client in the financial industry, focusing on modernizing client data and migrating it to the cloud. This position requires expertise in cloud data architecture and data management, with responsibilities that include guiding data engineering teams and ensuring sound data strategies are in place.

Responsibilities

• Assist in building the enterprise data strategy related to client data modernization efforts.
• Implement and guide data engineering development teams on data strategies, pipelines, movement, and access across cloud-based services.
• Serve as a subject matter expert in cloud data architecture and data management.

Requirements

• Expertise in data modeling, master data management, and data governance.
• Experience in data migration from on-premises to AWS Cloud.
• Proficiency in building enterprise data management solutions, including data lakes, data warehouses, and data marts using dimensional modeling in cloud-based services.
• Advanced knowledge of database design and expert-level SQL experience with complex queries in Db2 and SQL Server.
• Experience in building T-SQL scripts, functions, and stored procedures with SQL Server and Db2.
• Familiarity with BI tools, particularly Power BI.
• Experience with programming languages and understanding of data access and integration needs.
• Experience with Collibra Data Intelligence Cloud and Data Quality solutions.

Nice-to-haves

• Exposure to z/os (mainframe) data.

Benefits

• Health insurance (medical, dental, vision)
• 401(k) plan
• Paid sick leave