Data Analyst/Cloud ETL Developer

1 month ago

Richmond, Virginia, United States InterSources Full time
Job Title :
Data Analyst/Cloud ETL Developer

Job Description:

The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a Master Data Analyst with demonstrated experience in data analytics to work as a key member of the Enterprise Data Asset team.

This analyst will support teams working in Agile (Sprint) to analyze datasets to be made available in a cloud-based data management platform that will support the agency to 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.

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.

VDOT is a fast-paced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects, and remain flexible and productive, despite changing priorities and processes.

Ongoing improvement and efficiency are a part of our culture, and each team member is expected to proactively contribute to process improvements.


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

  • Assist Product Owner in maintaining the product backlog
  • Create conceptual prototypes and mock-ups
  • Collaborate with staff, vendors, consultants, and contractors as they are engaged on tasks to formulate, detail and test potential and implemented solutions
  • Perform Quality Analyst functions such as defining test objectives, test plans and test cases, and executing test cases
  • Coordinate and Facilitate User Acceptance Testing with Business and ensure Project Managers/Scrum Masters are informed of the progress
  • Designs and develops systems for the maintenance of the Data Asset Program, ETL processes, and business intelligence
  • Develop a new data engineering process that leverage a new cloud architecture and will extend or migrate our existing data pipelines to this architecture as needed
  • Design and supports the DW database and table schemas for new and existent data sources for the data hub and warehouse
  • Design and development of Data Marts
  • Work closely with data analysts, data scientists, and other data consumers within the business in an attempt to gather and populate data hub and data warehouse table structure, which is optimized for reporting
  • The Data developers partners with Data modeler and Data architect in an attempt to refine the business's data requirements, which must be met for building and maintaining Data Assets

  • Data Analyst/Cloud ETL Developer

    4 weeks ago

    Richmond, Virginia, United States InterSources Full time

    Job Title:Data Analyst/Cloud ETL DeveloperJob Description:Job Summary:We are seeking a highly skilled Data Analyst/Cloud ETL Developer to join our team at InterSources Inc. The ideal candidate will have a strong background in data analysis, cloud computing, and ETL development.Key Responsibilities:Design and develop ETL processes to extract, transform, and...

  • Data Analyst/Cloud ETL Developer

    4 weeks ago

    Richmond, Virginia, United States InterSources Full time

    Job Title: Data Analyst/Cloud ETL DeveloperJob Description:The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a skilled Data Analyst/Cloud ETL Developer to join their Enterprise Data Asset team. As a key member of this team, you will be responsible for analyzing datasets to be made available in a cloud-based...

  • Senior Azure ETL Developer

    4 weeks ago

    Richmond, Virginia, United States Serigor Inc. Full time

    Job Title: Senior Azure ETL DeveloperThe client is seeking a Senior Azure ETL Developer to design, build, and deploy scalable cloud-based data solutions. The ideal candidate will have hands-on experience with Azure services such as Azure Data Factory, Azure Databricks, and Azure Data Lake Storage.Key Responsibilities:Design and implement data warehousing...

  • Senior DataStage ETL Developer

    1 month ago

    Richmond, Virginia, United States InterSources Full time

    Job Title: Sr. DataStage ETL DeveloperWe are seeking an experienced DataStage ETL Developer to join our team at InterSources Inc. As a DataStage ETL Developer, you will be responsible for designing, developing, and implementing ETL solutions using IBM InfoSphere/DataStage product line.Key Responsibilities:Design and develop ETL solutions using IBM...

  • Cloud Data Engineer

    1 month ago

    Richmond, Virginia, United States Cynet Systems Full time

    Job Description:As a Cloud Data Engineer at Cynet Systems, you will play a crucial role in designing and building large-scale data solutions in an enterprise setting. Your expertise in cloud databases, data warehousing, and data governance will be essential in driving business value through data-driven insights.Responsibilities:Partner with engineering teams...

  • Senior DataStage ETL Developer

    4 weeks ago

    Richmond, Virginia, United States InterSources Full time

    Job Title : Sr. DataStage ETL DeveloperLocation: Richmond, VA, HybridRate : Best competitive rateLocal Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement. Web Cam and ONSITE interviews. Candidates must be willing and able to work onsite 2 days/week for the first couple of weeks, and 1-2 days/week...

  • Senior Data Analyst

    1 month ago

    Richmond, Virginia, United States Kinsale Insurance Company Full time

    Senior Data AnalystAt Kinsale Insurance, we're seeking a skilled Senior Data Analyst to join our team. As a key member of our data analytics team, you'll play a critical role in supporting business-critical initiatives and collaborating with IT teams and business partners to solve enterprise problems.Responsibilities:Develop and design reports/extracts based...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States Global Pharma Tek Full time

    Job Title: Data AnalystGlobal Pharma Tek is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for analyzing and interpreting complex data to inform business decisions.Key Responsibilities:Analyze and interpret complex data to inform business decisionsDevelop and maintain databases and data systemsCollaborate...

  • Data Warehouse Technical Architect

    4 weeks ago

    Richmond, Virginia, United States Parintec Full time

    Job DescriptionWe 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...

  • Data Warehouse Technical Architect

    3 weeks ago

    Richmond, Virginia, United States Vector Consulting, Inc Full time

    About the Role: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...

  • Data Engineer

    4 weeks ago

    Richmond, Virginia, United States MARKETview Full time

    About the Role:MARKETview Education Technology is seeking a skilled data engineering developer to join our team as we build and manage the data infrastructure necessary to make higher education a more data-informed industry.This individual will be a critical contributor to a fast-growing, early-stage education technology business and will have the unique...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States Kinsale Insurance Company Full time

    Job SummaryWe are seeking a highly skilled Data Analyst to join our team at Kinsale Insurance Company. As a Data Analyst, you will be responsible for collecting, analyzing, and interpreting complex data to support business-critical initiatives.Key ResponsibilitiesDevelop and design reports and extracts based on business requirements.Collect, analyze, and...

  • Senior Data Architect

    1 month ago

    Richmond, Virginia, United States SingleStone Full time

    Senior Data EngineerAt SingleStone, we're seeking a highly skilled Senior Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data analytics, business intelligence, and machine learning initiatives.Key...

  • Senior Data Integration Specialist

    4 weeks ago

    Richmond, Virginia, United States Aloden, Inc. Full time

    Job SummaryWe are seeking a highly skilled Senior Data Integration Specialist to join our team at Aloden, Inc. in Richmond, VA. As a key member of our data transformation team, you will be responsible for designing, developing, and maintaining ETL processes using IBM Infosphere DataStage.Key ResponsibilitiesDesign and develop complex ETL processes using IBM...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States InterSources Full time

    Job DescriptionAs a Data Analyst at InterSources Inc, you will play a crucial role in helping our clients achieve their digital transformation goals. Your primary responsibility will be to collect, organize, and analyze complex data sets to derive meaningful insights that inform business decisions.Key Responsibilities:Collaborate with cross-functional teams...

  • Senior Business Data Analyst

    1 month ago

    Richmond, Virginia, United States Virginia Housing Development Authority Full time

    Senior Business Data AnalystAt Virginia Housing Development Authority, we're seeking a highly skilled Senior Business Data Analyst to join our team. As a key member of our data analytics team, you will play a critical role in driving business outcomes through data-driven insights.Key Responsibilities:Conduct data analysis and usage requirements assessments...

  • Data Engineer II Position

    4 weeks ago

    Richmond, Virginia, United States ManpowerGroup Full time

    Data Engineer II Job OverviewWe are seeking a highly skilled Data Engineer II to join our team at ManpowerGroup. The ideal candidate will have experience with ETL, Snowflake, and Azure technologies, as well as a strong understanding of data management principles.Key Responsibilities Design and implement data pipelines using ETL and ELT tools Develop and...

  • Business Systems Analyst 4

    3 weeks ago

    Richmond, Virginia, United States Serigor Inc. Full time

    Job Title: Business Systems Analyst 4Job Description:A strong Business Systems Analyst is needed to support the Release 103 Cardinal Care project. This resource will primarily support technical requirements discussions related to CRMS interface mapping for any new plans and relevant changes for existing plans.Key Responsibilities: Perform ETL testing and...

  • Salesforce Commerce Cloud Developer

    1 month ago

    Richmond, Virginia, United States CapTech Consulting Full time

    Job DescriptionThe Salesforce Commerce Cloud Developer is a key role in our growing Salesforce practice. They have an excellent technical understanding of both Salesforce languages and frameworks and key technical aspects of Salesforce integrations.They can take business requirements and can, working with a team or alone, deliver full solutions to the...

  • Senior Data Management Analyst

    4 weeks ago

    Richmond, Virginia, United States SunPlus Data Group Inc Full time

    Job DescriptionThe Senior Data Management Analyst will lead business-focused efforts to implement critical data management tools across SunPlus Data Group Inc, including IBM Knowledge Catalog, Data Stage, Snowflake, Collibra, Safe FME, and ArcGIS Enterprise. This role will focus on managing change initiatives for data program impacting a very large group of...