Data Integration & Automation Engineer with Security Clearance

We are seeking a highly skilled Data Integration and Automation Engineer to join our team. This role involves developing and maintaining automated processes for extracting, transforming, and reporting data from multiple credential-based systems and databases. The ideal candidate will have experience working with secure APIs, database connections, and automation tools to streamline reporting workflows. ESSENTIAL FUNCTIONS Develop and maintain ETL (Extract, Transform, Load) pipelines to aggregate data from multiple credential-protected systems and databases.
Design and implement automated reporting solutions, ensuring timely and accurate delivery of insights.
Work with RESTful and SOAP APIs to securely pull data from third-party and internal credential-based systems.
Establish and manage secure authentication mechanisms, including OAuth, API keys, and other credential-based access methods.
Write and optimize SQL queries to extract and transform data from relational databases.
Utilize Python, Power Automate, or other scripting tools to automate data retrieval and report generation.
Ensure data integrity and security by following best practices for encryption, access control, and compliance with relevant regulations.
Collaborate with business stakeholders to define reporting needs and optimize data workflows.
Troubleshoot integration issues and continuously improve data pipelines for performance and scalability.
MINIMUM QUALIFICATIONS Bachelor degree in Computer Science, Information Systems, or a related field
5 years experience in data integration, data warehousing, and proficiency in programming languages, as well as expertise with ETL tools and data integration platforms.
Programming & Scripting: Python (e.g., Pandas, Requests), PowerShell, Bash, or equivalent scripting languages
APIs & Integration: RESTful/SOAP APIs, OAuth, API authentication mechanisms
Databases: SQL (PostgreSQL, MySQL, MSSQL), NoSQL (MongoDB, DynamoDB is a plus)
Automation & Workflow Tools: Power Automate, Apache Airflow, AWS Lambda, or equivalent
Data Processing & Reporting: Power BI, Tableau, or equivalent reporting tools
Cloud & DevOps (Preferred): AWS, Azure, GCP, Docker, Kubernetes
Security & Compliance: Best practices for secure data handling and authentication
Version Control & CI/CD: Git
Clearance: Ability to Obtain and keep a Q level clearance
PREFERRED QUALIFICATIONS Experience working with enterprise authentication methods (e.g., SAML, LDAP, SSO).
Familiarity with log aggregation and monitoring tools (e.g., Splunk, ELK Stack).
Experience working with Microsoft applications to centralize use; and pull data sources into data analytic platforms
Background in business intelligence (BI) and analytics.
Strong problem-solving skills and ability to work independently in a fast-paced environment.
Active Q or TS clearance
LOCATION: This is an on-site position in Albuqurque, NM. SALARY: Salaries are determined based on several factors including external market data, internal equity, and the candidate's related knowledge, skills, and abilities for the position. BENEFITS Employer Paid, High Quality Employee Medical, Dental & Vision Care
Low-Cost Family Health Care offered
11 Federal Holidays and 3 weeks' vacation
401k with Generous Employer Match
Cross-training opportunities
About MELE With over 300 employees and offices in Rockville, MD, Washington, DC, and Albuquerque, NM, MELE is a veteran and minority-owned government contractor empowering its customers with innovative solutions for more than three decades. MELE has team members located across the U.S. and has served more than a hundred countries across hundreds of project locations. The company offers technical, engineering, and programmatic support expertise to a host of U.S. federal and international agencies, including, but not limited to, the Department of Energy, the Department of Defense, the Department of Homeland Security, the Department of Justice, INTERPOL, and the International Atomic Energy Agency. MELE's services include National Security and Intelligence, CBRNE Defense and Security, Facility Management and Engineering, Law Enforcement and Emergency Response Training, Technical, Analytica, and Program Management Support, and IT/Cybersecurity. MELE Associates, Inc. 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. MELE Associates, Inc. is an E-Verify