Data Warehouse/BI Developer

3 weeks ago

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

Job Description:

Note: The effort will be a mix of onsite and remote work, with an initial assessment onsite, after which the hybrid arrangement would be defined. This effort could run at least 12 to 18 months and the onsite work would be at DPOR's offices at the beginning until telework is determined and evaluated. No time limit on the remote piece - just when the mgr is comfortable. This will be determined during the assessment phase. Pls make sure your candidate is aware of this and agrees to this arrangement.

IN PERSON Interviews required so must be local or willing to come to their facility and interview IN PERSON (no exceptions)

ABOUT THE ROLE
  • This resource will analyze DPOR's current three IT systems in order to understand how the data is stored and related. This resource will leverage that knowledge in order to write SQL to extract (and possibly transform) that data.
  • DPOR is about to undertake a project to implement a SaaS licensing and enforcement solution. DPOR will need someone who can learn its existing systems and the data underlying them to extract (and possibly transform) the data so that it can be loaded into the new solution.
  • If there is down time during this effort, it would be highly desirable for this person to be able to put together reports and dashboards especially if it can be performed in Power BI.
  • A major part of this project will be to convert data from DPOR's existing systems to its new system. I don't believe that we will need someone with specific ETL tool experience.

REQUIRED:
  • Able to analyze existing systems including screens and available documentation (e.g., data models or data dictionaries) to understand how the underlying data is organized, interrelated and stored in various databases as well as identify where there may be data anomalies / inconsistencies
  • Able to interact with and ask pertinent questions of system users to understand the organization and relationship of data in the systems and map data from source systems to target templates/systems
  • Able to create clear, concise and complete documentation (e.g., data models, data dictionaries) regarding the organization and use of data in existing systems
  • Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts
  • Strong working knowledge in Oracle (predominantly) and SQL Server creating complex queries, views, functions and stored procedures that leverages knowledge gained from analyzing systems and underlying data organization to extract / transform data into a vendor defined (TBD) format
  • Experience developing and testing data extraction and transformation routines PREFERRED
  • (not a primary skill, but a strong secondary skill that would be used when the above skills are not being used) - Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data
  • (preference though not required) - Strong working experience with Microsoft Power BI DPOR would like to bring on a resource with the above skillset as soon as possible. The reason for the urgency is that DPOR would like to for this resource to have a little time to acclimate and learn DPOR's existing systems so that when the time comes to begin converting data, the resource is ready to meet the need.

