Data Consultant

Job#: 3016517

Job Description:

Role: Application Architect

Duration: 10 Months Contract Role

Location: Chicago, IL or Denver, CO (Mandatory of a minimum of 3 days onsite)

Job Description Summary

This job is responsible for the execution of data architectural solutions for complex initiatives that span multiple Lines of Business and control functions. Key responsibilities include 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.

Job Description

We are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.

Position Summary

We are seeking a highly skilled and experienced Senior Data Architect with a strong focus on cybersecurity. As a Senior Data Architect, you will be responsible for designing secure and scalable architecture solutions to safeguard our organization's critical information assets. You will work closely with cross-functional teams to ensure that data-centric security measures align with business needs and compliance requirements. The ideal candidate will 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.

Required skills

Expertise in major cloud platforms such as AWS, Azure, and Google Cloud Platform (Google Cloud Platform)

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. Or equivalent experience.

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

Desired Skills:

Opens Cybersecurity Schema Framework (OCSF)

Common Information Models (CIM)s

ServiceNow

Hybrid data mesh + data fabric fluency, Starburst/Trino

Lakehouse foundations open table formats

Event streaming CDC

Vector search RAG data design

LLMOps integration for data

AI governance standards

Operational data governance privacy

End to end lineage standards

Data contracts domain data products

Data/AI observability

Zero Trust data architecture

Data Profiling, Data Cleansing, Data quality controls, Data Visualizations

Dimensional, Data Vault, Anchor and semantic modeling

Metadata, Lineage, Data Catalogs

Data Build Tool (dbt)

Knowledgeable in Cybersecurity, Audit and regulatory concerns.

Experience with next generation tools and technologies is a plus (AI/ML, RPA etc.)

Industry certifications such as Certified Data Management Professional (CDMP) or TOGAF are a plus

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.