Data Architect

Job Summary:

Dexian is seeking a Data Architect for an opportunity with a client located in Chicago, IL.

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

Requirements:

• 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:
  o Data Analysis / Profiling - Python (Jupyterlab, PyCharm,etc), Toad, MySQL
  o Data Platforms - Hadoop, Spark, Oracle, Exadata, SQL Server, DB2, MongoDB, Teradata, Splunk
  o Data Transformation - Informatica, SSIS, Alteryx, Trifacta
  o 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

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.