Senior Data Engineer
Job Description
LMI is seeking a Senior Data Engineer to support an Intelligence Community client. In this role, you will develop and maintain applications and data pipelines that integrate, structure, and analyze complex information, with an emphasis on turning data into usable products for both technical and non-technical stakeholders.
This onsite position is based in Reston, VA, and it requires an active TS/SCI clearance with CI Polygraph. Compensation for the role is USD 180,000 - 220,000 per year.
Responsibilities
- Define and develop techniques to integrate, consolidate, and structure data for functional workflows and analytical use
- Understand complex, organization-specific datasets
- Produce dashboards and visualizations aligned to complex client requirements
- Conduct root cause analysis, identify errors, and refactor pipelines as needed
- Perform routine and ad hoc analyses based on questions emerging from leveraged datasets
- Develop and improve standard operating procedures
- Collaborate with data analysts and developers to design tools and applications that reduce repeated requests
- Research, analyze, and document the benefits of technical approaches
- Propose alternative designs and processes to manage different types of data using standard and custom tables and fields
- Work effectively in teams and independently
- Support data quality maturation
- Support business process transformation through automation
- Transform data and analysis into informative visualizations and interactive dashboards using open-source and commercial tools
- Advise non-technical customers on how to interpret and use dashboards, reports, and data analysis products
- Assist junior teammates through technical mentoring and code review
Requirements
- Bachelor’s degree in science, engineering, mathematics, computer science, information systems, data analytics, or another related business or quantitative discipline
- 15+ years of experience in data engineering or a related field
- Experience with ETL process concepts and execution
- Knowledge and experience manipulating and joining data from multiple sources and in multiple formats
- Ability to query datasets across multiple sources, knowledge of data refresh methodologies, and ability to leverage data models
- High-level competency with data engineering coding languages such as SQL and Python
- Self-starter mindset with the ability to independently identify improvement opportunities through data analytics
- Positive team collaboration in a dynamic environment
- Excellent communication skills (written and oral)
- Proven ability to work with both business customers and technical teams
- Strong organization skills and ability to manage multiple projects simultaneously
- Excellent customer relationship management skills
- Innovative problem-solving and ability to thrive in a fast-paced environment
- Ability to work on client site in the NCR in Washington, D.C.
- Active TS/SCI with CI Polygraph required
- Applicants must meet U.S. Government security clearance eligibility requirements; only US Citizens are eligible for a security clearance
- LMI will only consider applicants with security clearances or applicants eligible for security clearances due to the nature of the work
Technologies
- SQL
- Python
- Tableau
- Qlik
- Power BI
- RShiny
- plotly
- d3.js
- Git
Desired Qualifications
- Master’s degree or higher
- Experience developing dashboards using Tableau, Qlik, Power BI, RShiny, plotly, or d3.js
- Experience with version control software such as Git
- Experience with Agile development
- Management consulting experience desired
- Security clearance eligibility requirements apply (only US Citizens are eligible); LMI will consider applicants with current clearances or eligibility for clearances