Data Architect

Compunnel, Inc.; Nashville (TN); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading IT consulting firm is seeking a Data Architect to lead data management initiatives across on-premises and cloud environments in Nashville, TN. You will oversee legacy database systems and cloud platforms, ensuring secure and efficient data storage. The ideal candidate has extensive experience with various RDBMS and excellent communication skills to present technical topics to management.

Qualifications

• 3–5 years of experience with cloud RDBMS.
• 3 years of relational database design experience.
• Hands-on experience with AWS Cloud IAM and Oracle RDBMS.

Responsibilities

• Review existing implementations for best practices.
• Provide guidance on database configurations.
• Collaborate with vendors to address data issues.

Skills

Cloud RDBMS experience

Relational database design

Database cost optimization

Hands-on experience with AWS Cloud IAM

SQL Server RDBMS experience

Power BI experience

Communication skills

Tools

PostgreSQL

Oracle RDBMS

SQL Server

ETL tools

SSAS

SSMS

Visual Studio

C#

Job description

We are seeking a Data Architect to lead data management initiatives across on-premises and cloud environments.

This role involves overseeing vendors supporting legacy database systems (Oracle, MySQL, SQL Server) and cloud platforms (PostgreSQL, MySQL, SQL Server, Snowflake).

The position includes monitoring versions, upgrades, auditing, patching, troubleshooting, and working with ETL and reporting tools.

The Data Architect will also review new and ongoing projects impacting the data tier, ensuring secure and efficient data storage, access, and compliance.

Key Responsibilities

• Review existing implementations of on-prem and cloud RDBMS for best practices and design issues.
• Provide guidance and recommendations on database configurations to ensure uptime and optimal user experience.
• Oversee troubleshooting and resolution of issues impacting database systems.
• Collaborate with multiple vendors to address complex data-related issues and interoperability constraints.
• Manage database auditing policies and procedures.
• Evaluate documentation and database designs to identify structural requirements.
• Analyze proposed database implementations for efficiency, security, and scalability.
• Respond to system problems promptly and provide support for critical issues.

Required Qualifications

• 3–5 years of experience with cloud RDBMS (PostgreSQL, SQL Server, Snowflake) in support or design roles.
• 3 years of relational database and data warehouse design and support experience.
• 3 years of cloud database cost optimization experience.
• 3–5 years hands‑on experience with AWS Cloud IAM, Oracle RDBMS, ASM, RMAN.
• 3–5 years hands‑on experience with SQL Server RDBMS.
• 3–5 years experience with Power BI.
• Hands‑on experience with SSAS, SSMS, Visual Studio, and C#.
• Experience with Oracle migrations is a plus.
• Excellent communication skills, including the ability to present complex technical topics to upper management.

Preferred Qualifications

• Experience with ETL tools and reporting solutions.
• Familiarity with data security and compliance standards.