Senior Data Engineer

Job Description

Job Title/Level

Senior Data Engineer

Location

Hybrid

Salary

$165,000 - $180,000 annually

Schedule

Full Time

Preferred Clearance

Able to obtain Public Trust & US Citizenship

Covid Vaccination

As a condition of employment, employees will be required to provide proof of their COVID-19 vaccination.

Company Overview

WhirlWind is on a mission to help each client succeed by using our management consulting and technology expertise. We design, build, and manage secure environments that support data-driven decision making and data-powered products. Our services transform governments and enhance the lives of citizens.

Our people are driven and committed to our mission. If you want to join a team of rock stars who do incredible, purposeful work, and have fun doing it, come thrive with us and be one of the heroes behind our success. We offer an attractive benefits package including a competitive base salary.

Position Overview

WhirlWind Technologies is seeking a Senior Data Engineer to support a client-facing project in Suitland, MD. The candidate will serve as a Senior Data Engineer/Database Administrator (DBA)

Essential Duties & Responsibilities

Duties include but are not limited to:

Create new and maintain current databases,

Database design using optimum schema for requirements: Star, Snowflake, Relational, Hierarchical, Network, or Flat

Extracting and /or loading data

Create and maintain optimal data pipeline architecture,

Assemble large, complex data sets that meet functional / non-functional business requirements.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS 'big data' technologies.

Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

Work with data and analytics experts to strive for greater functionality in client data systems.

Create clear and concise presentations as needed to communicate with the customer and stakeholders the status of projects and assigned tasks

Provide weekly written status reports and brief customer weekly on the status of the project activities

Key Technical Skills

Advanced experience with installing and configuring databases and Linux

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

Experience building and optimizing 'big data' data pipelines, architectures and data sets.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Database performance tuning and indexing

Strong analytic skills related to working with unstructured datasets.

Build processes supporting data transformation, data structures, metadata, dependency and workload management.

A successful history of manipulating, processing and extracting value from large, disconnected datasets.

Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.

Knowledge of database design and theories

Advanced working knowledge and experience with database queries

Strong project management and organizational skills.

Experience supporting and working with cross-functional teams in a dynamic environment

Strong experience in machine learning, predictive analytics, data modeling, business intelligence tools, data analytics, data collection, and generating reports

Experience with relational databases, structured, and unstructured very large data sets

Experience with PostgreSQL and NoSQL databases such as MongoDB

Ability to leverage expertise in time management to complete assignments independently and

effectively

Advanced working knowledge and experience authenticating data, maintaining data integrity, ethically handling and protecting PII and other sensitive data

Experience with SAS Analytical and Statistical software; Tableau

Ability to estimate work and meet deadlines

Strong written and oral communications skills

Database design and data management

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or Physics

Master's or PHD degree preferred

AWS Certification a plus: Any: Data Engineer, DevOps Engineer, Solutions Architect

Requirements

Strong experience in machine learning, predictive analytics, data modeling, business intelligence tools, data analytics, data collection, and generating reports

Experience with relational databases, structured, and unstructured very large data sets

Experience with PostgreSQL and NoSQL databases such as MongoDB; RedShift, data warehouse, data lake, data wrangling, and data pipelines.

Experience working in hybrid cloud environments. AWS cloud preferred

Ability to leverage expertise in time management to complete assignments independently and

effectively

Experience with SAS Analytical and Statistical software; Tableau, PowerBI, or other

Ability to estimate work and meet deadlines

Strong written and oral communications skills

Database design and data management

Experience with DBA common tasks and best practices such as daily backup and restore

Experience with big data tools: Hadoop, Spark, Kafka, etc.

Experience with relational SQL and NoSQL databases, including Postgres.

Experience with data pipeline and workflow management tools: Airflow, etc.

Full-time

Hybrid remote