Big Data Architect/Collaborative Analyst - Cincinnati, OH - Georgia IT Inc.

Cincinnati, OH

About the Job

Job Title                    : Big Data Architect/Collaborative Analyst
Location                   : Cincinnati, OH
Position Type          : Full Time
Salary + Benefits

US Citizen, Green Card and GC EAD Only (No H1B)

Job description

5+ years as a Technical Lead responsible for application database design and architecture

Proficient in data integration design and patterns, logical and physical data architecture and data modeling for enterprise applications, ODSs (Operational Data Stores), transactional data systems, data marts, data warehouses and business intelligence systems
Proficient in enterprise data modeling standards and tools
Proficient in full lifecycle development on multiple platforms / solution types
Experience in creating and implementing data architecture standards for master data management, data quality, data dictionary, meta data and data security
Experience with large data volumes and large databases and with data of varying degrees of quality and completeness
Ability to synthesize natural keys and create table JOINS from significantly different, unstructured data sets
Excellent SQL skills
Proficient in Linux shell scripting including SED, AWK and use of regular expressions
Familiarity with very large datasets
Familiarity with XML, JSON and other structured and unstructured data found in NOSQL databases
Ability to translate ambiguous business needs into technical requirements and refine those requirements over time to develop a solution acceptable to all stakeholders
Ability to train customers, technical staff and BI developers on the data, its quality and its use
Comfortable working in ambiguous and/or stressful situations
Self-motivated and know when to seek guidance
Ability to change priorities quickly, and capacity to handle multiple tasks
Ability to learn new tools and technologies
Ability to work independently and in a team
Ability to delegate tasks and review the work of others

Works closely with the technical and non-technical members of the business team to understand requirements and translate those requirements into workable technical objectives
Works with data owners to obtain access to source data, obtain sample data and to perform detailed analysis of source data to build a deep understanding of data quality and how the data can or cannot be used
Works with other Big Data Architects / Collaborative Analysts to resolve complex data management issues or issues that affect the entire Big Data ecosystem.
Works with other members of an agile project team to iteratively and collaboratively deliver a solution that meets the customer's goals
Builds data models, diagrams, documentation, metadata and other information that communicates the design intent of the proposed solution
Utilizes SQL,Linux shell scripting, and other tools to examine raw data, build exploratory data models, construct views from widely differing data sources and otherwise produce useful information from the raw data with the proper level of granularity and flexibility to meet customer's needs
Works iteratively with the customer's BI team to ensure suitability of the solution from a data quality, dimensionality and performance standpoint
May direct or oversee the daily work of ELT developers, BI developers and junior technical staff.

Source : Georgia IT Inc.