Jobs
>
Columbus

    Senior Database Architect- Remote - Columbus, United States - Proteam Solutions

    Proteam Solutions
    Proteam Solutions Columbus, United States

    2 weeks ago

    Default job background
    Description
    This position is now 100% remote.


    Complete Description:
    The Senior Database Architect will be responsible for Medicaid Enterprise Data Warehouse (EDW)
    design, development, implementation, migration, maintenance, and operational activities. The
    candidate will closely with 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 State and
    Medicaid partners. This position is a member of Medicaid closely with the Business
    Intelligence & Data Analytics team.


    Responsibilities:

    • 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 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 and physical data models.
    • Review and understand existing business logic used in 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 Module Vendor's databases to Hadoop
    IOP, created HIVE tables and Impala view creation scripts for multiple data mart tables.


    • Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts
    (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

    EQUIRED 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 (minimum of 8-9 years' experience).


    • Experience in analysis, design, development, support and enhancements in data warehouse
    environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience in
    data analysis, data profiling, data model, data cleansing and data quality analysis in various
    layers using Database queries both in Oracle and Big Data platforms).


    • Experience (minimum of 8-9 years) in working Erwin Data Model tool, 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
  • Proteam Solutions

    Azure Cloud Architect-Remote

    2 weeks ago

    Proteam Solutions Columbus, United States

    Full remote, but must reside in Ohio · Complete Description:Years ofRelevant Experience: · 5+ Years experience in Azure Cloud Architecture. · PreferredEducation: · 4-year college degree in Computer Science, Engineering, Business, orother relevant field. · JobDescription: · ...

  • Cascade Enterprises

    Network Tools Architect

    2 weeks ago

    Cascade Enterprises Columbus, KY, United States Freelance

    We are a leading staffing agency specializing in IT and commercial personnel for temporary, service, and direct placement contracts. Our clients include IT system houses, manufacturers, and service providers. We are the preferred personnel service provider for IT service provider ...

  • IntelliX Software Inc

    Database Architect

    1 week ago

    IntelliX Software Inc Columbus, United States

    Job Title: Database Architect · Duration: 3 Months + 12 Months Extension · Remote – Columbus, OH (Local Prefer) · Must be require First and Last day onsite at Columbus, OH · The Senior Database Architect is responsible for the analysis, design, development, and implementation ...

  • Resource Informatics Group

    Cloud Architect

    1 week ago

    Resource Informatics Group Columbus, United States

    Cloud Architect · Duration: 6+ Months - Contract to Hire · Location: Remote · The position will allow the flexibility to work 100% remotely in St. Louis, MO; Columbus, OH; Jacksonville, FL or Greenville, SC · The Cloud Architect is responsible for establishing and overseeing t ...

  • Phoenix Innovations

    A SAP consultant is a professional who provides expertise and guidance in the implementation, customization, and maintenance of SAP software for businesses

    1 week ago

    Phoenix Innovations Lake Darby, United States

    For our client in the insurance industry, I am currently looking for an SAP consultant / consultant for SAP SD/MM at Lake Darby. · General information · Position: SAP Consultant / Consultant SAP SD / MM (m/f/d) · Start: ASAP · Duration: 6 months · Option for permanent employment ...

  • Georgia IT Inc

    Workday Techno Functional Developer

    6 days ago

    Georgia IT Inc Columbus, United States

    Job Title - Workday Techno Functional Developer · Location - Columbus OH - remote should be ok · Duration - Contract - 10 months · Rate - DOE · Work Authorization - USC, GC, GC-EAD,H4EAD , L2EAD, TN · Job Description Need Techno functional candidate for Workday. · Should h ...

  • Devcare Solution Ltd.

    NET Architect

    5 days ago

    Devcare Solution Ltd. Columbus, United States

    Summary: · We are seeking a highly skilled Senior .NET Architect to join our dynamic team. The ideal candidate will have expertise in .NET Core, Angular, and Microservices architecture. This role will involve a blend of coding (70%) and architectural design (30%), with a strong ...

  • Summit Human Capital

    Hybrid Remote Enterprise Data Modeler

    6 days ago

    Summit Human Capital Columbus, United States

    Summit Human Capital is seeking a highly motivated Hybrid Remote Enterprise Data Modeler to support one of our largest clients in Richmond, VA. The ideal candidate will meet the following criteria: · Requirements: · Minimum of 7 years of professional experience working in an ent ...

  • Ringside Talent

    Senior MDM Engineer

    1 week ago

    Ringside Talent Columbus, United States

    We are working on a remote opportunity for a Senior MDM Engineer. The ideal candidate will align with the responsibilities and qualifications outlined below. · Responsibilities: · Design and architect MDM solutions that meet business requirements and align with industry best prac ...

  • AA2IT

    System Architect

    6 days ago

    AA2IT Columbus, United States

    Title - Systems Architect · Location - Columbus, OH (hybrid remote) · Duration - 12+ months · Pay Rate - $90-100/hr · Responsibilities - Work as a part of the Platform engineering team · Work with team members as well as other solution architects to architect .Net solutions in d ...

  • HNB - 6785

    Senior Data Architect

    1 week ago

    HNB - 6785 Columbus, United States

    The Huntington National Bank · Senior Data Architect · (7 Easton Oval, Columbus, OH 43219) · Remote · Job Description: · Lead and develop technical solution architectures to meet business requirements with focus on data pipeline orchestration, cloud data solutions and advanced an ...

  • Remotely

    Java AWS Developer

    1 week ago

    Remotely Columbus, United States

    This is a remote position. · Java AWS Developer (US/Canada, 1 Year Experience, Remote) · Team Remotely Inc. is a staffing and recruitment agency that offers a comprehensive solution for talent acquisition, including sourcing, vetting, pay rolling, and managing talent. Whether y ...

  • Remotely

    Junior Java AWS Developer

    1 week ago

    Remotely Columbus, United States

    This is a remote position. · Junior Java AWS Developer (US/Canada, 1 Year Experience, Remote) · Team Remotely Inc. is a staffing and recruitment agency that offers a comprehensive solution for talent acquisition, including sourcing, vetting, pay rolling, and managing talent. Wh ...

  • HCLTech

    Cybersecurity Architect

    2 weeks ago

    HCLTech Franklin Lakes, United States

    Job Title: - Cybersecurity Architect · Location: - Franklin Lakes, NJ · Full time Hire · Day 1 Onsite (Hybrid- 3 Days Onsite & 2 Days remote for every week) · Primary skills: Security Architecture and Engineering, Sec ops, IAM, Network security, Governance risk and compliance · ...

  • Remotely

    Full Stack Developer React/Python

    2 weeks ago

    Remotely Columbus, United States

    This is a remote position. · Full Stack Developer React/Python (US/Canada, 1 Year Experience, Remote) · Team Remotely Inc. is a staffing and recruitment agency that offers a comprehensive solution for talent acquisition, including sourcing, vetting, pay rolling, and managing ta ...

  • NiSource

    Lead Data Architect

    2 weeks ago

    NiSource Columbus, United States

    Lead Data Architect · Full Time Perm · Salary:$125,800 - $188,600, plus annual bonus · Way of Work: Remote · The Enterprise Data Strategy department owns the data strategy for the enterprise data lake house. · The Lead Data Architect plays a crucial role in creating high-qua ...

  • Perceptive Recruiting, LLC

    IT Solution Architect

    2 weeks ago

    Perceptive Recruiting, LLC Columbus, United States

    NEW IT Solutions Architect - Microsoft · opportunity open in Columbus, OH · Hybrid remote · work schedule. This role is responsible for providing technical consulting and lead design reviews across a multi-divison enterprise. The Solutions Architect will contribute to initiati ...

  • Midas Consulting

    Salesforce Developer

    6 days ago

    Midas Consulting Columbus, United States

    Job Title: Salesforce Developers - (Sales Cloud, Service Cloud) · Location: Columbus OH (Remote is ok - will be happy to have local candidates to Columbus OH) · Visa- any · Bill Rate $75/hr · The client's name will be disclosed later · Must-Have: · Must have 10 + years of s ...

  • Vaco

    Cloud Network/Systems Engineer

    2 days ago

    Vaco Columbus, United States

    Location: Remote - Ohio local preferred Position Type: Direct Hire *Eligible candidates MUST be able to work legally in the US without sponsorship (no C2C - sponsorship transfer not able to be provided) Position Description: The Systems Engineer is responsible for the configurati ...

  • SMITH.

    SAP Commerce Cloud

    2 weeks ago

    SMITH. Columbus, United States

    At SMITH, we develop world-class experiential commerce solutions to help brands architect the most relevant, frictionless commerce experiences possible. We work at a high tempo, we collaborate, we're passionate about our work with clients, and we deliver. · The market demand for ...