Senior Data Science Analyst

Job Description:

Description:

Pre-Screen Questions: (Please list at the bottom of candidate resume)
1. What does “production-ready pipeline” mean to you?
2. Tell me about a data quality incident—how did you detect it, fix it, and prevent it?
3. How do you implement incremental loads reliably when source systems don’t provide CDC?
4. How would you build restartability into a pipeline from day 1?
5. Where does data virtualization fit vs physical ingestion into a lake/warehouse?
6. How do you support auditability and lineage for compliance?

Job Title: Data Engineer

Primary location of assignment: Thomas F Farrell Building

How many contractors are you needing? 2

What is the preferred candidate location (local, non-local, remote?) and is there flexibility? Local or drive in candidates ONLY, No 100% remote

If you are open to looking at non-local candidates will per diem be offered? No

What schedule is the candidate required to work: Alternate weeks in Richmond VA office; other week remote. (5 days in office, 5 days remote, repeating). No 100% remote

Are any certification required: No

Required Skills & 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+ 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
• Self starter
• Concern for quality
• Flexibility

Preferred / Nice to Have
• Experience supporting AI/ML or advanced analytics pipelines.
• Cloud platform experience (AWS, Azure, or Google Cloud Platform).
• Prior experience influencing enterprise data standards or reference architecture.
• Experience optimizing cost and performance in cloud data warehouses.
• Hands-on experience with Cribl, Apache Kafka, Kafka Connect, Spark Streaming, or Apache Flink

High Level Project Overview:
Role Summary
The Senior Data Engineer is a hands-on 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, high-impact contributions.
This role combines deep hands on 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 end-to-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 hands-on 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, high-volume data pipelines using SQL-centric ETL/ELT patterns.
• Design and implement scalable streaming pipelines to process real-time 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 enterprise-grade error handling, restart ability, and monitoring.
• Build and maintain scalable, low-latency streaming data pipelines using technologies such as Kafka, Kinesis, or Spark Streaming
• Perform on-the-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 multi-platform environments on multiple project assignments.

Required Years of Experience:
• MUST have 5 to 7+ years of Data Engineering experience.

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

Are there any specific companies/industries you’d like to see in the candidate’s experience?
• High Preference for candidates that have previously worked with a large scale commercial utilities team but will review candidates who have a background with large scale capital projects for companies

Preferred Interview Process Overview (High level):
• Teams – Camera On
• If candidate performs well in first round of questions will be asked to participate in a technical round of questions