Data Analyst/Cloud ETL Developer

4 weeks 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 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 data management platform, supporting teams working in Agile (Sprint) to produce master data with data governance.

Key Responsibilities:

  • Develop expertise in source system datasets and data lifecycle
  • Profile source data, 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

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
  • Exceptional experience writing complex SQL queries for SQL Server and Oracle
  • Experience with 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
  • Advanced understanding of data integrations
  • Strong knowledge of database architectures
  • Ability to effectively prioritize and handle multiple tasks and projects

Computer Skills/MS Office/Software:

  • Excellent computer skills and be highly proficient in the use of MS Word, PowerPoint, MS Excel, MS Project, MS Visio, and MS Team Foundation Server
  • Deep passion for data analytics technologies as well as analytical and dimensional modeling
  • Extensive familiarity with ETL (Extraction, Transformation & Load), data warehousing, and business intelligence tools such as business objects, PowerBI and Tableau
  • Vast knowledge of database design and modeling in the context of data warehousing
  • Experience with key data warehousing architectures including Kimball and Inmon, and has a broad experience designing solutions using a broad set of data stores (e.g., HDFS, Azure Data Lake Store, Azure Blob Storage, Azure SQL Data Warehouse, Azure Cosmos DB)
  • IBM Datastage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse
  • Operating System Environments (Windows, Unix, etc.)
  • Scripting experience with Windows and/or Python, Linux Shell scripting

InterSources Inc. is a Certified Diverse Supplier, founded in 2007, offering innovative solutions to help clients with Digital Transformations across various domains and industries. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success.

We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc.

Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.

  • 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...

  • 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...

  • Data Warehouse Technical Architect

    4 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 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

    4 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...

  • 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...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States TechnoGen Full time

    Job Title: Data AnalystTechnoGen is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for assisting with complex data cleaning, integration, and analysis of public health data.Key Responsibilities:Leverage appropriate analytic and visualization tools (SQL, R, Python, Tableau, others) to develop complex data...

  • Data Analyst

    4 weeks ago

    Richmond, Virginia, United States InterSources Full time

    Data Analyst Job DescriptionAt InterSources, we are seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a crucial role in helping us make data-driven decisions and drive business growth.Key Responsibilities:Collaborate with internal and external teams to understand data needs and objectives.Gather data from primary and...

  • Splunk Data Engineer

    4 weeks ago

    Richmond, Virginia, United States Saxon Global Full time

    As a Data Analytics Specialist at Saxon Global, you will be responsible for leveraging your expertise in data analytics and ETL processes to drive business growth. With a strong background in server administration on Linux and Windows platforms, you will be able to connect with multiple types of data platforms, including machine data, SQL databases, APIs,...

  • Data Governance Specialist

    1 month ago

    Richmond, Virginia, United States InterSources Full time

    About the RoleWe are seeking a highly skilled Data Governance Analyst to join our team at InterSources Inc. As a Data Governance Analyst, you will play a critical role in strategically building data policy, defining, implementing, and operating data governance at DBHDS.This is a unique opportunity to work with a talented team to develop and implement data...

  • Data Analyst 4

    1 month ago

    Richmond, Virginia, United States Serigor Inc Full time

    Job Title:Data Analyst 4 (Hybrid)Location:North Chesterfield, VADuration:12+ MonthsJob Description:The client is seeking a skilled Data Analyst to play a crucial role in the Data Strategy project for establishing an enterprise data solution at Virginia State Police. As a Data Analyst, you will oversee data systems and reporting frameworks, ensuring data...

  • Business Development Analyst

    1 month ago

    Richmond, Virginia, United States Insight Global Full time

    Job Title: Business Development AnalystJob Description:We are seeking a Business Development Analyst to join our team at Insight Global. As a Business Development Analyst, you will be responsible for supporting a huge project that affects many areas of the business. Effective communication and strong SQL skills are required.Key Responsibilities:Support...

  • Business Data Analyst

    4 weeks ago

    Richmond, Virginia, United States DKMRBH Inc Full time

    Job Title: Business Data AnalystJob Summary:DKMRBH Inc is seeking a highly experienced Business Data Analyst to support the implementation of Enterprise Data Management tools. The ideal candidate will have a strong understanding of enterprise data management concepts and tools, with a minimum of 10 years of experience delivering business and systems analysis...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States Capital One Full time

    About the Role:Capital One is seeking a highly skilled Data Analyst to join our team in McLean, Virginia. As a Data Analyst, you will be responsible for leveraging analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.Key Responsibilities:Use Open Source/Digital technologies to...

  • Data Analyst 3 Position

    1 month ago

    Richmond, Virginia, United States Serigor Inc. Full time

    Job Title: Data Analyst 3The Data Exchange Program is a high-priority initiative for the Commonwealth, aiming to deliver secure statewide behavioral health data. As a Data Analyst 3, you will play a crucial role in standing up a new Enterprise Data Warehouse (EDW) for the Agency, forming the foundation of the data exchange.Key Responsibilities:Create a data...

  • Data Analyst 4 Position

    4 weeks ago

    Richmond, Virginia, United States Serigor Inc. Full time

    Job Title: Data Analyst 4 PositionJob Description:The Serigor Inc. team is seeking a skilled Data Analyst to play a crucial role in the Data Strategy project for establishing an enterprise data solution. As a Data Analyst, you will be responsible for overseeing data systems and reporting frameworks, ensuring the integrity and precision of data.You will...

  • Senior Data and Business Intelligence Analyst

    4 weeks ago

    Richmond, Virginia, United States McKesson Full time

    Job Title: Senior Data and Business Intelligence Analyst – Customer Connectivity McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of...

  • Economist and Data Analyst

    3 weeks ago

    Richmond, Virginia, United States CentiMark Full time

    Job Description:We are seeking a highly skilled Economist and Data Analyst to join our team at {company}. This individual will be responsible for analyzing economic data and creating reports to help inform business decisions.The ideal candidate will have a strong understanding of economic principles and be able to collect and analyze data from various...

  • Data Analyst

    1 month ago

    Richmond, Virginia, United States Capital One Full time

    Job DescriptionCapital One is seeking a highly skilled Data Analyst to join our Enterprise Services team. As a Data Analyst, you will play a critical role in driving business decisions through data-driven insights.Key Responsibilities:Develop and maintain well-managed data solutions and capabilities to tackle business problems.Partner with the business to...

  • Salesforce Developer

    1 month ago

    Richmond, Virginia, United States Mindlance Full time

    Job Title: Salesforce DeveloperJob Summary: Mindlance is seeking a skilled Salesforce Developer to work closely with Product Managers and team members to ensure the timely and effective delivery of Salesforce requirements for an nCino platform in the Financial Services industry. The Developer is responsible for managing all aspects of nCino / Salesforce.com...