Senior Data Modeler / Data Architect

Innova Solutions has a client that is immediately hiring for a Senior   Data Modeler / Data Architect

Position type : Hybrid Contract

Job Role : Senior   Data Modeler / Data Architect

Job Location(s) : Either Chicago, IL / Washington, D.C. (Hybrid Position!!!)

Job Duration : 12-18 Months contract (Long-Term)

Position Type : Hybrid Contract- (3 days onsite and 2 days remote)

Client Domain : Financial / Banking

• Prefer Locals or Nearby since In-Person interview is required.
• Hiring Manager's Call Notes :

The client needs a Strong Data Modeler who have good communication skills.  Should have good experience in Data Mart, Data Mesh, Data Lake, Data warehousing, ETL, ELT, Database design etc.

Also, Need to be fluent in SQL and should be comfortable with at least one programming language, preferably Python.

Experience designing both relational and dimensional solutions.

Value addition would be the experience with data quality, data governance, Hadoop / Hive, Oracle, Trino / Starburst, Splunk, dbt, Data Vault, medallion architecture, AWS, Cybersecurity data, and OCSF.

Job Description :

Build a Data Architecture for a Cybersecurity team which focuses on leveraging log data and leveraging this data as part of a broad Common Information Model which will be leveraged across the Enterprise.

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.

Desired Skills :

Experience working with large amounts of data, conducting analysis and presenting findings.

Knowledgeable in Audit and regulatory concerns.

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

A bachelors and / or masters degree in computer science or related field

Proficiency using the Data Vault methodology for modeling

Familiarity with ServiceNow Common Services Data Model (CSDM)

Qualified candidates should APPLY NOW for immediate consideration!  Please hit APPLY to provide the required information, and we will be back in touch as soon as possible.

We are currently interviewing to fill this and other similar positions. If this role is not a fit for you, we do offer a referral bonus program for referrals that we successfully place with our clients, subject to program guidelines.   ASK ME HOW.

Thank you!

Sunil Nanda

Innova Solutions Inc.

Tel : ( 1) 585-625-4173

Email ID : suni.nanda@innovasolutions.com

PAY RANGE AND BENEFITS :

Hourly Pay Rate Range

Benefits : Innova Solutions offers benefits( based on eligibility) that include the following : Medical & pharmacy coverage, Dental / vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

ABOUT INNOVA SOLUTIONS : Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.

Recent Recognitions :

Named One of America’s Best Employers for New Grads by Forbes (2024

Named One of the Best Companies to Work For by U.S. News & World Report (Private Companies List, 2024-2025)

One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024)

One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics)

Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023)

One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024)

AWS Advanced Tier Services Partner with 100 certifications

Website : https : / / www.innovasolutions.com /

Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates.  If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at hr@innovasolutions.com or (770) 493-5588. Please indicate the specifics of the assistance needed.  Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities.   Innova Solutions (HireGenics / Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b.

The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.

Benefits :  Innova Solutions offers benefits( based on eligibility) that include the following : Medical & pharmacy coverage, Dental / vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

ABOUT INNOVA SOLUTIONS :   Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.

Recent Recognitions :

Innova Solutions  is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates.  If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please call (770) 493-5588. Please indicate the specifics of the assistance needed.  Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities.   Innova Solutions (HireGenics / Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b.

The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.

Salary : $70 - $73