Senior Software Systems Engineer

Ampcus Incorporated

Richmond, VA

JOB DETAILS
SKILLS
Access Control, Amazon Web Services (AWS), Analysis Skills, Architectural Services, Artificial Intelligence (AI), Auditing, Benchmarking, Best Practices, Business Intelligence, Business Services, Cataloguing, Cloud Computing, Consulting, Continuous Deployment/Delivery, Continuous Improvement, Continuous Integration, Cost Control, Cross-Functional, Data Analysis, Data Management, Data Modeling, Data Processing, Data Quality, Data Warehousing, DataArchitect Data Modeling Tool, Database Design, Database Extract Transform and Load (ETL), DevOps, Disaster Recovery, Ecosystems, Enterprise Architecture, Error Handling, Forecasting, High Throughput, Informatica, Information Architecture, Information/Data Security (InfoSec), Internet Security, Leadership, Mentoring, Metadata, Microsoft Windows Azure, Operational Audit, Oracle, Performance Metrics, Performance Tuning/Optimization, Predictive Modeling, Printed Circuit Board Design, Product Development, Quality Monitoring, Reporting Dashboards, Resource Management, Root Cause Analysis, SQL (Structured Query Language), Scalable System Development, Service Level Agreement (SLA), Snowflake Schema, Software Engineering, Standards Development, Star Schema, Strategic Planning, Structured Data, Systems Engineering, Technical Leadership, Technical Strategy, Technical Support, Test Automation, Test Data, Training Data Sets, Use Cases, User Documentation
LOCATION
Richmond, VA
POSTED
30+ days ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
 

Job Title: Senior Software Systems Engineer
Job Location: Richmond, VA

 

Required Proven experience:

  • MUST have a minimum of 7 years in data architecture, data engineering, or enterprise data platform roles.
  • MUST have hands on advanced experience with Snowflake, Oracle Exadata, including performance tuning, RBAC, resource management, and advanced Snowflake features (streams, tasks, data sharing).
  • MUST have strong proficiency with SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS).
  • Must have expertise designing analytical data models (Star/Snowflake schemas, data vault, semantic layers).
  • Experience building scalable data pipelines using tools like dbt, Airflow, ADF, Databricks, Informatica, Talent or similar.

Nice to Have Skills:

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

Job Description: 

The IT Architect – Data & Snowflake is a strategic technical leader within the Enterprise Data & Analytics team, responsible for defining the architecture, standards, best practices and future direction of the enterprise data platform. This role designs scalable data pipelines, governs Snowflake usage across the organization, and develops high quality data models that power analytics, BI, AI/ML, and data driven decision making. The architect ensures that the data ecosystem is secure, governed, cost optimized, and capable of supporting enterprise self service analytics, operational reporting, and advanced analytics initiatives.

We are seeking a hands on Data Architect with a strong ETL and Data Engineering background to design, build, and optimize large scale data ingestion, transformation, and delivery platforms. This role is focused on creating reliable, observable, and high performance data pipelines that support enterprise analytics, reporting, and advanced AI/ML use cases. You will architect end to end data engineering solutions across on prem and cloud platforms, lead data integration strategy, and establish best practices around data quality, monitoring, and operational excellence.

Key Responsibilities

Technical Leadership

  • Serve as the technical authority for ETL and data engineering architecture.
  • Review pipeline designs, code standards, and performance benchmarks.
  • Mentor and guide data engineers on best practices and modern data engineering patterns.
  • Partner with stakeholders to translate business data requirements into scalable technical solutions.
  • Ability to lead complex data engineering initiatives in enterprise environments

ETL / ELT Architecture & Design

  • Design and own end to end ETL/ELT architectures for batch and incremental data processing.
  • Define patterns for data ingestion from Oracle Exadata and other source systems into cloud platforms.
  • Architect high volume, high throughput pipelines supporting structured and semi structured data.
  • Continuously evaluate and improve data infrastructure and workflows

Establish standards for:

  • Data transformation logic
  • Schema evolution
  • Error handling and reprocessing
  • Performance tuning

Define best practices for:

  • Metadata management
  • Parameterization and reusability
  • Pipeline deployment and versioning

Strong expertise in:

  • Batch and incremental data processing
  • ELT patterns and push down processing
  • Performance tuning of large ETL workloads

Enterprise Data Architecture & Design

  • Architect end to end data pipelines (batch, streaming, real time) to support enterprise analytics, BI, and data products.
  • Define architectural standards, including database design, warehouse sizing, multi-cluster strategies, RBAC, and performance optimization.
  • Create and maintain enterprise semantic models, curated datasets, and reusable data assets to enable self-service analytics.
  • Develop architecture patterns for AI/ML feature pipelines, analytical sandboxes, and model scoring in Snowflake.

Governance, Standards & Best Practices

  • Establish data engineering, modeling, and transformation standards across the analytics ecosystem (e.g., naming conventions, ELT frameworks, versioning).
  • Implement DevOps/DataOps practices—CI/CD pipelines, automated testing, data quality checks, and observability across data pipelines.
  • Partner with Data Governance to define standards for data quality, lineage, metadata management, and cataloging.
  • Implement Snowflake security, access controls, auditing, and cost management practices.

Analytics & Data Product Enablement

  • Collaborate with BI and analytics teams to design scalable, governed data models supporting dashboards, KPIs, and advanced analytics.
  • Architect data solutions that support predictive analytics, forecasting, segmentation, and personalization use cases.
  • Guide development of data products, ensuring they follow enterprise standards and meet business requirements.

Cross-Functional Collaboration

  • Partner with data engineering, analytics, business SMEs, cloud infrastructure, and cybersecurity teams to design reliable and secure data architectures.
  • Translate business needs into scalable technical solutions that support enterprise reporting, analytics, and insight generation.
  • Participate in Architecture Review Boards, solution design sessions, and enterprise data strategy planning.

Operational Excellence

  • Establish standards for monitoring, alerting, SLA/SLO management, and operational resiliency of analytics pipelines.
  • 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.
  • Proven experience with data quality, data observability, and pipeline monitoring

Required Years of Experience:

  • 7 years in data architecture, data engineering, or enterprise data platform roles.

Education:

  • Minimum of a High School Diploma or Equivalency
 

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com