Data Integration Automation Engineer
Data Integration Automation Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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 credentialbased 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 credentialprotected 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 thirdparty and internal credentialbased systems.
- Establish and manage secure authentication mechanisms including OAuth API keys and other credentialbased 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 problemsolving skills and ability to work independently in a fastpaced environment.
- Active Q or TS clearance
LOCATION: This is an onsite position in Albuqurque NM.
SALARY: Salaries are determined based on several factors including external market data internal equity and the candidates related knowledge skills and abilities for the position.
BENEFITS
- Employer Paid High Quality Employee Medical Dental & Vision Care
- LowCost Family Health Care offered
- 11 Federal Holidays and 3 weeks vacation
- 401k with Generous Employer Match
- Crosstraining opportunities
About MELE
With over 300 employees and offices in Rockville MD Washington DC and Albuquerque NM MELE is a veteran and minorityowned 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. MELEs 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 EVerify
Employment Type
Full-Time
