Data Integration Engineer

American CyberSystems
New York, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 136K

Job location

New York, United States of America

Tech stack

Java
JavaScript
API
Airflow
Amazon Web Services (AWS)
Azure
Computer Programming
Databases
Data Architecture
Data Integration
ETL
Data Normalization
Data Retrieval
Data Security
Data Structures
Data Warehousing
Relational Databases
Database Design
Database Queries
JSON
Python
PostgreSQL
Microsoft SQL Server
MongoDB
MySQL
NoSQL
Performance Tuning
Query Optimization
Power BI
SQL Databases
Data Streaming
Systems Integration
Tableau
Talend
Unstructured Data
Data Processing
Scripting (Bash/Python/Go/Ruby)
Google Cloud Platform
Bson
Snowflake
Spark
Indexer
Kafka
Apache Nifi
Data Management
Stream Processing
Data Pipelines

Job description

  • The ideal candidate will have deep experience with MongoDB, along with proficiency in data modeling, query optimization, and performance tuning. You will play a critical role in designing, developing, and maintaining data integration pipelines that support efficient data movement and transformation across multiple systems
  • Design and implement ETL (Extract, Transform, Load) processes to integrate data from diverse sources into MongoDB and other database systems.
  • Develop and optimize MongoDB queries, indexes, and aggregations for performance and scalability.
  • Collaborate with software engineers, data scientists, and business analysts to ensure seamless data flow and integration
  • Implement best practices for database design, data normalization, and denormalization in MongoDB.
  • Monitor, troubleshoot, and resolve performance issues related to database queries, indexing, and sharding.
  • Work with schema design and data modeling for efficient storage and retrieval in MongoDB.
  • Ensure data quality, consistency, and security across integrated systems.
  • Develop and maintain documentation for data pipelines, integrations, and workflows.
  • Stay up to date with MongoDB features, updates, and industry best practices to continuously improve data architecture.

Requirements

  • We are seeking a skilled Data Integration Engineer with expertise in integrating databases, optimizing ETL processes, and implementing best practices for data management., * 3+ years of experience in data integration, ETL development, or database engineering.
  • Strong hands-on experience with MongoDB, including data modeling, indexing, and aggregation framework.
  • Proficiency in ETL tools and frameworks (e.g., Apache NiFi, Talend, Airflow, or custom scripts using Python).
  • Solid understanding of query optimization techniques for high-performance data retrieval.
  • Experience integrating structured and unstructured data from various sources (e.g., SQL, NoSQL, APIs, streaming data). * Strong programming skills in Python, Java, or JavaScript for data processing.
  • Knowledge of cloud platforms (AWS, Azure, GCP) and database scaling strategies.
  • Experience working with JSON, BSON, and document-based data structures.
  • Familiarity with data security, governance, and compliance best practices.

Preferred/Desirable Skill

  • MongoDB certification (e.g., MongoDB Developer or DBA Certification).
  • Experience with data warehousing and BI tools (e.g., Snowflake, Power BI, Tableau).
  • Familiarity with Kafka, Spark, or other real-time data processing frameworks.
  • Knowledge of relational databases (e.g., PostgreSQL, MySQL, SQL Server) and hybrid database architectures

Benefits & conditions

Pay Range: $ 115,500 - 135,500 $ Per Year Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

About the company

ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Recent Recognitions: * Named One of America's Best Employers for New Grads by Forbes (2024 * Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025) * One of the Largest IT Staffing Firms in the US - Ranked #3 by Staffing Industry Analysts (SIA, 2024) * One of the Largest Staffing Firms in the US - Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) * Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) * One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) * AWS Advanced Tier Services Partner with 100+ certifications Website: https://www.innovasolutions.com/ Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [email protected] or (770) 493-5588. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.

Apply for this position