Senior Database Architect, open to remote - 509924

Revel IT

Columbus, Ohio client seeking a Senior Database Architect contractor - open to remote outside of Columbus, OH

Treat our consultants and clients the way we would like others to treat us — we are honest, stay true to our word, and work in the best interest of our clients, consultants, and candidates. Many say they work this way, but few actually do. We are a company that does. Additionally, we bring joy to the world of IT staffing and IT recruiting by making the hiring experience memorable, fun, and different. 
Find and provide the best talent for clients and excellent career opportunities for consultants and candidates — whom we treat as part of our team. Interested in joining our team? Check out the opportunity below and apply today!
Reference: 509924
The Senior Database Architect will be responsible for Enterprise data warehouse design, development, implementation, migration, maintenance and operational activities. The candidate will closely with the Data Governance and Analytics team. Will be one of the key technical resource for data warehouse projects for various Enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with client partners. 
**Open to remote candidates outside of Columbus, OH**
  • Participate in team activities, design discussions, stand up meetings and planning review with team.
  • Perform data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms.
  • Eliciting, analyzing and documenting functional and non-functional requirements.
  • Document business requirements, meeting minutes, and key decisions/actions.
  • Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions.
  • Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements.
  • Follow the organization design standards document, create data mapping specification document, pseudo codes for the development team(s) and design documents.
  • Create logical & physical data models.
  • Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs.
  • Review PySpark programs that are used to ingest historical and incremental data.
  • Review Sqoop scripts to ingest historical data from Oracle database to Hadoop IOP, created Hive tables and Impala view creation scripts for Dimension tables.
  • Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts.
  • Validate test results and records as well as log and research defects.
  • Analyze production data issues, report problems and find solutions to fix the issues, if any.
  • Create incidents and tickets to fix production issues, create Support Requests to deploy code for development team to UAT environment.
  • Participate in meetings to continuously upgrade the Functional and technical expertise.
  • Establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
  • Create and present project plan, project status and other dashboards as necessary.
  • Perform other duties as assigned.
REQUIRED Skill Sets:
  • 8+ years data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment.
  • Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design.
  • Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala.
  • Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Big Data Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica.
  • Experience in working with Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), Stream Sets pipelines, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.
  • Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus.
  • Experience eliciting, analyzing and documenting functional and non-functional requirements.
  • Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.
  • Experience in identifying data anomalies.
  • Experience building data sets and familiarity with PHI and PII data.
  • Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
  • Effective communication, presentation, & organizational skills.
  • Good experience in working with Visio, Excel, PowerPoint, Word, etc.
  • Effective team player in a fast paced and quick delivery environment.
  • Required Education: BS/BA degree or combination of education & experience.
DESIRED Skill Sets:
  • Demonstrate effective leadership, analytical and problem-solving skills
  • Required excellent written and oral communication skills with technical and business teams.
  • Ability to work independently, as well as part of a team
  • Stay abreast of current technologies in area of IT assigned
  • Establish facts and draw valid conclusions
  • Recognize patterns and opportunities for improvement throughout the entire organization
  • Ability to discern critical from minor problems and innovate new solutions
Revel IT (formerly known as Fast Switch) is one of the fastest-growing, privately held, IT Staffing companies in the nation. Our client base includes 32% of the Fortune 25. We have major offices in Dublin, OH, Tucson, AZ, Los Angeles, CA, and Austin, TX, and are rapidly expanding into new markets from coast to coast.
  • In addition to standard health and 401k benefits, we offer referral bonuses and training/continuing education opportunities.
  • 5-year client retention: 99%
  • No. 1 supplier with customers: 53%
  • Top 3 supplier with customers: 77%
  • Consultant retention: 94%
We do our jobs in a way that brings delight every day to our clients and the people who work with us. Life is simply too short to grind through every day as a small cog in a huge recruiting machine. As a young and high energy company, we aim to help consultants and candidates land fulfilling jobs that offer real career growth.