W2 -- Data Architect/Modeler -- Charlotte, NC and Addison, TX (3 days onsite 2 days remote)

Data Architect/Modeler -- Charlotte, NC and Addison, TX (3 days onsite 2 days remote)

Must Have Skills :

Data Architecture
Data Modeling
Strong SQL and Python skills a must

Responsibilities:

• Defines, creates, and enhances data models for operational and reporting needs for specific domains.
• Understands and collaborates with lines of business to map business processes to data models.
• Defines and analyzes data requirements.
• Design logical and physical data structures that support the requirements.
• Ensures adherence to the enterprise data movement, quality, and accountability standards in technology.
• Conducts data driven analyses of usage of detailed data elements across the business domain to provide optimal data provisioning patterns across the application space.
• Responsible for independently conducting quantitative analytics.
• Assists in development of new models, analytic processes, and system approaches.
• Assists in performing current state data architecture and tooling assessment across all data domains supported by control functions.
• Design conceptual structures and plans to meet the current and future state data requirements.
• Develop and maintain the strategic business data model.
• Analyze and align with other business models.
• Define and maintain the blueprint for managing data assets. Map relationships between data, process, business, system, and technology.
• Assists in establishing capabilities framework for varies data tools.

Required Skills:

• 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.