Senior Data Engineer I

Job Description:

We are seeking a highly skilled Senior Data Engineer to join our dynamic team. The ideal candidate will have extensive experience in data engineering, data operations, data analytics, and data management. This role requires hands-on experience with Python or R for data analytics, strong SQL query development skills, and expertise in cloud environments such as AWS. The Senior Data Engineer will be responsible for building scalable data solutions, supporting data pipelines, and collaborating with cross-functional teams to develop efficient data management strategies.

Duties/ 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.

Required Skills/Abilities

• 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

Nice to Have Skills

• 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.

Education and Experience:

• 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.

Travel Requirement:

• None

Clearance Requirement:

• Ability to obtain Public Trust

Dynamo is a full lifecycle digital transformation company providing best-in-class technology and mission support services to our clients. An SBA 8(a) Program participant, Dynamo maintains SBA 8(a) Mentor-Protege Program Joint Ventures, providing us significant scale and further deepening our capabilities. Dynamo's mission is to lead the digital transformation industry and provide best-in-class solutions for our clients with a truly human touch.

We leverage industry leading practices to empower our clients, ultimately providing them with the necessary tools, knowledge, and information required to successfully achieve their strategic goals, while optimizing their operations.

Through our partnerships, boldness, and authenticity, Dynamo goes against the grain of a traditional government contracting company by providing top-caliber team members, delivering quality results, and always exceeding expectations.

Dynamo Technologies is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.