Senior Data Engineer I

Summary

Join our dynamic team as a Senior Data Engineer! This role demands extensive experience in data engineering, operations, analytics, and management. You will leverage your Python or R skills, SQL expertise, and cloud (AWS) knowledge to build scalable data solutions and support data pipelines. Collaboration with cross-functional teams is key to developing efficient data management strategies. The position requires a minimum of six years of relevant experience and a bachelor's or advanced degree in a related field. U.S. Citizenship is required, and the ability to obtain Public Trust clearance is necessary.

Requirements

• Proficiency in Python or R for data operations and analytics
• Strong expertise in SQL development with enterprise databases such as PostgreSQL or SQL Server
• Experience in Linux/UNIX server environments as well as Windows
• Hands-on experience with ETL development and data pipeline operations
• Familiarity with cloud-based solutions such as AWS
• Experience in application development using Java, Python, Rust, or Scala
• Knowledge of DevOps practices and automation in data environments
• Strong understanding of database instrumentation and automation
• Experience developing line of business applications using Salesforce and SharePoint
• U.S Citizenship required
• Ability to obtain Public Trust
• Minimum of six (6) years of relevant experience in data engineering, analytics, and data management
• Bachelors or advanced degree in Information Systems, Computer Science, Data Science, Mathematics, Statistics, Operations Management, Engineering, or a related field preferred

Responsibilities

• Design and implement data storage and processing infrastructure to manage large-scale data analytics
• Develop and maintain robust and scalable solutions for managing structured and unstructured data using traditional databases (PostgreSQL, SQL Server), Massively Parallel Processing (MPP) databases (Redshift), and NoSQL technologies (Hadoop, Spark)
• Develop complex SQL queries and stored procedures/functions for data manipulation and transformation
• Support ETL (Extract, Transform, Load) processes, ensuring data quality and integrity
• Implement DevOps practices and automation techniques to optimize data operations
• Orchestrate server environments using tools such as Puppet and Ansible
• Collaborate with data scientists, database architects, and business users to develop data processing use cases
• Develop and document service APIs for data collection, cleansing, and storage
• Work with business intelligence tools to develop data visualization solutions
• Ensure the complete Software Development Lifecycle (SDLC) process, including writing requirements, implementation, testing, documentation, and deployment of data solutions
• Troubleshoot and optimize database performance and configurations
• Support Microsoft Access frontend development and integration

Preferred Qualifications

• Experience in database configuration, troubleshooting, and optimization
• Experience in developing and deploying APIs for data integration and processing
• Knowledge of data warehouse development and operations
• Familiarity with tools such as SQL PowerArchitect for database and data model development
• Strong problem-solving skills and the ability to work in a fast-paced environment

Benefits

Remote Salary Range $125 — $135 USD