Data Warehouse/BI Developer

2 weeks ago


Richmond, Virginia, United States Crescens Full time
Job Title: Data Warehouse/BI Developer
Location: Richmond, VA
Duration: 12 Months

Job Description:

The position offers a mix of onsite and remote work. Initial assessment will be onsite, followed by a hybrid arrangement. The project is expected to last 12 to 18 months. Onsite work will commence at DPOR's offices before transitioning to telework based on evaluation. There is no set time for the remote component, it will be decided during the assessment. Candidates need to be aware of and agree to this setup.

About the Role:
  • This role involves analyzing DPOR's current IT systems to comprehend data storage and relationships. SQL skills will be utilized to extract and potentially transform data.
  • DPOR is preparing to implement a SaaS licensing and enforcement solution. The ideal candidate will grasp existing systems and data to facilitate data migration to the new solution.
  • In case of downtime, the candidate should be capable of creating reports and dashboards, especially using Power BI.
  • A significant aspect of the project is transitioning data from DPOR's current systems to the new one, without the need for specific ETL tool expertise.
Required:
  • Ability to analyze existing systems, screens, and documentation to understand data organization and identify anomalies.
  • Capable of interacting with system users to comprehend data relationships and map data accordingly.
  • Skilled in creating comprehensive documentation about data organization in existing systems.
  • Proficiency in Oracle and SQL Server for creating complex queries and data transformations.
  • Experience in developing and testing data extraction routines is preferred.
  • Ability to perform data analysis and generate reports, using Power BI is a plus.
  • DPOR is seeking a resource with the mentioned skill set to join promptly. The importance lies in allowing time for the resource to familiarize with DPOR's systems before commencing data conversion tasks.
