What are the responsibilities and job description for the Senior Data Architect position at Quadrant IQ Solutions LLC?
Role: Senior Data Architect
Location: Chicago, IL / Denver, CO (Onsite)
Job Type: W2- Submitted to client payroll
Visa's Accepted: H4-EAD, GC-EAD, GC, USC, L2S
Required skills:
• 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)
• Bachelors 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 PowerDesigner, 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 present findings
• Hands-on design and implementation experience with one/more of the following data tools:
• Data Analysis / Profiling - Python (Jupyterlab, PyCharm, etc.), Toad, MySQL
• Data Platforms - Hadoop, Spark, Oracle, Exadata, SQL Server, DB2, MongoDB, 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, Microstrategy, 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 SDLS tools