Cloud Data Architect

You…

As Cloud Data Architect, you will provide design and architecture help and lead a Data migration project to our government customer . You will work with varying huge data sources with different schemas and data elements to produce an effective and efficient Data Lake solution. You have an eye for spotting data correlations and a desire to dig into large datasets to find technical solutions and deliver business value. This is a hands-on position that requires both technical and client-facing skills to lead data pipeline design and implementation, integration with structured and semi-structured data sources, data lake design and implementation, integration of disparate data technologies and technical writing skills. Must be proactive and a motivated self-starter.

Program Mission…

The program you will be supporting has a mission to provide development, security, and operations (DevSecOps) support to U.S. Citizenship and Immigration Services (USCIS) with a focus on development, operations, and modernization of the Agency’s Enterprise Data Warehouse/Data Lake. The team utilizes open-source, AWS Cloud, and Big Data technologies and modern DevSecOps delivery to meet the reporting, data analytics, and machine learning/artificial intelligence needs critical to USCIS leadership, data/business analysts, data scientists, and other decision-makers.

Responsibilities…

· Interact with designated product owners, system owners, and source system business owners to understand transactional system data models and elicit requirements and logic for ETLs

· Develop ETL workflows/data pipelines to ingest data using AWS Data Migration Service (DMS), Scala, Kafka, Restful APIs, and other technologies as determined by the client from multiple transactional systems to the target (including ODS, data marts, and data lake) according to documented logic and source-to-target mappings

Required Skills

· 5+ years of experience with ETL development ingesting data from diverse and huge data sources

· 5+ years of experience with programming languages such as Java, Scala, Python, R, JSON Schema

· Experience with AWS Database Migration Service (DMS), Databricks/Apache Spark, and/or Kafka experience

· 5+ years of experience producing and consuming Rest APIs.

· 5+ years of experience with relational databases /RDS.

· Demonstrated experience in a Data Warehouse/Data Lake

· Ability to write complex SQL queries and scripts

· Strong teamwork, co-ordination, planning and influencing skills

· Self-driven with the ability to adapt quickly, work in a challenging and fast paced environment within cross-functional teams, and to promote creative problem solving within their team

· Experience with Agile development practices, including Scrum and Kanban, and management tools (e.g., Jira, Confluence)

· Experience with GIT and branching strategies

· Experience with engineering/DevOps tools (i.e. Jenkins)

· Excellent analytical, communication and organizational skills

· Experience working in AWS Cloud environment

· Experience with Microsoft Office Suite including Excel, PowerPoint, and Visio

Desired Skills

· Experience supporting DHS Agencies.

· Providing IT security engineering for systems deployed in AWS and GCP in addition to Azure is a plus.

· Ability to demonstrate and explain technical concepts to both technical and non-technical audiences

· Able to clearly communicate with both customers and teammates and provide recommendations for improvements to existing software applications

· Experience working in an agile development environment

Education: Bachelor’s degree in a technical discipline preferred – Computer Science, Mathematics, or equivalent technical degree, or the equivalent combination of education, professional training, and work experience.

Clearance: Must be a US Citizen and be able to obtain a government agency Suitability Clearance. USCIS Entry on Duty (EOD) preferred.

Zen Strategics is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.