BigData Architect/Collaborative Analyst-Cincinnati, OH - Georgia IT Inc.
Cincinnati, OH
About the Job
Job Title : BigData Architect/Collaborative Analyst
Location : Cincinnati, OH
Position Type : Full Time
Salary + benefits
Preferred only Green card, US Citizen and GC EAD
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
· 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,
Source : Georgia IT Inc.