Jobs
>
Dinan

    Senior Data Architect - McLean, United States - LMI Consulting, LLC

    LMI Consulting, LLC
    LMI Consulting, LLC McLean, United States

    3 weeks ago

    Default job background
    Description


    Senior Data Architect - Clearance Desired



    Job Locations

    US-Remote

    Job ID



    # of Openings

    1

    Category

    Data/Analytics



    Overview



    Seeking a senior data architect to oversee data architecture for large scale API and web application back end data store and implement ETL processes to supply application data for usage in the web application.



    Responsibilities

      Oversees data architecture for large scale API and web application back end data store. Implements ETL processes to supply application data for usage in the web application.
    • Manages critical low latency application databases on platforms.
    • Develop packages and scripts for system enhancements and interfaces.
    • Develops scripts to validate the various data on systems. Involve in writing queries to improve the database performance and availability.
    • Must use process through the ETL and refresh to identify, troubleshoot, and correct code problems.
    • Develop, implement, and execute a quality assurance program and quality control standards for all activities. Executes statement to create and update various tables and views utilize for testing of code on an database.
    • Establish database backup/recovery strategy using user-manage backup. Engineer extensive database solutions and interfaces enabling performance of data requests. Develop reusable components for deployment in a traditional data warehouse environment.
    • Standardize database maintenance activities by standardizing directory structure, documentation of DBA activities.
    • Establish backup and recovery options and implement automation of many DBA utility functions. Document database design, data definition language, define data migration strategy between different products/versions and develop data migration procedures.



    Qualifications



    Qualifications:

    • Minimum of 10 years' experience designing, developing, and maintaining enterprise database systems.
    • Experience with cloud database development and implementation (AWS preferred).
    • Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings.
    • Demonstrated experience with ETL pipeline design and implementation.
    • Overseeing aspects of data governance and maintenance, modeling, and secure access.
    • Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle).
    • Demonstrated experience implementing ETL pipelines within and without the use of 3rd party vendor solutions (NNCompass, Pentaho).
    • Demonstrated experience documenting database architecture and diagrams.
    • Secret clearance or ability to obtain and maintain a government security clearance, for which one must be a US citizen.

    Preferred:

    • Experience with storage on cloud for containerized applications
    • Experience with NoSQL (Cassandra, HBase, MongoDB, etc...)
    • Experience with index based datastores (ElasticSearch, Solr)
    • Experience running ETL pipelines over Apache NiFi



    LMI is an Equal Opportunity Employer. LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact

    Need help finding the right job?



    We can recommend jobs specifically for you

    Click here to get started.
  • DMI (Digital Management, Inc.)

    Data Architect

    2 days ago

    DMI (Digital Management, Inc.) McLean, United States

    · Data Architect · Job ID · Category · Architect · Location · US-VA-McLean · About DMI · DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migra ...

  • Booz Allen Hamilton

    Data Architect

    3 weeks ago

    Booz Allen Hamilton McLean, United States

    Job Number: R · Data Architect · Key Role: · Understand data and data management from an enterprise architecture perspective. Translate business-oriented information requirements into technical data management solutions by developing and implementing enterprise data strategies ...

  • Steampunk

    Data Architect

    1 day ago

    Steampunk McLean, United States

    Overview: · In todays rapidly evolving technology landscape, an organizations data has never been a more important aspect in achieving mission and business goals. Our data exploitation experts work with our clients to support their mission and business goals by creating and exec ...

  • LMI Consulting, LLC

    Senior Data Architect

    2 days ago

    LMI Consulting, LLC McLean, United States

    · Senior Data Architect - TS/SCI with Polygraph Required · Job Locations · US-VA-McLean · Job ID · # of Openings · 1 · Category · Data/Analytics · Overview · LMI currently has an opportunity for a Senior Data Architect to support an Intelligence Community customer in the McLean ...

  • Global Pharma Tek

    AWS Data Architect

    4 days ago

    Global Pharma Tek McLean, United States

    Position: AWS Data Architect · Job Location - McLean, VA. (Day-1 Onsite| 3 days Onsite & 2 Days remote) · Need 12 + Years. · Job Description:- · Data Architect 5+ years of experience leading architecture governance processes such as technology selection and architecture review ...

  • LMI Consulting, LLC

    Senior Data Architect

    2 days ago

    LMI Consulting, LLC McLean, United States

    Senior Data Architect - TS/SCI with Polygraph Required · Job Locations · US-VA-McLean · Job ID · # of Openings · 1 · Category · Data/Analytics · Overview · LMI currently has an opportunity for a Senior Data Architect to support an Intelligence Community customer in the M ...

  • Logistics Management Institute

    Senior Data Architect

    1 day ago

    Logistics Management Institute McLean, United States

    Overview · LMI currently has an opportunity for a Senior Data Architect to support an Intelligence Community customer in the McLean area. The ideal candidate will have a deep understanding of data systems, data management, and data workflow modernization. This role involves anal ...

  • Booz Allen Hamilton

    Data Architect, Director

    3 weeks ago

    Booz Allen Hamilton McLean, United States

    Job Number: R · Data Architect, Director · Key Role: · Initiate data architecture (DA) activities, including extract-transform-load (ETL) processes and data warehouse solutions design, through business needs analysis and routine issue resolution. Apply advanced theories, princi ...

  • CirrusLabs

    Data Architect

    4 weeks ago

    CirrusLabs McLean, United States

    About Us: CirrusLabs is a leading consulting firm based in Alpharetta, GA, specializing in delivering innovative technical solutions to clients across various industries. We are committed to excellence, agility, and exceeding customer expectations. As we continue to grow, we are ...

  • Steampunk

    Data Architect

    3 weeks ago

    Steampunk McLean, United States

    Overview: · At Steampunk, our goal is to build and execute a data strategy for our clients to coordinate data collection and generation, to align the organization and its data assets in support of the mission, and ultimately to realize mission goals with the strongest effectiven ...

  • Somatus

    Data Architect

    3 weeks ago

    Somatus McLean, United States

    Overview · Somatus, the leader in value-based kidney care, has an immediate opening for a Data Architect to create impact among Somatus clients and leadership by building data warehouse and ETL solutions to drive clinical operations, advanced analytics, and machine learning mode ...

  • Cohere Technology Group

    Data Architect

    3 weeks ago

    Cohere Technology Group McLean, United States

    Cohere is looking for a Data Architect that will actively participate in sprint planning and review sessions with the product owner and provide coordination with architecture, information assurance, requirements, testing and configuration management personnel. · The successful c ...

  • Janus Soft Inc

    Data Architect

    3 weeks ago

    Janus Soft Inc McLean, United States

    REQUIRED SKILLS AND DEMONSTRATED EXPERIENCE · •Demonstrated experience developing custom database tools, queries, and Apache NiFi flows. · •Demonstrated experience designing, building, and deploying production data pipelines incorporating SQL, NoSQL, and other data storage and qu ...

  • Money Fit by DRS

    Senior Data Architect

    3 weeks ago

    Money Fit by DRS McLean, United States

    Senior Data Architect · Remote Role · We offer Excellent Pay, Health, Dental, Vision Insurance, and Opportunities for Growth · We are an established organization based in Anchorage AK. and with offices throughout the country that offer our employees Excellent Pay, Health, Dental, ...

  • SAIC

    Chief Data Architect

    2 weeks ago

    SAIC McLean, United States

    SAIC, a leading provider of systems development & deployment, targeting & intelligence analysis, systems engineering & integration, and training capabilities and solutions for the Intelligence Community, is seeking creative and dedicated professionals to fulfill their career goal ...

  • Global Pharma Tek

    AWS Data Architect

    3 weeks ago

    Global Pharma Tek McLean, United States

    Position: · AWS Data ArchitectJob Location - McLean, VA. (Day-1 Onsite| 3 days Onsite & 2 Days remote)Need 12 + Years. · Job Description :-Data Architect · 5+ years of experience leading architecture governance processes such as technology selection and architecture review boa ...

  • The MITRE Corporation

    Principal Data Architect

    3 weeks ago

    The MITRE Corporation McLean, United States

    Why choose between doing meaningful work and having a fulfilling life? At MITRE, you can have both. That's because MITRE people are committed to tackling our nation's toughest challengesand we're committed to the long-term well-being of our employees. MITRE is different from most ...

  • Maxar Technologies

    Full Stack Developer

    2 weeks ago

    Maxar Technologies McLean, United States Full time

    Please review the job details below. · Job DescriptionWe are looking for Full Stack Developers to support the re-architecture, modernization, and addition of new geo-referenced data sources to an operational enterprise system providing data ingest, archive, retrieval, display, an ...

  • Technology Ventures

    Senior Data Engineer

    2 weeks ago

    Technology Ventures McLean, United States

    Must Haves: Minimum of 5 years of hands on experience with Python. Hand on experience with Snowflake. Proficiency with database management, specifically SQL. Must have hands on experience with AWS - specifically must have experience with Lambda, S3, EC2, CloudWatch, SSM, and EMR. ...

  • Dexian

    Snowflake Admin

    2 weeks ago

    Dexian McLean, United States

    Title: Snowflake Admin · Duration: 7 Months + Possible extensions · Location: Mclean VA · Responsibilities: · Develop data filtering, transformational and loading requirements · Define and execute ETLs using Apache Sparks on Hadoop among other Data technologies · Determine approp ...