Data Engineer / Data Systems Engineer

Senior and Journey-Level Data Engineer/Data Systems Engineer

CIYIS is seeking both a Senior and a Journey-level Data Engineer/Data Systems Engineer to join our team in support of tour client. These full-time roles will contribute to the development and maintenance of data processing software, data infrastructure, and data governance initiatives. The ideal candidates will bring a strong background in data engineering, database development, and spatial data management.

Key Responsibilities

• Develop data models, database schemas, data pipelines, and perform data migration activities.

• Maintain expertise in SQL and Python programming for databases including Microsoft SQL Server and PostgreSQL.

• Understand and manage enterprise-level spatial data within RDBMS and geodatabases.

• Create and monitor data migration plans, documenting key activities and risks.

• Build infrastructure for optimal data extraction, transformation, and loading using Cloud and SQL technologies.

• Perform data quality analysis and implement business and quality rules.

• Design and implement quality management processes for data migration validation.

• Identify and implement internal process improvements for scalability and automation.

• Assist stakeholders with data-related technical issues and infrastructure needs.

• Propose system modifications and create reports and presentations based on findings.

• Structure data sets for efficient retrieval and perform data requests as needed.

• Define and maintain domain definition requirements for data attributes.

• Collaborate with analysts, DBAs, GIS specialists, and others to support data governance.

• Develop and document metadata records for data systems and standards.

Key Qualifications

• Education: Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.

• Experience: 3–7 years of hands-on experience in data engineering, data systems development, or related roles.

• Technical Skills: Proficiency in SQL, Python, and ETL frameworks (e.g., Apache Airflow, dbt, Talend); Experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server) and NoSQL databases (e.g., MongoDB, Cassandra); Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services (e.g., Redshift, BigQuery, Azure Synapse); Strong understanding of data modeling, data warehousing, and data lake architectures; Experience building and maintaining data pipelines for batch and real-time processing using tools like Apache Kafka, Spark, or Flink.

• Data Management: Knowledge of data governance, data quality, and metadata management best practices; Ability to design and implement data validation, monitoring, and alerting mechanisms.

• Security & Compliance: Understanding of data security, encryption, and compliance standards (e.g., HIPAA, GDPR, FedRAMP).

• Soft Skills: Excellent problem-solving and debugging skills; Strong communication skills for collaborating with cross-functional teams and documenting technical processes; Ability to work independently and manage multiple priorities in a fast-paced environment.

• Certifications (Preferred): Google Cloud Professional Data Engineer, AWS Certified Data Analytics, or Microsoft Azure Data Engineer Associate.

CIYIS is an Equal Opportunity Employer and all Qualified Applicants will receive consideration for employment without regard to Race, Color, Religion, Sex, National Origin, Disability Status, Protected Veteran Status or any other Characteristic Protected by Law.