Data Architect

Position: Data Architect( Data Modeling)

Position Type: W2-Contract

Hybrid: 3 Days Onsite and 2 Days remote

Locations: Chicago, IL, Denver, CO and Washington, DC

Main Skills: Data Architecture, Data Modeling, Informatica, Python, Business Intelligence, Tableau and Microstrategy.

Job description:

·         3-5 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 a must.

·         Thorough understanding of real time, batch, and event-based data provisioning.

·         Hands on experience in ETL and API based data provisioning patterns.

·         Needs to be a skilled communicator with tools like Vision, PowerPoint, and be able to quickly put together

·         Strong Excel skills experience working with large amounts of data, conducting analysis and present findings

·         3 years of experience as a data architect in a complex data environment

·         3 years domain knowledge of the data domains supported by control functions(Finance, Regulatory Reporting, Compliance, Operational Risk, HR, Legal, Marketing, Audit, etc.) and experience in financial service industry.

·         3 experience with architecture and design of large scale shared data solutions with multiple stakeholders.

·         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

·         Data Transformation - Informatica, SSIS, Alteryx, Trifacta

·         BI - Tableau, Microstrategy, metadata/lineage tools, Distributed Caching tools.

·         Strong knowledge of database modeling principles, techniques, and enterprise data management best practices.

·         Familiar with Data Governance process - identify critical data elements, metadata, data lineage, data dictionary, data model, Data Sharing Agreements, Service Level Agreements, Data Management Standards.

·         1-3 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

Demonstrate strong communication, analytical and organizational skills and strong presentation skills