Required Skills:
  • Proficient in writing complex SQL queries for data extraction and transformation from Oracle and SQL Server databases.
  • Skilled in analyzing existing systems to understand data storage and relationships.
  • Ability to document data organization clearly and address issues in data mapping.
  • Experience in developing and testing data extraction routines.
  • Strong familiarity with Microsoft Power BI.
  • Capable of data analysis and report/dashboard creation using existing data sources.


  • Richmond, Virginia, United States James River Insurance Company Full time

    Come grow with James River Insurance James River Insurance is an excess and surplus lines segment of James River Group Holdings, Ltd. and operates on an approved non-admitted basis in 50 states and Washington, DC. Since 2003, James River has provided thousands of commercial property and casualty customers with innovative and creative solutions for particular...


  • Richmond, Virginia, United States Echo IT Solutions, Inc Full time

    Data Warehouse Architect Chesterfield, VA Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. Ideal candidate will have extensive experience with Workday Studio and XSLT. Candidate could be creating data...


  • Richmond, Virginia, United States St Jardins Full time

    About:Senior Business Analyst will support project to design and implement a new Enterprise Data Warehouse (EDW) and data exchange.Short Description:Sr Business Analyst is needed to work on Enterprise Data Warehouse (EDW) Modernization project within the Data Exchange Program. This project will replace the existing data warehouse with a new cloud...

  • Data Analyst 2

    2 weeks ago


    Richmond, Virginia, United States Novalink Solutions Full time

    Job Description Data Analyst with proficiency in Power BI to join our team. As a Data Analyst, you will be responsible for interpreting data, analyzing results, and providing insights to drive business decisions. Your expertise in Power BI will be instrumental in refreshing, updating and/or creating visually compelling reports and dashboards that effectively...

  • Data Architect

    2 weeks ago


    Richmond, Virginia, United States Crescens Full time

    Job Title: Data ArchitectLocation: Richmond, VADuration: 10+monthsType: Contract**some in person meetings are expected in Richmond, NO exceptions****Team is currently 100% remote with some in person meetings in Richmond as requested**ABOUT THE ROLE:A Data Architect is required build and edits Data Factory pipelines, manage database needs, reporting, work...

  • Data Architect

    2 weeks ago


    Richmond, Virginia, United States Stabilis Professional Services, Inc Full time

    Job DescriptionJob DescriptionStabilis Professional Services is looking for a Data Architect for a contract position with a client in Richmond, VA. This is a Hybrid role.The Data Architect is required build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and perform data research. This individual will be...


  • Richmond, Virginia, United States Mindlance Full time

    Job Description: Engagement Manager is looking for a Data Engineer with the following skillset: Python, SQL, NoSQL, Airflow, Spark/PySpark, REST API, AWS (Lambda, S3, RDS, Fargate, EC2, ECS, EMR, etc.) EM open to Plano and VA locations (hybrid Mon & Fri remote/Tue-Thu onsite) EEO:"Mindlance is an Equal Opportunity Employer and does not discriminate in...

  • Data Architect

    2 weeks ago


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

    BOUT THE ROLE: Seeking Data Architect to build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues, and perform data research. This individual will be expected to work with the current application development team to provide enhancements and support on our system. Experience/skills: 5+ years handson...


  • Richmond, Virginia, United States ZIRLEN TECHNOLOGIES INCORPORATED Full time

    Benefits:Relocation bonusREQUIREMENTData Scientist 4 - Reporting/Data AnalystLocation: Richmond, VA (Onsite) 12+ months contractInterview Type: In Person OnlyWork Arrangement: OnsitePerforms complex data research and analysis. Creates data to support system testing including interface testing. Coordinates data scrubbing when required for testing.Complete...


  • Richmond, Virginia, United States ZIRLEN TECHNOLOGIES INCORPORATED Full time

    Benefits:Relocation bonusREQUIREMENTData Scientist 4 - Reporting/Data AnalystLocation: Richmond, VA (Onsite) 12+ months contractInterview Type: In Person OnlyWork Arrangement: OnsitePerforms complex data research and analysis. Creates data to support system testing including interface testing. Coordinates data scrubbing when required for testing.Complete...


  • Richmond, Virginia, United States Data Meaning Full time

    Senior Talend DeveloperLocation: Hybrid, 3 weeks remote + 1 week on-site in Richmond, VAPosition type: C2C 1099 or Full-time W2 employee availableLength of contract (if C2C): 1 year with possible extensionPosition SummaryData Meaning is a front-runner in Business Intelligence and Data Analytics consulting, renowned for our high-quality consulting services...

  • ORACLE Data Architect

    2 weeks ago


    Richmond, Virginia, United States AespaTech LLC Full time

    Job Description Job Description As per the client's need, only Independent USC& GC are considered for this role Role:ORACLE Data Architect WITH Power BILocation:Remote work ( Richmond VA)Duration:Long Term ContractABOUT THE ROLE:A Data Architect is required to build and edit Data Factory pipelines, manage database needs, report, work with customers on file...


  • Richmond, Virginia, United States Chefs' Warehouse Full time

    Join The Chefs' Warehouse Team! The Chefs' Warehouse has been a leader in providing exceptional quality and brand building along with broadline food service distribution for over three decades. With our diverse offerings in Protein, Specialty, Produce, and Broadline, we cater to the most discerning chefs in a unique blend of convenience and top-notch...

  • VDOT Data Analyst 2

    2 weeks ago


    Richmond, Virginia, United States nLeague Full time

    Job DescriptionJob DescriptionData Analyst 2Location: Richmond, VADuration: 12+ MonthsClient: VDOTJob Id: Data Analyst with proficiency in Power BI to join our team. As a Data Analyst, you will be responsible for interpreting data, analyzing results, and providing insights to drive business decisions. Your expertise in Power BI will be instrumental in...

  • Data Architect

    4 weeks ago


    Richmond, Virginia, United States LingaTech Full time

    Data Architect - Remote in Richmond, VA - on-site meetings requiredContract role: 10 months + extension of 6 months to 1+ years** Must be able to attend local, on-site meetings **** US Citizen or Green Card candidates **A Data Architect is required build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and...

  • Data Architect

    1 month ago


    Richmond, Virginia, United States LingaTech Full time

    Data Architect - Remote in Richmond, VA - on-site meetings requiredContract role: 10 months + extension of 6 months to 1+ years** Must be able to attend local, on-site meetings **** US Citizen or Green Card candidates **A Data Architect is required build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and...

  • Data Architect

    2 weeks ago


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

    DataStaff, Inc is seeking a Data Architect for a long-term contract opportunity with one of our direct clients located in Richmond, VA.*Team is currently remote with some in person meetings in Richmond as requestedResponsibilities:Build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and perform data...

  • Senior Data Engineer

    13 hours ago


    Richmond, Virginia, United States CarMax Full time

    8901 - Corp Office West Crk Tuckahoe Creek Parkway, Richmond, Virginia, 23238CarMax, the way your career should be Summary of Duties:Work collaboratively and creatively with other data engineers and stakeholders to gather requirements for data warehouse development, analyze source data, assess impacts to existing ecosystem, and develop scalable data...

  • Data Engineer

    2 weeks ago


    Richmond, Virginia, United States Nucleusteq Full time

    Data Engineer Role Info: Hands on BI Data Engineer role with strong Creating KPI Dashboards - Interactive Dashboards using tableau / Quicksight Top Skills: BI Tableau / AWS Quicksight exp is a must AWS (IAM, RDS, S3, Lambda) exp is a must SQL exp is a must Python knowledge is required Nice to have: AWS Certified Solutions Architect About the Company:...


  • Richmond, Virginia, United States Data Concepts Full time

    Job Description Java, SpringBoot, AWS, Vue, React, Angular Data Concepts is seeking a Full Stack Java Developer experienced with the following technologies. 80% backend, 20% frontend Java/SpringBoot AWS Cloud experience Database JavaScript - VUE or equivalent like React/Angular