The Data Engineer will design, develop, and maintain ETL/ELT pipelines, manage integrations with AWS and Salesforce, and automate data processing workflows.
Intetics Inc., a global technology company providing custom software application development, distributed professional teams, software product quality assessment, and “all-things-digital” solutions, is seeking a highly skilled and experienced Data Engineer to join our dynamic team on a full-time basis.
Responsibilities
- Developing and maintaining ETL/ELT pipelines using AWS Glue
- Using AWS Glue Salesforce connectors to extract and ingest Salesforce data
- Transforming, validating, and enriching data within the AWS data platform
- Loading processed data into Microsoft Dynamics 365 using Glue integrations/connectors
- Designing scalable, resilient, and efficient cloud-based data workflows
- Developing Python scripts and Glue jobs for data processing and automation
- Writing and optimizing SQL queries for data transformation and analysis
- Monitoring and troubleshooting data pipelines and integrations
- Collaborating with engineering, platform, and business teams to deliver integrations quickly and reliably
- Supporting CI/CD processes and deployment automation for data solutions
- Following AWS best practices and Well-Architected principles
Requirements
Must-haves
- Essential Skills & Experience
- Strong hands-on experience with AWS Glue
- Strong experience with AWS cloud services, including: S3, Lambda, Step Functions, CloudWatch, SQS / SNS, ECS
- Experience building ETL/ELT pipelines in AWS environments
- Experience integrating data from Salesforce
- Strong SQL skills
- Proficiency in Python
- Experience processing structured and semi-structured data
- Good understanding of scalable and resilient data architectures
- Experience with CI/CD practices
- Experience working in Agile environments and fast-paced delivery teams
Nice-to-have
- Experience integrating with Microsoft Dynamics 365
- Experience with Terraform and/or CloudFormation
- Experience with Amazon Redshift
- Knowledge of Athena, Kinesis, DynamoDB, and DynamoDB Streams
- Experience building Spark/PySpark data processing jobs
- Understanding of enterprise data governance and compliance standards (GDPR/PECR/DPA)
- AWS certifications
- Experience with enterprise Salesforce implementations
- Experience with CRM migration or synchronization projects
- Exposure to event-driven or streaming-based architectures
- Experience working on cloud-based enterprise data platforms
Similar Jobs
Software
This role supports Supply Chain operations by improving data quality, managing data transformation, and designing data models for visualization.
Top Skills:
Azure Ms SqlMs SqlMs SsasOracle SqlPower BIT-Sql
Information Technology • Software
Design and build real-time data pipelines using ClickHouse and Google Cloud. Focus on data quality and optimize financial datasets for analytics.
Top Skills:
AirflowApache AirflowBigQueryClickhouseGitGCPKafkaKinesisPub/SubPythonSQLTerraform
Information Technology
The role involves designing and developing data pipelines and Lakehouse architectures leveraging Azure Databricks and integrating with SQL Server environments, while ensuring data quality and performance.
Top Skills:
Azure Data FactoryAzure DatabricksDelta LakePysparkSQLSQL Server
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
