Data Analyst/Cloud ETL Developer

1 day ago


Richmond, California, United States Lorven Technologies Full time
Job Description:

Lorven Technologies is seeking a highly skilled Data Analyst/Cloud ETL Developer to join our team. As a key member of our Enterprise Data Asset team, you will be responsible for analyzing datasets to be made available in a cloud-based data management platform. Your expertise will help us produce master data with data governance.

Responsibilities include analyzing source systems which contain a spatial component for candidate datasets; documenting business processes and data lifecycle; developing data requirements, user stories and acceptance criteria; and testing strategies. You will also develop ETL to extract business data and spatial data and load it into a data warehousing environment. Design and test the performance of the system. Consult with various teams to understand the company's data storage needs and develop data warehousing options. Deep knowledge of coding languages, such as python, Java, XML, and SQL. Well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.

Responsibilities:

  • Work with the Project team members and business stakeholders to understand business processes and pain points
  • Develop expertise in source system datasets and data lifecycle
  • Profile source data which may contain a spatial component; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolution
  • Conduct entity resolution to identify matching and merging and semantic conflicts
  • Elicit, record, and manage metadata
  • Diagram current processes and proposed modifications using process flows, context diagrams and data flow diagrams
  • Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staff
  • Utilize progressive elaboration; map stories to data models and architectures to be used by internal staff to facilitate master data management
  • Identify and group related user stories into themes, document dependencies and associated business processes
Discover and document requirements and user stories with a focus on improving both business and technical processing

Requirements:

  • Minimum of 10 years of experience delivering business data analysis artifacts
  • 5+ years of experience as an Agile Business Analyst; strong understanding of Scrum concepts and methodology
  • Experience organizing and maintaining Product and Sprint backlogs
  • Experience translating client and product strategy requirements into dataset requirements and user stories
  • Proficient with defining acceptance criteria and managing acceptance process
