Job Title/Level S enior Data Engineer Location Hybrid Salary $1 65 ,000 - $1 8 0 ,000 annually Schedule Full Time Preferred Clearance Able to obtain Public Trust & US Citizen ship 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 A dvanced 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 C omputer S cience , 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.