Senior Data Science Analyst/ Data Engineer

Position: Data Science Analyst/ Data Engineer

Location: Richmond Virginia 23219 (Hybrid)

Duration: 12 months

Job ID: 180986

High Level Project Overview:

Role Summary:

• The Senior Data Engineer is a handson expert and technical leader, actively engaged in designing, building, and optimizing scalable, reliable data pipelines at an enterprise level.
• This role not only guides architectural decisions but also directly implements advanced ELT solutions, troubleshoots complex data challenges, and ensures best practices through practical, highimpact contributions.
• This role combines deep handson expertise with technical ownership, mentoring, and architectural alignment.
• The Senior Data Engineer drives and implements data engineering best practices, ensures high standards for quality and security, and partners with architecture and platform teams to improve the overall data ecosystem.

Key Responsibilities:

• Build endto-end data pipelines and ETL/ELT solutions to support analytics, reporting, and AI/ML use cases, ensuring solutions are robust and production-ready through practical implementation.
• Apply scalable patterns for batch and incremental processing by developing, testing, and deploying data workflows, focusing on handson coding and troubleshooting.
• Review and implement data modeling, transformation logic, and performance strategies, using deep technical expertise to optimize and validate solutions.
• Evaluate, select, and integrate tooling, frameworks, and platform capabilities by actively prototyping and configuring systems to meet project requirements.
• Build up complex, highvolume data pipelines using SQL-centric ETL/ELT patterns.
• Design and implement scalable streaming pipelines to process realtime data, ensuring low latency and reliable delivery for analytics and operational use cases.
• Lead performance tuning efforts across pipelines, warehouses, and workloads.
• Ensure data pipelines are resilient, observable, and production ready.
• Implement enterprisegrade error handling, restart ability, and monitoring.
• Build and maintain scalable, lowlatency streaming data pipelines using technologies such as Kafka, Kinesis, or Spark Streaming
• Perform onthe-fly data cleaning, validation, and enrichment before data reaches its final destination.
• Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability
• Implement standards for data quality checks, validation, and reconciliation.
• Ensure pipelines meet security, access control, and governance requirements.
• Partner with governance & DataOps teams on metadata, lineage, and auditability.
• Apply consistent naming conventions, documentation, and coding standards.
• Improve operational monitoring, alerting, and incident response processes.
• Proactively identify reliability, performance, and cost optimization opportunities.
• Support and guide production troubleshooting and root cause analysis.
• Investigating data quality incidents and identifying design/coding GAPs
• Participate in design and code reviews to enforce quality and best practices.
• Partner with various infrastructure teams, application teams, and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes.
• Translate ambiguous requirements into well designed technical solutions.
• Work in complex multiplatform environments on multiple project assignments.

Required Years of Experience:

• Must have 5 to 7 plus years of Data Engineering experience.

Education:

• Education: Bachelors or higher required
• Discipline: Computer Science, Information Systems, Mathematics

Required Skills and Experience:

• Advanced expertise in SQL, ELT patterns, and performance tuning.
• Strong experience with Oracle Exadata, Snowflake or similar cloud/on prem data warehouses.
• Hands on experience with enterprise ETL/ELT platforms (e.g., Talend, dbt, Informatica).
• Deep understanding of data warehousing architecture and dimensional modeling.
• Experience designing and supporting large scale, production data pipelines.
• Strong scripting experience (Python, shell).
• Experience with data virtualization tools (e.g., Denodo, Composite, dremio, Starburst).
• Experience with DataOps practices, CI/CD, and observability.
• Required 5 to 7 plus years of Data Engineering experience.
• ETL Development and Process Support, may require weekend/off business hours work.

Key Behavioral Expectations ("How We Work"):

• Delivering at Pace: Acts with urgency to meet deadlines while maintaining quality, prioritizing workload effectively under pressure.
• Collaborative Teamwork: Actively supports colleagues, shares knowledge freely, and treats others with dignity and respect.
• Effective Communication: Tailors communication style to the audience, ensuring clarity and transparency in both successes and challenges.
• Ownership and Adaptability: Takes responsibility for outcomes and welcomes feedback for improvement.
• Ability to work independently
• Achievement orientation
• Selfstarter
• Concern for quality
• Flexibility

Preferred / Nice to Have:

• Experience supporting AI/ML or advanced analytics pipelines.
• Cloud platform experience (AWS, Azure, or GCP).
• Prior experience influencing enterprise data standards or reference architecture.
• Experience optimizing cost and performance in cloud data warehouses.
• Handson experience with Cribl, Apache Kafka, Kafka Connect, Spark Streaming, or Apache Flink

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: $56- $61/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