Data Warehouse/BI Developer

2 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

  • Sr. Tableau Developer

    1 day ago

    Richmond, United States Data Inc Full time

    Required Skills: 1. Tableau 2. MicroStrategy 3. MS SQL server Preferred Skills: 4. Mongo DB Characteristics of a top performer: • Thought-leader and work directly with the BI Lead to propose multi-staged solutions. • The individual will work with stakeholders to ensure that the solutions meet enterprise standards and architectural roadmap(s). Education...

  • Power BI Developer

    2 weeks 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...

  • Power BI Developer

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

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

  • Sr Data Warehouse Developer

    5 days 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

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

  • Senior Data Warehouse Developer

    5 days 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....

  • Mid-Level BI Developer

    5 days ago

    Richmond, United States NIRA Full time

    We are seeking a dedicated and innovative Mid-Level BI Developer to join the NIRA project team, a key initiative in the FDA's digital transformation journey. This role is crucial for developing and implementing information dashboards and process automation solutions that align with the FDA IT Strategy's objectives, including enhancing collaboration,...

  • VSP SAP Business Objects BI Developer

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

  • VSP SAP Business Objects BI Developer

    5 days 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 Developer

    2 weeks ago

    Richmond, United States Georgia IT Inc Full time

    Position : Power BI Developer Location : Richmond, VA Duration : 12 Months Rate : DOE US Citizens and those authorized to work in the U.S are encouraged to apply. We are unable to sponsor at this time. Job description Power BI, data profiling, and data mapping, data visualization, Agile, Crystal Reports, Business Objects, Python or R, DAX and or Power...

  • Data Warehouse Architect

    2 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

    5 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: ...

  • Data Warehouse Architect

    5 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: ...

  • Senior Data Warehouse Architect

    5 days ago

    Richmond, United States Cynet Systems Full time

    Job Description: Responsibilities: Senior Data Warehouse Architect for the EDW Modernization Project, a cornerstone of the Agency's Data Exchange and Modernization Program. This project will implement a SaaS EDW and build integrations with multiple source systems. The client is seeking a Senior Data Warehouse Architect to join our team for a...

  • BI Analyst

    1 week 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 Analyst 3

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

    16 hours ago

    Richmond, United States BlueFish Technologies Full time

    Job Description Job Description Title: Data Warehouse Architect 4 Start Date: 05/20/2024 End Date: 10/14/2025 # of Openings: 1 Position Type: Contract Location: Chesterfield, VA, United States Onsite Flexibility: 0% Remote Interview: Onsite Description: *Local Richmond area candidates or those willing to relocate to the Richmond area during this engagement...

  • Data Warehouse Architect at VA

    5 days ago

    Richmond, United States Elite WorkForce Inc Full time

    Job Description Job Description Position: Data Warehouse Architect Location: Chesterfield, VA Duration: 12+ Months Job Type: hybrid Interview: Both Web Cam and In Person Interview Local Candidate Only Required Skills: - Proficient in Azure Data Factory Pipeline or SSIS development for both Azure and local Sql Server environments with 5 years of experience -...

  • LU Tableau Developer/Data Visualization

    2 weeks ago

    Richmond, United States Focused HR Solutions LLC Full time

    ** Candidates will be allowed to work 100% remotely. Candidates must be able to come ONSITE to Richmond, VA to pick up laptop and complete orientation, NO exceptions. Candidate must work EST Business Hours ** Our direct client has an opening for a Tableau Developer/Data Visualization Specialist position # 702041. This position is for 6-12+ months, with...