What are the responsibilities and job description for the Data Integration & Automation Engineer position at MELE Associates, Inc.?
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.
Education & Experience:
- 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.
MINIMUM QUALIFICATIONS
- 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
