Application Architect III

3 days ago Be among the first 25 applicants

Position type:
Contract
• Duration: 12 months
•

Location:

Chicago, IL or Denver, CO

As a Data Architect with cybersecurity you will design secure and scalable architecture solutions to safeguard our organization’s critical information assets. You will work closely with cross‑functional teams to ensure that data‑centric security measures align with business needs and compliance requirements. The ideal candidate will possess in‑depth knowledge of cybersecurity principles, data management best practices, and have a proven track record of successfully implementing a monitoring and logging strategy in both structured and unstructured data within a big data environment.

• Expertise in major cloud platforms such as AWS, Azure, and Google Cloud Platform (GCP)
• Hands‑on experience working with or implementing data fabric technology (Starburst)
• Working knowledge of the Open Cybersecurity Schema Framework (OCSF)
• Bachelor’s or master’s degree in Computer Science, Information Technology, or related field. Or equivalent experience.
• 5+ years proven experience as a Data Architect or similar role with a focus on designing and implementing complex data architecture.
• Strong knowledge of data management principles, data modeling techniques and data integration patterns.
• In‑depth understanding of data security, data privacy, and data governance concepts.
• Hands‑on experience with data modeling tools (SAP Power Designer, Erwin Data Modeler), database management systems, big data environments and ETL tools.
• Excellent problem‑solving skills and the ability to analyze complex data‑related challenges.
• Strong communication and collaboration skills to work effectively with cross‑functional teams.
• Project management experience with the ability to handle multiple initiatives concurrently.
• 5‑10+ years experience in relational and dimensional data modeling as well as metadata build and management.
• Hands‑on expertise in relational and NOSQL database systems. Strong SQL and Python skills are a must.
• Thorough understanding of real‑time, batch, and event‑based data provisioning.
• Hands‑on experience in ETL/ELT and API‑based data provisioning patterns.
• Needs to be a skilled communicator with tools like Visio, PowerPoint, and be able to quickly put together and present ideas to large groups clearly and effectively.
• Strong Excel skills; experience working with large amounts of data, conducting analysis and presenting findings.
• Hands‑on design and implementation experience with one or more of the following data tools:
• Data Analysis / Profiling – Python (Jupyter, PyCharm, etc.), Toad, MySQL
• Data Platforms – Hadoop, Spark, Oracle, Exadata, SQL Server, DB2, Mongo
  
  DB, Teradata, Splunk
• Databases – relational, warehouse, graph, key‑value, document, in‑memory, caching, wide‑column, time‑series, ledger
• Data Transformation – Informatica, SSIS, Alteryx, Trifacta
• BI – Tableau, Micro Strategy, metadata/lineage tools, distributed caching tools.
• In‑depth understanding of Data Governance process – identify critical data elements, metadata, data lineage, data dictionary, data model, data sharing agreements, service level agreements, data management standards.
• 5+ years experience with data quality measurements/scorecards, control, remediation along with data reconciliation techniques.
• Able to independently architect solutions, lead code reviews and ensure quality throughout the life of each project.
• Experience working as part of the Agile team and using Agile SDLC tools.

• Open Cybersecurity Schema Framework (OCSF)
• Common Information Models (CIM) s
• Service Now
• Hybrid data mesh + data fabric fluency, Starburst/Trino
• Lakehouse foundations open table formats
• Event streaming CDC
• Vector search RAG data design
• LLM Ops integration for data
• AI governance standards
• Operational data governance privacy
• End‑to‑end lineage standards
• Data contracts, domain data products
• Data/AI observability
• Zero Trust data architecture
• Data Profiling, Data Cleansing, data quality controls, data visualizations
• Dimensional, Data Vault, Anchor and semantic modeling
• Metadata, Lineage, Data Catalogs
• Data Build Tool (dbt)
• Knowledge ab…