Job Description
Data Architect/Modeler
Is this the role you are looking for If so read on for more details, and make sure to apply today.
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.
About Us:
Founded in 2005, Amex Systems Inc. has evolved into a pioneer in technology and process consulting, with a focus on delivering robust software development and affordable business solutions. Headquartered in Dallas, Texas, with additional operations in Detroit, Michigan, and nearshore centers in Canada and Mexico, Amex Systems stands as a leader in the IT industry.
AMEX SYSTEMS INC
38345 W 10 Mile Rd Suite 146 Farmington Hills, MI- 48335
Job Tags