Exceptional experience writing complex sql queries for Sql Server and Oracle. Experience with Azure Databricks, ESRI ArcGIS, and enterprise data management. Expertise with Microsoft Office products (Word, Excel, Access, Outlook, Visio, PowerPoint, Project Server). Experience with reporting systems - operational data stores, data warehouses, data lakes, data marts
  • Senior Data Analyst

    17 hours ago


    Richmond, California, United States Commonwealth of Virginia Full time

    Job SummaryWe are seeking a highly skilled Senior Data Analyst to join our Data Management Team (DMT) at the Virginia Department of Health (VDH). The successful candidate will provide development, system analysis, technical architecture support, and peer troubleshooting assistance in support of the VDH Strategic Plan.Key ResponsibilitiesImplement,...


  • Richmond, California, United States DataStaff, Inc. Full time

    Data Warehouse Architect OpportunityDataStaff, Inc. is seeking a skilled Data Warehouse Architect to support a long-term contract opportunity with one of our direct clients in Richmond, VA.Key Responsibilities:Provide technical oversight and support for existing data warehouse technologies.Collaborate with Enterprise Architecture teams to define and...


  • Richmond, California, United States Virginia Department of Human Resource Management Full time

    Job Title: Data Systems AnalystJob Summary:The Virginia Department of Medical Assistance Services is seeking a highly skilled Data Systems Analyst to join our team. As a Data Systems Analyst, you will provide technical expertise for the Integrated Care Division in all areas related to data analysis, reporting, and system integration.Key Responsibilities:*...

  • Data Engineer

    24 hours ago


    Richmond, California, United States JobRialto Full time

    Job SummaryWe are seeking a skilled Data Engineer to support our ETL processes for credit card data. As a key member of our team, you will be responsible for building and maintaining robust data pipelines and batch processing applications.Key Responsibilities: Design and implement efficient ETL processes for credit card data. Leverage technologies such as...

  • Data Engineer

    14 hours ago


    Richmond, California, United States MARKETview Full time

    Job Summary:MARKETview Education Technology is seeking a skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining complex data storage systems. You will work closely with the data and analytics team to support client onboarding and ensure data quality and security.Key Responsibilities:...


  • Richmond, California, United States Infojini Full time

    Job SummaryInfojini is seeking a highly skilled Data Analyst and SQL Developer to join our team. As a key member of our data team, you will be responsible for developing and maintaining Power BI reports and dashboards, as well as designing and implementing SQL queries and stored procedures. Key Responsibilities Develop and maintain Power BI reports and...

  • Senior Data Architect

    23 hours ago


    Richmond, California, United States GSK Solutions Full time

    Job Title: Senior Data ArchitectAt GSK Solutions Inc, we are seeking an experienced Senior Data Architect to support and evolve our existing data warehouse technologies. The ideal candidate will have extensive experience in data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or Collibra,...


  • Richmond, California, United States Vector Consulting, Inc Full time

    We are seeking an experienced Data Warehouse Technical Architect to support and evolve our existing data warehouse technologies, including Oracle Datawarehouse, IBM DataStage, and MFT. The ideal candidate will have deep experience in data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or...


  • Richmond, California, United States TechnoGen Full time

    Job Title: Senior Data Engineer - ETL/ELT ExpertJob Description: At TechnoGen, we are seeking a highly skilled Senior Data Engineer to lead our data engineering team. The ideal candidate will have expertise in ETL/ELT, Databricks, and Python/Pyspark.Key Responsibilities:* Design and implement data pipelines using ETL/ELT* Develop and maintain data processing...

  • Data Engineer

    1 day ago


    Richmond, California, United States The Custom Group of Companies Full time

    Cloud Data Integration DeveloperWe are seeking a skilled ETL Data Warehouse Developer to join our team of professionals. This is a hybrid position, with 3 days a week of onsite work in Richmond, VA. The engagement is expected to last 6-12 months.Responsibilities:Create and modify Workday inbound and outbound interfaces. Manage interfaces using SQL Server...


  • Richmond, California, United States DATASOFT TECHNOLOGIES Full time

    About the JobDuration: 8 Months Contract (possibility of extension)Location: Hybrid- Richmond, VAPay rate: Hourly, depending on experienceJob ID:We are seeking a highly skilled Data Warehouse Technical Architect to provide technical oversight and support for existing data warehouse technologies including Oracle Data warehouse and DataStage. The ideal...

  • Data Analyst

    14 hours ago


    Richmond, California, United States InterSources Full time

    Job DescriptionJob Title: Data AnalystJob Summary:We are seeking a highly skilled Data Analyst to join our team at InterSources Inc. The successful candidate will be responsible for collecting, analyzing, and interpreting complex data sets to inform business decisions.Key Responsibilities:Collect and analyze data from various sources to identify trends and...


  • Richmond, California, United States Hudson Data Full time

    Job Title: IT Security Analyst 3Hudson Data is seeking a highly skilled IT Security Analyst 3 to join our team. As a key member of our Information Security team, you will be responsible for implementing results-oriented strategic approaches, plans, programs, and procedures to ensure the security and integrity of our systems and data.Key...

  • Data Engineer

    13 hours ago


    Richmond, California, United States McKesson Full time

    We are seeking a skilled Data Engineer to join our Data & Analytics team within the Customer Service division of our US Medical-Surgical distribution company.In this role, you will design, build, and maintain data processing pipelines for the extraction, transformation, and loading (ETL) of data from various sources.You will develop robust and scalable...


  • Richmond, California, United States V-Soft Consulting Group Full time

    Job Title: Data Warehouse Technical ArchitectJob Summary: We are seeking a highly skilled Data Warehouse Technical Architect to join our team at V-Soft Consulting Group. As a Data Warehouse Technical Architect, you will be responsible for designing, developing, and maintaining data governance and management processes using tools like IGC, IKC, or...

  • Data Engineer II

    1 day ago


    Richmond, California, United States Experis Full time

    Data Engineer II RoleWe are seeking a highly skilled Data Engineer II to join our team at Experis. The ideal candidate will have experience with ETL, Snowflake, and Azure technologies, as well as a strong understanding of data management and integration. The successful candidate will be responsible for designing and implementing data solutions, performing...

  • Data Analyst

    24 hours ago


    Richmond, California, United States RICEFW Technologies Full time

    RICEFW Technologies is seeking a highly skilled Data Analyst to join our team. As a key member of our Enterprise Data Asset team, you will play a crucial role in analyzing datasets to be made available in a cloud-based data management platform.The ideal candidate will have a minimum of 10 years of experience delivering business data analysis artifacts and a...


  • Richmond, California, United States Cynet Systems Full time

    Job Title: Cloud Data Engineer - Data ArchitectJob Summary: We are seeking a highly skilled Cloud Data Engineer - Data Architect to join our team at Cynet Systems. The ideal candidate will have a strong background in designing and building large-scale cloud data solutions, with expertise in cloud databases, data warehousing, and data...


  • Richmond, California, United States SingleStone Full time

    Job Title: Senior Data ArchitectAt SingleStone, we're seeking a highly skilled Senior Data Architect to lead our data engineering efforts. As a key member of our team, you will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data analytics, business intelligence, and machine learning...


  • Richmond, California, United States Saxon Global Full time

    Data Warehouse and Business Intelligence DeveloperWe are seeking a skilled Data Warehouse and Business Intelligence Developer to join our team at Saxon Global. As a Data Warehouse and Business Intelligence Developer, you will be responsible for designing, implementing, and maintaining data warehouses and business intelligence systems. Your primary focus will...