Senior Database Architect

2 months ago

Columbus, United States United Software Group Full time
Job Description: Senior Database Architect

Work Location: 50 West Town Street, Columbus, Ohio 43215 - Remote

Description: The Senior Database Architect will play a crucial role in Medicaid Enterprise Data Warehouse (EDW) design, development, and operational activities. Collaborating closely with the Data Governance and Analytics team, this position involves being a key technical resource for various Enterprise Data Warehouse projects. The focus includes building critical data marts, data ingestion to Big Data platforms for analytics, and facilitating data exchange with State and Medicaid partners. This role is a pivotal member of Medicaid ITS and OST, closely aligned with the Business Intelligence & Data Analytics team.

Responsibilities:
  • Participate in team activities, design discussions, stand-up meetings, and planning reviews.
  • Conduct data analysis, profiling, cleansing, and quality analysis in various layers using Database queries in Big Data platforms.
  • Elicit, analyze, and document functional and non-functional requirements.
  • Lead client meetings with data-driven analysis to clarify requirements and design decisions.
  • Create logical and physical data models, ensuring compliance with organizational design standards.
  • Review and understand existing business logic used in Hadoop ETL platforms.
  • Assist in creating and executing test plans, scenarios, and scripts, validating results, and addressing production issues.
  • Establish priorities, present project plans and status, and perform other assigned duties.
REQUIRED Skill Sets:
  • 8+ years of data analysis/architecture experience in Waterfall and Agile Methodology, preferably in Healthcare.
  • Strong SQL experience (Oracle, Hive, and Impala) for DDL and DML creation.
  • Experience with Cloudera Bigdata Technologies, Erwin Data Model tool, Unix commands, and scripting.
  • Ability to migrate data from relational databases (preferably Oracle) to Hadoop.
  • Effective communication, presentation, and organizational skills.
  • Bachelor's degree or a combination of education and experience.
