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
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.
