Data Analyst

Whitman, Requardt and Associates, LLP; Richmond (VA); On-site; USD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking company that values quality work and innovative solutions! As a Data Engineer, you will play a pivotal role in designing and maintaining our data infrastructure, enabling data-driven decisions across various domains. Collaborate with a talented team to implement cloud-based solutions and standardize data governance practices. This position offers a unique opportunity to work on impactful projects that enhance our organization's analytics capabilities. If you're passionate about transforming messy data into valuable insights and thrive in a collaborative environment, we want to hear from you!

Benefits

Flexible work schedule options

Competitive salary

Leave accrual and paid holidays

Healthcare benefits

Group Life Insurance

401(k) Retirement Plan

Tuition Reimbursement

Parental and maternity leave benefits

Qualifications

• 5-10 years of experience in data engineering or related field.
• Strong proficiency in SQL and experience with relational databases.

Responsibilities

• Design and implement scalable data pipelines for data ingestion.
• Automate data processing workflows using scripting languages.

Skills

SQL

Python

Data Analysis

Data Governance

Data Modeling

Cloud Platforms

Spatial Data

Data Quality Assurance

Education

Master's Degree in Data Analysis

Tools

PostgreSQL

Azure

AWS

Git

Databricks

Job description

At Whitman, Requardt & Associates, LLP, we are "People Focused and Project Driven". We have been in business for 110 years and we are known for our quality work and quality employees. This is your chance to join our team - help us to design the infrastructure and buildings that improve the world!

Do you love building the foundation for data-driven decisions? Are you passionate about wrangling messy data and turning it into insights? If so, then we want to hear from you!

We are searching for a talented and experienced Data Engineer to join our growing team. In this role, you will play a critical part in designing, developing, and maintaining the data infrastructure that fuels our organization's analytics capabilities. You will also be responsible for implementing on-prem and cloud-based solutions and standardizing data governance as we scale out the data practice.

This role will span across civil engineering practices and requires the ability to adapt solutions across multiple domains. Accordingly, you should be able formulate an MVP, empathize with the challenges and needs of clients and colleagues, and work collaboratively with subject matter experts.

Responsibilities

• Design and implement scalable data pipelines for ingesting, transforming, and loading data from various sources (databases, APIs, etc.)
• Develop and maintain data models to optimize data storage, retrieval, and analysis.
• Ensure data quality and integrity through data cleansing, validation, and transformation techniques.
• Automate data processing workflows using scripting languages and orchestration tools (e.g., Python, R, etc.)
• Document and curate metadata and QA/QC results.
• Work closely with Data Scientists, and other stakeholders to understand data needs and translate them into technical solutions.
• Troubleshoot and resolve complex data issues to ensure smooth data flow.
• Stay up-to-date on the latest big data technologies and trends.
  
  

Requirements

• Minimal Education: Master's degree with Data Analysis coursework required.
• 5-10 years of progressive experience in data engineering or a related field.
• 5-10 years of experience with spatial data (eg. ESRI. PostGIS, GeoPandas).
• Strong proficiency in SQL and experience with relational databases (e.g.PostgreSQL).
• Excels across a range of data formats including JSON/GeoJSON, parquet and various unstructured formats.
• Experience setting up and using cloud-based data platforms (e.g., Azure with Snowflake or Databricks and Lakehouse, AWS Athena, Google BigQuery).
• Solid understanding of data warehousing concepts (ETL processes, data modeling).
• Experience with data ingestion tools and data workflow orchestration tools.
• Programming experience in Python and/or R.
• Experience with version control systems (e.g., Git).
• Ability to work collaboratively and communicate with a growing team.
  
  

Preferred Qualifications

• Experience with machine learning model deployment.
• Experience with feature engineering and monitoring.
• Experience in the Architecture & Engineering space – transportation, asset management, transit, water resources etc.
• Experience implementing and standardizing data governance best practices.
• All application questions must be answered to be considered for this position. ***
  
  

Benefits

WRA recognizes that employees play an important role in its success. Our commitment to full-time employees is reflected in the comprehensive benefits package we offer:

• Flexible work schedule options
• Competitive salary
• Leave accrual and paid holidays
• Healthcare benefits
• Group Life Insurance, as well as additional optional life Insurance, short and long term disability insurance
• Flexible spending accounts for medical and dependent care reimbursement
• 401(k) Retirement Plan
• Tuition Reimbursement
• Employee Assistance Program
• Parental and maternity leave benefits
  
  

WRA is an equal opportunity/affirmative action employer and complies with all applicable anti-discrimination laws.

Applicants must be currently authorized to work in the United States on a full-time basis without the need for employment-based visa sponsorship now or in the future. WRA will not sponsor applicants for U.S. work visa status for this opportunity. (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa)

Position # 2316

***** Not accepting resumes from 3rd party recruiters for this position *****

- Onsite - Mid Level