Senior Data Engineer
Job Description
LMI is seeking a Senior Data Engineer to support an Intelligence Community client in Reston, VA (onsite). In this role, you will build and maintain applications and data pipelines that integrate, structure, and enable analysis of complex, organization-specific information.
This position focuses on turning data into usable workflows, improving data quality, and delivering dashboards and visualizations that support both technical teams and non-technical stakeholders. You will also mentor teammates and help drive process automation through data engineering practices.
Responsibilities
- Define and develop techniques to integrate, consolidate, and structure data for functional workflows and analytical use
- Work with complex, organization-specific datasets to support client requirements
- Produce dashboards and visualizations tailored to complex client needs
- Perform root cause analysis to identify errors, then refactor pipelines as needed
- Conduct analyses to answer routine and ad hoc questions based on leveraged data
- Develop and improve standard operating procedures
- Collaborate with data analysts and developers to design tools and applications that reduce repeat-request response time
- Research, analyze, and document the benefits of various technical approaches
- Propose alternative designs and processes to manage different types of data using standard and custom tables and fields
- Work effectively both in teams and independently
- Support the maturation of data quality
- Support transformation of business process through automation
- Transform data and analysis into informative visualizations and interactive dashboards using open-source and commercial visualization and dashboard tools
- Advise on the interpretation and use of data products, dashboards, and reports for non-technical customers
- Assist junior teammates through technical mentoring and code review
Requirements
- Bachelor’s degree in science, engineering, mathematics, computer science, information systems, data analytics, or other related business or quantitative discipline
- 15+ years of experience in data engineering or a related field
- Experience with ETL process and concepts
- Knowledge and experience manipulating and joining data from various sources and in various formats
- Ability to query datasets from multiple sources, knowledge of data refresh methodologies, and ability to leverage data models
- High-level competency in data engineering coding languages such as SQL and Python
- Self-starter mindset with the ability to identify opportunities for improvement through data analytics
- Positive team approach in a dynamic environment
- Excellent communication skills (written and oral)
- Proven ability to work with business customers and technical teams
- Highly organized with the ability to manage multiple projects simultaneously
- Excellent customer relationship management skills
- Innovative problem-solving skills 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 required with CI Polygraph for the position
- U.S. Citizenship requirement: only US Citizens are eligible for a security clearance. LMI will only consider applicants with security clearances or applicants eligible for security clearances
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
Location: Reston, VA (onsite) | Salary: USD 180,000 - 220,000 per year