Creative Information Technology, Inc.

Creative Information Technology, Inc.

Data Engineer - Baltimore City, MD

Falls Church, Virginia

Sponsorship not specifiedDetected 83 days ago
PythonJavaScalaSQLSnowflakeRedshiftAWSTerraformCI/CDSparkAirflowData EngineeringStatisticsComplianceAuditingCustomer SupportHIPAAHL7/FHIREHR/EMRCollaboration

Stay score

odds of building a lasting career here

37Risky
Cap-exempt (no lottery)0
Sponsors this role80
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70

Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Employer immigration record

from this employer's Department of Labor filings

Files H-1B transfers

2 transfer filings in the last year, covering 2 workers. Median labor-condition decision: 38 days. An employer that already files transfers is one that can take over an existing H-1B.

Sourced from Department of Labor LCA, PERM and prevailing-wage disclosure data. Employer matching is by name, so figures may be split across an employer's legal entities. Absence of a filing means none appears in our copy of the data, not that none exists.

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • We serve both government and commercial sectors, offering a range of solutions such as Healthcare IT, Human Services, Identity Credentialing, Cloud Computing, and Big Data Analytics.
  • With clients in the US and abroad, we hold key contract vehicles including GSA IT Schedule 70, NIH CIO-SP3, GSA Alliant, and DHS-Eagle II.
  • Join us in driving growth and seizing new business opportunities.

Requirements

  • The candidate should have experience as data engineer or similar role with a strong understanding of data architecture and ETL processes.
  • This position requires a bachelor's or master's degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or a related field.
  • Three (3) years of equivalent experience in a related field may be substituted for the Bachelor's degree.
  • Proven experience with Apache Spark (PySpark) for large-scale processing.
  • Hands-on experience with AWS Glue, S3, Redshift, Athena, EMR, Lake Formation.
  • Hands-on experience with Iceberg, Delta Lake, or other OTF table formats.
  • Experience with Airflow or other pipeline orchestration frameworks.
  • Practical experience in CI/CD and Infrastructure-as-Code (Terraform, CloudFormation).
  • Practical experience with EDI X12, HL7, or FHIR data formats.
  • Strong understanding of Medallion Architecture for data lake houses.

Nice to have

  • Strong coding skills in Python and SQL (Scala or Java a plus).

Company info

  • Creative Information Technology Inc (CITI) is an esteemed IT enterprise renowned for its exceptional customer service and innovation.
  • Client is seeking a hands-on Data Engineer to design, develop, and optimize large-scale data pipelines in support of our Enterprise Data Warehouse (EDW) and Data Lake solutions.
  • This role requires deep technical expertise in coding, pipeline orchestration, and cloud-native data engineering on AWS.
  • The Data Engineer will be directly responsible for implementing ingestion, transformation, and integration workflows - ensuring data is high-quality, compliant, and analytics-ready.
  • This role may support other projects or teams within MDH as needed.
  • Role and Responsibilities
  • Responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics.
  • The individual is responsible for the following tasks:
  • Design, develop and maintain data pipelines, and extract, transform, load (ETL) processes to collect, process and store structured and unstructured data
  • Build data architecture and storage solutions, including data lakehouses, data lakes, data warehouse, and data marts to support analytics and reporting
  • Develop data reliability, efficiency, and qualify checks and processes
  • Prepare data for data modeling
  • Monitor and optimize data architecture and data processing systems
  • Collaboration with multiple teams to understand requirements and objectives
  • Administer testing and troubleshooting related to performance, reliability, and scalability
  • Create and update documentation
  • Hands-On Data Pipeline Development
  • Design, code, and deploy ETL/ELT pipelines across bronze, silver, and gold layers of the Data Lakehouse.
  • Build ingestion pipelines for structured (SQL), semi-structured (JSON, XML), and unstructured data using PySpark/Python programming language using AWS Glue or EMR.
  • Implement incremental loads, deduplication, error handling, and data validation.
  • Actively troubleshoot, debug, and optimize pipelines for scalability and cost efficiency.
  • EDW & Data Lake Implementation
  • Develop dimensional data models (Star Schema, Snowflake Schema) for analytics and reporting.
  • Build and maintain tables in Iceberg, Delta Lake, or equivalent OTF formats.
  • Optimize partitioning, indexing, and metadata for fast query performance.
  • Healthcare Data Integration
  • Build ingestion and transformation pipelines for EDI X12 transactions (837, 835, 278, etc.).

This listing is sourced directly from Creative Information Technology, Inc.'s careers page and normalized into a canonical job model.