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 position at Pyramid Consulting, Inc. is a full-time contract role focused on developing and implementing enterprise data strategies, particularly in relation to cloud data modernization efforts. The role involves guiding data engineering teams and ensuring effective data management practices while leveraging cloud-based services.

Responsibilities

• Assist in building the enterprise data strategy related to client data modernization efforts.
• Implement and guide data engineering development teams on sound 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, Data Governance, and Data Migration from on-premises to AWS Cloud.
• Experience in building enterprise data management solutions, including data lakes, data warehouses, and data marts using dimensional modeling in cloud-based services (e.g., Databricks, S3, Redshift).
• Advanced knowledge of database design and data modeling.
• Expert level SQL experience with complex and efficient queries in Db2 and SQL Server.
• Experience 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 data integration needs.
• Experience with Collibra Data Intelligence Cloud and Data Quality solutions.
• Exposure to z/os (mainframe) data.

Benefits

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