Data Engineer

Amatriot Group, LLC; United States; On-site; USD 125,000 - 150,000; Full time

Job summary

Amatriot Group, LLC in Washington, DC is seeking a data analytics professional with TS-SCI clearance to design and deliver self-service analytics solutions. You will gather, clean, and validate data from multiple sources, build interactive Kibana dashboards, and communicate findings to stakeholders.

Requirements include a Bachelor's degree (or equivalent) with 8+ years of experience, active TS-SCI clearance, experience with Python, SQL, ETL, and data modeling, plus strong collaboration and

Qualifications

• Bachelor's degree in a technical field with 8+ years of related experience.
• Active TS-SCI clearance.
• Willingness to complete additional screenings during employment.
• Current security certification or higher-equivalent.
• Demonstrable experience designing dashboards with Kibana.
• Hands-on data cleaning, transformation and analysis using Python, SQL, or R.
• Strong understanding of data modeling, ETL processes and pipeline development.
• Ability to translate business requirements into technical solutions and actionable insights.
• Excellent communication for diverse audiences and stakeholders.
• Experience with Git and collaborative development environments.
• Strong attention to data quality and reliability.

Responsibilities

• Gather, clean and validate data from multiple sources for accuracy and usability.
• Analyze complex datasets to identify trends and insights.
• Design interactive Kibana dashboards and visualizations for stakeholders.
• Apply UI/visual design concepts to data visuals and ensure accessible layouts.
• Translate analytical results into actionable recommendations for technical and non-technical audiences.
• Engage with stakeholders to understand business needs and data requirements.
• Refine and maintain data transformation pipelines ensuring data quality and alignment with business logic.
• Develop self-service analytics tools and reusable data assets for end users.
• Document data models, business logic, transformations, and analytics workflows.
• Collaborate with data engineers, analysts, and other stakeholders to deliver integrated data solutions.

Education

Bachelor's degree in a technical discipline

8+ years of relevant experience

Tools

Kibana

Python

SQL

Git

ETL

Data modeling

Pandas/Numpy

R

Elasticsearch/ELK

Job description

Location

Washington DC 100 Onsite Clearance Top SecretSCI

Job Type

Full time

Target Salary Range

125000 150000

Key Responsibilities

• Gather clean and validate data from multiple sources to ensure accuracy consistency and usability
• Analyze complex datasets to identify trends patterns and insights that answer operational and business questions
• Design and develop interactive dashboards reports and visualizations using Kibana as the primary tool ensuring findings are communicated clearly and effectively to stakeholders
• Applying the basics of visual design ie UI principles in their design work such as visual hierarchy proximity similarity font selection and color theory and demonstrate an understanding of visual layout content organization and accessibility guidelines
• Translate analytical results into actionable recommendations and present findings to technical and non technical audiences
• Engage with stakeholders to understand business needs operational challenges and data requirements
• Refine and maintain data transformation pipelines ensuring data quality reliability and alignment with business logic
• Develop and maintain self service analytics tools and reusable data assets to empower end users
• Document data models business logic transformation processes and analytics workflows for transparency and knowledge sharing
• Work closely with data engineers business analysts and other stakeholders to deliver integrated data solutions

Qualifications

• Bachelors degree in Computer Science Data Science Engineering Mathematics Statistics or related technical discipline and 8 years of relevant experience
• Addl experience may be considered in lieu of degree
• An active TSSCI clearance
• Willingness to complete and maintain additional customer suitability screenings throughout employment
• Current Security certification or higherequivalent
• Demonstrable experience designing and building data visualizations and dashboards using Kibana
• Hands on experience with data cleaning transformation and analysis using tools such as Python pandas numpy SQL or R
• Strong understanding of data modeling ETL processes and data pipeline development
• Ability to translate business requirements into technical solutions and actionable insights
• Excellent communication skills with the ability to present complex data findings to diverse audiences
• Experience with version control systems eg Git and collaborative development environments
• Strong attention to detail and commitment to data quality and reliability
• Strong communication and documentation skills for collaboration and knowledge sharing
• Experience in application integration design and strong communication skills for collaboration with virtual teams

Preferred Qualifications

• Experience with Elastic Stack Elasticsearch Logstash Kibana for data analysis and visualization
• Experience with other data visualization tools such as Tableau Power BI Grafana or similar
• Experience developing self service analytics solutions and reusable data assets
• Familiarity with Agile methodologies and project management tools eg JIRA Confluence
• Experience with cloud based data platforms AWS Azure GCP and big data technologies
• Knowledge of data governance security and compliance best practices
• Experience documenting data models business logic and transformation processes
• Experience working in mission driven or operational environments
• Experience developing and deploying software in a DoD environment DISA experience is a plus
• Experience with DISA and DoD Networks
• Understanding of network routing devices and network device configurations
• Experience with text mining tools and techniques including ELK Stack for summarization search and entity extraction
• Familiarity with CICD techniques containerized pipelines and DevOps practices
• Familiarity with Kubernetes deployment Agile methodologies and tools
• Familiarity with AWS GovCloud and cloud infrastructure including networking and security policies
• Experience with Agile methodologies and related tools
• Experience with Atlassian tools including JIRA and Confluence
• Strong understanding of Agile methodologies including Scrum and SAFe
• Experience working remotely with a geographically dispersed team
• Excellent communication and collaboration skills with the ability to engage with customers stakeholders team members