Data Architect/Modeler at Amex Systems

Data Architect/Modeler

Locations: Chicago, IL

Look for nearby Candidates (W2 only)

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.