Required Skills:
  • Able to write complex SQL (joins, functions, stored procedures) to extract data and transform data from both Oracle and SQL Server databases
  • Able to analyze existing systems to understand how underlying data is stored and inter-related
  • Able to create, clear, concise and complete documentation related to the organization and use of data in existing systems
  • Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts
  • Experience developing and testing data extraction and transformation routines
  • Strong working experience with Microsoft Power BI
  • Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data

  • Power BI Developer

    1 month ago

    Richmond, United States Kapital Data Corp Full time

    **Job Title: Programmer Analyst / Power BI** **Location: Richmond, VA** **Duration: 6+ Months - Contract** **Pay Rate: Hourly Rate** - OSI purpose, goals, and portfolio statement - Reimagining transportation through a culture of innovation; Innovating through a set of high-impact imperatives **Core Responsibilities**: - Gain a broad understanding of the...

  • Power BI Developer

    1 month ago

    Richmond, United States CapLeo Global Full time

    Short Description: VDOT Power BI Developer VENDOR MAXIMUM SUBMITTAL RATE ***/hr*** Complete Description: **Local Richmond, VA candidates required due to onsite requirement **This position requires onsite 3 days a week with 2 remote **Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own...

  • Sr Data Warehouse Developer

    3 weeks ago

    Richmond, United States Delphi-US Full time

    Job Title: Data Warehouse Developer / Data Engineer (Contract) - Job#4252) Location: Hybrid. Richmond, VA. 2 days onsite Job Description: This client is seeking resources with abilities to design, develop, modify, test and automate to provide data warehouse and business intelligence applications solutions. This includes design, development, architecture...

  • Senior Data Warehouse Developer

    3 weeks ago

    Richmond, United States Ageatia Global Solutions Full time

    Designs, develops, modifies, tests and automation used to provide data warehouse and business intelligence applications solutions. This includes design, development, architecture recommendations, quality management, metadata and repository creation, trouble-shooting problems and tuning warehouse applications. Develops transition and implementation plans....

  • VSP SAP Business Objects BI Developer

    3 weeks ago

    Richmond, United States Nucleusteq Full time

    Hi, VSP SAP Business Objects BI Developer Location - Richmond, VA Mode - Contract LOCAL CANDIDATES ONLY - Interviews must be on-site and candidate will be required to work on-site at least 3 days per week DO NOT SUMBIT CANDIDATES WHO WERE PREVIOUSLY SUBMITTED TO 685973 Virginia State Police is seeking highly experienced Crystal Reports/Business Objects...

  • Power BI/GIS Developer

    1 week ago

    Richmond, United States Crescens Full time

    Title: Power BI/GIS Developer Location: Richmond VA Duration: 6+ Months Type: ContractNote: Local Richmond, VA candidates strongly preferred at least 3 days/wk onsite required Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking Responsibilities: Work with the data science team...

  • Power BI/GIS Developer

    3 days ago

    Richmond, United States Crescens Full time

    Title: Power BI/GIS Developer Location: Richmond VA Duration: 6+ Months Type: Contract Note: Local Richmond, VA candidates strongly preferred at least 3 days/wk onsite required Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking Responsibilities: Work with the data science...

  • SQL BI Developer

    4 days ago

    Richmond, United States Saxon Global Full time

    SQL BI Developer **Onsite in Richmond, VA Tuesday/Wednesday; Remote Monday, Thursday, Friday** Scope: Team is seeking an experienced SQL/BI Developer with strong database, programming, and analytical skills to actively participate in the following scope of work: Assist with overall SQL Support (development, performance, process, documentation) related to...

  • Lead Azure Developer

    2 days ago

    Richmond, United States Hudson Data Full time

    Job Title: Lead Azure Developer Location: Richmond, VA (Hybrid) Duration: Long Term In-Person Interview Description: Note: This is an In-Person Interview and this position requires that the resource works onsite 2 -3 days a week or as needed. *Local Richmond, VA candidates strongly preferred *Candidate must be able to work onsite as needed, up...

  • Oracle Data Architect with Power BI

    1 week ago

    Richmond, United States VSG Business Solutions LLC Full time

    Job DescriptionJob Description **Team is currently 100% remote with some in person meetings in Richmond as requested **some in person meetings are expected in Richmond, NO exceptionsABOUT THE ROLE:A Data Architect is required build and edit Data Factory pipelines, manage database needs, reporting, work with customers on file issues and perform data...

  • Data Warehouse Architect

    4 days ago

    Richmond, 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...

  • Data Warehouse Architect

    4 days ago

    Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: 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. DUTIES AND RESPONSIBILITES: Creating...

  • BI Analyst

    3 weeks ago

    Richmond, United States NavitsPartners Full time

    Job DescriptionJob DescriptionJob Title: BI AnalystPosition Overview:We are seeking a talented and analytical BI Analyst to join our team. The BI Analyst will be responsible for gathering, analyzing, and visualizing data to provide insights and support decision-making across the organization. The successful candidate will work closely with business...

  • Data Warehouse Architect

    3 weeks ago

    Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: 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. DUTIES AND RESPONSIBILITES: ...

  • Data Warehouse Architect

    3 weeks ago

    Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: 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. DUTIES AND RESPONSIBILITES: ...

  • VITA Data Warehouse/BI Developer 3

    7 days ago

    Richmond, United States Saxon Global Full time

    Job Description Experience in creating visualizations and reports for requested projects * Experience designing and developing dashboards, scorecards, charts, pivot tables, reports, and reporting systems according to the business requirements. * Experience and in-depth understanding of database concepts, online analytical processing (OLAP) and ETL...

  • Senior Data Warehouse Architect

    1 month ago

    Richmond, United States Crescens Full time

    Job Title: Senior Data Warehouse ArchitectLocation: Richmond, VADuration: 8 Months contract 2 Days ON SITE required each week. Local RVA candidates preferred OR (to be considered) must currently be within 3 hours drive of RVA, proof required of current residence required. Parking NOT available for contractors.ABOUT THE ROLE: DBHDS - Senior Data Warehouse...

  • Data Analyst 3

    2 months ago

    Richmond, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Data Analyst 3 (HYBRID)Location: Richmond, VADuration: 12+ MonthsJob Description: The Data Exchange Program fulfills one of the top priorities of the Commonwealth's behavioral health strategic plan, which is to deliver transactional and secure statewide behavioral health data. This position will be the data...

  • Data Warehouse Architect

    3 days ago

    Richmond, United States Crescens Full time

    Job Title: Data Warehouse Architect Location: Richmond, VA Duration: 16 months Note: *local Richmond, VA candidates required for onsite work *Candidates able to interview onsite. This is REQUIRED *candidate will be required to work ONSITE 3 days/wk, or additional days if requested. This is REQUIRED Job Description: Working with our business partners...

  • Business Intelligence Developer

    1 week ago

    Richmond, United States Virginia Housing Development Authority Full time

    Overview: **Join Virginia Housing and help make a difference as a **Business Intelligence Developer** Virginia Housing is one of the nation’s premier housing finance agencies. Our mission is to help Virginians attain quality, affordable housing, which we accomplish through our public-private partnerships. We are focused on employee engagement and...