CTI Consulting

Data Engineer 182124

CTI Consulting Smithfield, Rhode Island, United States

Public Safety · 11-50 employees

Nov 10
data-engineer Principal (10+ yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Design, develop, and maintain complex data pipelines and multi-tier applications using cloud-native technologies. Orchestrate data transformation processes and ensure operational efficiency across heterogeneous data platforms.

What they look for

Python SQL Snowflake AWS Apache Airflow Docker CI/CD ETL Pipelines PostgreSQL Oracle Jenkins GitHub Data Engineering Cloud Architecture Shell Scripting Agile

Requirements

Requires over 10 years of full-stack development experience and strong proficiency in Python, SQL, and AWS cloud services. Candidates must have hands-on experience with ELT/ETL pipelines, containerization, and CI/CD automation.

Full description

The Expertise and Skills You Bring

Education & Experience

· Bachelor’s degree, preferably in Engineering or Business.

· 10+ years of full stack development experience with architecting, designing, developing, maintaining multi-tier applications and database.

· Hands on experience with relational SQL and NoSQL databases, including Snowflake, Oracle, RDS Postgres, DynamoDB and Redshift.

· Strong expertise with the following desired skills: Python, SQL, Shell, Cloud (AWS), Angular, Javascript, NodeJs and Test and Deployment technologies.

· Hands-on experience with API design & development, AWS (Cloud) Development/Migration, Data Design, Batch Processing, Workflow/Process Automation and UI

· Cloud skills working with AWS EKS/ECS and AWS handled solutions such as Lambda, SQS, EC2, S3, CloudWatch and IAM roles/policies.

· Proficiency in building data engineering pipelines.

· Experience using logging/observability tools such as Datadog, Splunk and AWS Cloud watch

· Strong CI/CD skills including full scale security and quality testing, build and deployment automation.

· Data visualization and ability to synthesize data for actionable business insights using tools, Tableau, OBIEE, CRM Analytics, Power BI, Alteryx, Apache Airflow

· Experience in building application in Salesforce using force.com, lightning, aura.

· Excellent analytical, communication and preparation skills and the ability to run with multiple tasks at a given time.

· Proficient with Agile methodologies.

Required Technical Expertise (Must Have)

· Strong hands-on experience building and maintaining ELT/ETL pipelines to move and transform data across heterogeneous data platforms, including Snowflake, Oracle, and PostgreSQL.

· Deep understanding of data structures, relational databases, and cloud-native storage technologies across Snowflake, Oracle, Postgres, and other cloud-based RDBMS platforms.

· Proficiency in Python and SQL, with practical experience using scripting languages such as Shell and Groovy for automation and data processing.

· Proven experience designing, implementing, and orchestrating complex data pipelines using Apache Airflow and/or Control?M, with a focus on scalability, reliability, and operational efficiency.

· Hands-on expertise with Docker, including container image creation, multi-stage builds, container registries, and secure, scalable container-based deployments.

· Strong experience implementing CI/CD pipelines using GitHub and Jenkins, including automated builds, testing, deployments, and adherence to security and quality procedures.

Cloud & Platform Experience

· Proven understanding of core AWS services, including Lambda, SQS/SNS, EC2, S3, CloudWatch, and IAM roles/policies, supporting data and application workloads in cloud environments.

Preferred / Nice to Have

· Exposure to modern front-end and application development technologies such as Angular, Node.js, and TypeScript.

· Experience working with additional cloud-native databases such as AWS DynamoDB.

· Familiarity with Go (Golang) for backend or data platform development.

· Broader experience supporting data solutions across PostgreSQL and AWS-based architectures.

Similar roles