Experience:
  • Experience in analysis, design, development, support, and enhancements in a data warehouse environment with Cloudera Bigdata Technologies is required.
  • 8 years of experience in data analysis, profiling, modeling, cleansing, and quality analysis in various layers using Database queries in Oracle and Big Data platforms is required.
  • 8 years of experience in working with Erwin Data Model tool, hive/impala queries, Unix commands, scripting, and shell scripting is required.

  • Database Architect

    1 week ago

    Columbus, United States Northwest LLC Full time

    The Data Architect is responsible for the design, development, and management of the organization's data infrastructure. This individual provides strategic recommendations to maximize the value of information assets via their creation, access and use by partnering with various stakeholders including non-technical and technical business users, data engineers,...

  • Senior Cloud Architect for Digital Payments

    6 days ago

    Columbus, Ohio, United States Saxon Global Full time

    About the Role:We are seeking a highly skilled Senior Cloud Architect to join our digital payments team at Saxon Global. This individual will play a key role in designing and implementing scalable, secure, and efficient cloud-based solutions using AWS technologies.Job Description:The ideal candidate will have hands-on experience working with AWS Lambda,...

  • Senior Cloud Software Architect

    7 days ago

    Columbus, Ohio, United States Nanosoft Consulting Full time

    **Company Overview:**Nanosoft Consulting is a cutting-edge technology firm dedicated to delivering innovative solutions that transform businesses.**Job Summary:**We are seeking an experienced **Senior Cloud Software Architect**/Lead Developer to join our team. The successful candidate will have expertise in designing and implementing cloud-native...

  • Senior Database Development Engineer

    7 days ago

    Columbus, Ohio, United States Oracle Full time

    About the RoleWe are seeking a highly skilled Senior Database Development Engineer to join our team at Oracle. This is an exceptional opportunity for a talented individual to contribute to the development of innovative database technologies.

  • Senior Database Developer

    3 months ago

    Columbus, United States Emerald Resource Group Full time

    Job Title: Senior Database Developer Location: Cleveland, OH, United States *Note: This role is not available for sponsorship*Job Description: We are seeking a highly skilled Senior Database Developer to design, develop, document, implement, and maintain database solutions in support of web applications, with a strong focus on Oracle database applications,...

  • Senior Database Administrator

    4 weeks ago

    columbus, United States eBusiness Solutions, Inc. Full time

    One of our client in the government sector is seeking a highly skilled Database Administrator. Location: Columbus, OH (Hybrid-2 Days a week)Responsibilities:Provide critical production support for DB2, SQL Server, and Teradata applications.Upgrade DB2 z/OS to the latest supported version.Install and configure Always On High Availability (HA) and Disaster...

  • Senior Network Architect

    7 days ago

    Columbus, Ohio, United States Vimerse InfoTech Inc Full time

    **Job Title:** Senior Network Architect**Job Summary:Vimerse InfoTech Inc is seeking a highly skilled Senior Network Architect to design, deploy, and maintain complex network infrastructures. The ideal candidate will have extensive experience with Cisco products and a strong understanding of routing and switching protocols.**Key Responsibilities:Design and...

  • Senior Data Architect

    6 days ago

    Columbus, Ohio, United States Centraprise Full time

    As a Senior Data Architect at Centraprise, you will be responsible for designing and implementing the company's data architecture. This includes selecting and integrating big data tools and frameworks, ETL process implementation, and monitoring performance to advise necessary infrastructure changes. The ideal candidate will have 15+ years of hands-on...

  • Data Architect/Modeler

    1 week ago

    Columbus, United States Diverse Lynx Full time

    Role:- Data Architect/Modeler Location- Columbus, OH - Onsite roles / No Remote Duration- Fulltime/Permanent Job Description Data Architect/Modeler The Data Architect/Modular acts as a support to the Enterprise Technology API Management and Data Modeling. As a Data Architect/Modeler, you'll be responsible for designing, implementing, and maintaining...

  • Senior IT Architect

    6 days ago

    Columbus, Indiana, United States MILLENNIUMSOFT Full time

    About this roleWe are seeking a highly experienced IT Architect to join our team at MillenniumSoft, with a focus on developing and implementing IT strategies that drive business growth and efficiency. As a Senior IT Architect, you will play a key role in shaping our IT architecture and ensuring that our technology solutions align with our business...

  • Senior Enterprise Architect

    6 days ago

    Columbus, Ohio, United States Saxon Global Full time

    Role: Senior Enterprise ArchitectType: 12-month contract to hireLocation: RemoteRate: OpenWe are seeking a highly skilled Senior Enterprise Architect to join our team specializing in Systems Information Technology & Analytics for our Analytics and Digital department in Columbus, Indiana or remotely.In this role, you will make a significant impact...

  • Data Architect/Modeler

    6 days ago

    Columbus, Ohio, United States Diverse Lynx Full time

    Job Description: **Data Architect/Modeler Position**The Data Architect/Modeler role at Diverse Lynx LLC plays a crucial part in supporting the Enterprise Technology API Management and Data Modeling.Responsibilities include designing, implementing, and maintaining data structures for efficient storage and retrieval. These duties involve analyzing complex data...

  • Senior Systems Architect/ State of Ohio

    4 months ago

    Columbus, United States ShiftCode Analytics Full time

    Senior Systems Architect State of Ohio Location: Candidate must be in Ohio, preferably Columbus area. It is Hybrid position. All aprart from CPT & H1BJob Description Cynergies Solutions Group is looking for qualified candidates for a Senior Systems Architect position at our Columbus Ohio area client. Job Duties and Responsibilities: The main...

  • Senior Cloud Architect for Enterprise Infrastructure

    6 days ago

    Columbus, Ohio, United States Alpha Rae Personnel Full time

    Job Title: Senior Cloud Architect for Enterprise Infrastructure About the Role:We are seeking an experienced Senior Cloud Architect to join our team at Alpha Rae Personnel. As a key member of our organization, you will play a vital role in shaping our technology strategy and driving innovation in cloud-based infrastructure solutions. Responsibilities:•...

  • Senior Cloud Software Architect

    3 weeks ago

    Columbus, Ohio, United States Oracle Full time

    Job Title: Senior Cloud Software ArchitectOracle is seeking a highly skilled Senior Cloud Software Architect to join our Health Data Intelligence team. As a key member of our engineering team, you will be responsible for designing and developing cloud-based software solutions for our electronic health record system. Your expertise in cloud architecture,...

  • Senior IT Architect

    6 months ago

    Columbus, United States MILLENNIUMSOFT Full time

    Position       : Senior IT Architect Location : Columbus, IN Total Hours/week : 40.00 Description: No remote work is possible for this position This is a Temp to hire role and please make the candidates aware that if they are offered the full time role, salary will be discussed with Cummins HR and most likely will be in line with the base pay and...

  • Senior Data Center Network Architect

    6 days ago

    Columbus, Ohio, United States eTek IT Services, Inc. Full time

    Job OvervieweTek IT Services, Inc. is a leading provider of IT solutions, and we are seeking an experienced Senior Data Center Network Architect to join our team.

  • Senior Data Systems Architect

    6 days ago

    Columbus, Ohio, United States Sogeti Full time

    Job Summary:We are seeking a highly skilled Sr. Data Systems Architect to join our Life Sciences team at Sogeti.About the Role:This is an exciting opportunity for a talented professional to lead the development of sophisticated informatics solutions that drive efficiencies in content curation and workflow processes.Key Responsibilities:Develop and deploy...

  • Senior Cloud Solutions Architect

    7 days ago

    Columbus, Ohio, United States Infinity Consulting Solutions Full time

    About Infinity Consulting SolutionsWe are a leading consulting firm that specializes in providing innovative solutions to our clients.Job Summary:Infinity Consulting Solutions is seeking an experienced Senior Cloud Solutions Architect to join our team. As a Senior Cloud Solutions Architect, you will be responsible for designing and implementing cloud-based...

  • SQL Database Administrator

    3 months ago

    Columbus, United States Saxon Global Full time

    **Candidates must be located within a commutable distance of the central Ohio area. ***This is a contract-to-hire opportunity and will convert to a full-time position within 3-6 months. Our client is looking for a mid to senior-level SQL DBA to join their technical team, assisting the Senior DBA with all responsibilities that include but are not limited to: ...