Architect – Data & Snowflake

Position:IT Architect – Data & Snowflake
Location: Richmond, VA
Duration: 12 months
Job ID: 175582

Job Overview:

The Senior Software Systems Engineer will serve as a strategic technical leader within the Enterprise Data & Analytics team. This role is responsible for defining the architecture, standards, best practices, and future direction of the enterprise data platform. The position involves designing scalable data pipelines, governing Snowflake usage across the organization, and developing high-quality data models that power analytics, BI, AI/ML, and data-driven decision-making. The engineer will ensure the data ecosystem is secure, governed, cost-optimized, and capable of supporting enterprise self-service analytics, operational reporting, and advanced analytics initiatives.

Responsibilities:

• Serve as the technical authority for ETL and data engineering architecture.
• Design and own end-to-end ETL/ELT architectures for batch and incremental data processing.
• Architect high-volume, high-throughput pipelines supporting structured and semi-structured data.
• Define architectural standards, including database design, warehouse sizing, multi-cluster strategies, RBAC, and performance optimization.
• Establish data engineering, modeling, and transformation standards across the analytics ecosystem.
• Collaborate with BI and analytics teams to design scalable, governed data models supporting dashboards, KPIs, and advanced analytics.
• Partner with data engineering, analytics, business SMEs, cloud infrastructure, and cybersecurity teams to design reliable and secure data architectures.
• Ensure data solutions meet enterprise requirements for reliability, performance, scalability, and disaster recovery.
• Lead root cause analysis for data platform issues and drive remediation of architectural gaps.
  

• 7 years of experience in data architecture, data engineering, or enterprise data platform roles.
• Hands-on advanced experience with Snowflake, Oracle Exadata, including performance tuning, RBAC, resource management, and advanced Snowflake features (streams, tasks, data sharing).
• Strong proficiency with SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS).
• Expertise in designing analytical data models (Star/Snowflake schemas, data vault, semantic layers).
• Experience building scalable data pipelines using tools like dbt, Airflow, ADF, Databricks, Informatica, Talend, or similar.
• Experience with Dataiku for analytics and ML pipeline enablement.
• Strong communication skills, both verbal and written.
• Ability to lead, collaborate, or work effectively in a variety of teams, including multi-disciplinary teams.
• Minimum of a High School Diploma or Equivalency.
  

• Cloud or platform certifications (Snowflake, Databricks, Azure, Informatica).

About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $72 - $75/hr. W2

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at 1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com