Data Architect

Dexian

Chicago, IL • On-site

$65.75 - $84.50/hr

Full-time

Posted 29 days ago


Job description

Job Summary:
Dexian is seeking a Data Architect for an opportunity with a client located in Chicago, IL.
Responsibilities:
  • Responsible for the execution of data architectural solutions for complex initiatives that span multiple Lines of Business and control functions
  • Facilitating solution driven discussions, working with stakeholders to support adherence to the enterprise data management policy and standards, and supporting architecture design reviews to ensure integration of data architecture principles in technology solutions
  • Job expectations include educating data management teams on enterprise data architectural principles and data management processes and routines
  • Designing secure and scalable architecture solutions to safeguard our organization's critical information assets
  • Work closely with cross-functional teams to ensure that data-centric security measures align with business needs and compliance requirements
  • Possess in-depth knowledge of cybersecurity principles, data management best practices and have a proven track record of successfully implementing a monitoring and logging strategy in both structured and unstructured data within a big data environment

Requirements:
  • Expertise in major cloud platforms such as AWS, Azure, and Google Cloud Platform (GCP)
  • Hands on experience working with or implementing data fabric technology (Starburst)
  • Working knowledge of the Open Cybersecurity Schema Framework (OCSF)
  • Bachelor's or master's degree in Computer Science, Information Technology, or related field
  • 5+ years proven experience as a Data Architect or similar role with a focus on designing and implementing complex data architecture
  • Strong knowledge of data management principles, data modeling techniques and data integration patterns
  • In-depth understanding of data security, data privacy, and data governance concepts
  • Hands on experience with data modeling tools (SAP PowerDesigner, Erwin Data Modeler), database management systems, big data environments and ETL tools
  • Excellent problem-solving skills and the ability to analyze complex data related challenges
  • Strong communication and collaboration skills to work effectively with cross-functional teams
  • Project management experience with the ability to handle multiple initiatives concurrently
  • 5-10+ 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 are a must
  • Thorough understanding of real time, batch, and event-based data provisioning
  • Hands on experience in ETL/ELT and API based data provisioning patterns
  • Needs to be a skilled communicator with tools like Visio, PowerPoint, and be able to quickly put together and present ideas to large groups clearly and effectively
  • Strong Excel skills experience working with large amounts of data, conducting analysis and present findings
  • 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
  • Databases: Relational, Warehouse, Graph, Key-Value, Document, In-Memory, Caching, Wide-Column, Time-Series, Ledger
  • Data Transformation - Informatica, SSIS, Alteryx, Trifacta
  • BI - Tableau, Microstrategy, metadata/lineage tools, Distributed Caching tools
  • In-depth understanding of Data Governance process - identify critical data elements, metadata, data lineage, data dictionary, data model, Data Sharing Agreements, Service Level Agreements, Data Management Standards
  • 5+ 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

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.
Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/ .
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.



Frequently asked questions

Q: What skills or qualities help someone succeed as a Data Architect?

A: To succeed as a Data Architect, key technical skills include proficiency in data modeling, database design, and data warehousing, as well as expertise in data management tools such as ETL (Extract, Transform, Load) software and data governance platforms. Additionally, strong analytical and problem-solving skills, along with the ability to communicate complex technical concepts to non-technical stakeholders, are essential soft skills for this role. By combining these technical and soft skills, Data Architects can effectively design and implement data systems that support business growth and drive informed decision-making.

Q: What is the career path for a Data Architect?

A: A Data Architect's typical career progression involves starting as a Junior Data Architect or Data Analyst, where they develop foundational skills in data modeling, database design, and data warehousing. As they gain experience, they move into mid-level roles such as Senior Data Architect or Data Governance Lead, where they oversee data strategy, architecture, and compliance. Ultimately, senior Data Architects can transition into leadership positions like Chief Data Officer or Director of Data Engineering, where they drive organizational data vision and strategy.\n\nKey opportunities for skill development and professional growth in this role include learning cloud-based data platforms, advanced data modeling techniques, and data governance frameworks, as well as staying up-to-date with emerging technologies like artificial intelligence and machine learning. \n\nLong-term career prospects for Data Architects may include transitioning into leadership roles, pursuing specialized roles like Data Scientist or Business Analyst, or exploring adjacent fields like IT Consulting or Business Intelligence.



Dexian job posting for a Data Architect in Chicago, IL with a salary of $66 to $85 Hourly with a map of Chicago location.