What are the responsibilities and job description for the Data Architect position at Ionidea?
Job Description
Must be local to one of these The Client Group locations: Morris Planes, NJ, St. Louis, MO, Austin, TX, Minneapolis, MN
Provides expert content/professional leadership on complex Technical Strategy & Architecture assignments/projects. Undertakes complex projects requiring additional specialized technical knowledge. Makes well-thought-out decisions on complex IT architecture issues. Coordinates with users to determine requirements. Ensures that system improvements are successfully implemented and monitored to increase efficiency. Monitors project schedules and costs. Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives. Uses deep professional knowledge and acumen to advise functional leaders. Focuses on providing thought leadership within Architecture but works on broader projects, which require understanding of wider business. Recognized internally as a subject matter expert.
Ability to perform conceptual, solution and technical data platform architecture on cloud, on-premise, on-premise to cloud and cloud to on-premise environments focusing on AWS and Databricks environments
The majority of this documentation will be delivered through Confluence; extremely capable of creating
Experience with data migration from on-premise to cloud, cloud-to-cloud, and cross-cloud environments, migrating data between:
On-premise Hadoop and cloud relational databases On-premise Hadoop and Delta Lake entities Teradata Teradata Vantage and Delta Lake data structures
Teradata – TDUtils, Querygrid external data connectors, transports
Delta Lake entities and Snowflake databases
Hands-on experience with Databricks along with an understanding of Unity Catalog, how it integrates with Otka and active directory structures, and how column and row based filtering might be managed Understand the difference and purpose of different data lake table formats such as Iceberg, Delta Lake and Hudi, and how data inserts and updates are accomplished by each Experience with integrating metadata from data architectures into data catalogs, data governance tools and/or data lineage
Skills:
Primary: Databricks, AWS S3, AWS VPC, Kafka, AWS data solutions, Confluence
Secondary: Snowflake, SQL Server, Oracle, Postgres, Redshift, RDS, graph databases, Starburst or Denodo, Collibra, Alation
Salary : $75 - $85