Data Warehouse/BI Developer

6 months 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

  • Data Warehouse/BI Developer

    1 month ago

    Richmond, Virginia, United States Crescens Full time

    Job Title: Data Warehouse/BI DeveloperLocation: Richmond, VADuration: 12 MonthsJob 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...

  • VITA Data Warehouse/BI Developer 3

    4 weeks ago

    Richmond, California, United States Saxon Global Full time

    Job Title: VITA Data Warehouse/BI Developer 3Job Description: We are seeking a highly skilled Data Warehouse and Business Intelligence Developer to join our team at Saxon Global.As a Data Warehouse and Business Intelligence Developer, you will be responsible for designing, developing, and maintaining data warehouses and business intelligence systems.Key...

  • Power BI/SQL Developers

    4 weeks ago

    Richmond, California, United States V-Soft Consulting Group Full time

    Job Title: Power BI/SQL DevelopersJob Summary:We are seeking a highly skilled Power BI/SQL Developer to join our team at V-Soft Consulting Group. As a Power BI/SQL Developer, you will be responsible for creating interactive visualizations, reports, and dashboards that assist with effective monitoring of Critical Data Elements. You will also develop, design,...

  • Sr Data Warehouse Developer

    6 months 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...

  • Power BI/SQL Developer

    3 weeks ago

    richmond, United States Vaco Full time

    We are seeking a detail-oriented Data Analyst / BI Analyst to join our team. The ideal candidate will be proficient in SQL and Power BI, with a strong ability to analyze data and create insightful reports. You will play a key role in transforming data into actionable insights to support decision-making across the organization.Key Responsibilities:Develop,...

  • Power BI/SQL Developer

    3 weeks ago

    richmond, United States Vaco Full time

    We are seeking a detail-oriented Data Analyst / BI Analyst to join our team. The ideal candidate will be proficient in SQL and Power BI, with a strong ability to analyze data and create insightful reports. You will play a key role in transforming data into actionable insights to support decision-making across the organization.Key Responsibilities:Develop,...

  • Power BI/SQL Developer

    3 weeks ago

    Richmond, United States Vaco Full time

    We are seeking a detail-oriented Data Analyst / BI Analyst to join our team. The ideal candidate will be proficient in SQL and Power BI, with a strong ability to analyze data and create insightful reports. You will play a key role in transforming data into actionable insights to support decision-making across the organization. Key Responsibilities:Develop,...

  • Data Warehouse and Business Intelligence Developer

    4 weeks ago

    Richmond, California, United States Saxon Global Full time

    Data Warehouse and Business Intelligence DeveloperWe are seeking a skilled Data Warehouse and Business Intelligence Developer to join our team at Saxon Global. As a Data Warehouse and Business Intelligence Developer, you will be responsible for designing, implementing, and maintaining data warehouses and business intelligence systems. Your primary focus will...

  • Power BI/SQL Developer

    1 month ago

    Richmond, California, United States LingaTech Full time

    Job Title: Data Quality Enhancement SpecialistJob Summary:LingaTech is seeking a highly skilled Data Quality Enhancement Specialist to join our team. As a key member of our data team, you will be responsible for developing and maintaining Power BI reports, optimizing SQL queries, and ensuring data security compliance.Key Responsibilities:Maintain the...

  • Power BI/SQL Developer

    3 weeks ago

    Richmond, United States DataTeams Full time

    Full Job Description -VRS - SQL DevelopersOn - Site Required : The individual will follow the VRS Hybrid work schedule including 2 days onsite per week (Tuesday and Wednesday). The individual may also be called to be onsite for critical meetings and data related discussions. Onsite work will be at the VRS central office at 1200 East Main Street, Richmond,...

  • Power BI SQL Developer

    1 month ago

    Richmond, United States Rose International Full time

    Date Posted: 10/24/2024 Hiring Organization : Rose International Position Number: 473320 Job Title: Power BI SQL Developer Job Location: Richmond, VA, USA, 23219 Work Model: Hybrid Shift: 2 days onsite per week (Tues and Wed each week required) Employment Type: Temporary Estimated Duration (In months): 8 Min Hourly Rate ($): 60.00 Max...

  • Power BI Developer

    1 month ago

    Richmond, United States V-Soft Consulting Group, Inc. Full time

    Title - Data Visualization Consultant /PowerBI Developer Location: Richmond, VA (Hybrid work schedule - 1 week onsite / 1 week remote (switches off every week) Duration – 6 Month Contract Required SkillsPower BI - Develop and maintain Power BI dashboards and reports to visualize data and demonstrate business value.SQL - Utilize SQL for data manipulation,...

  • Power BI Developer

    4 weeks ago

    richmond, United States V-Soft Consulting Group, Inc. Full time

    Title - Data Visualization Consultant /PowerBI Developer Location: Richmond, VA (Hybrid work schedule - 1 week onsite / 1 week remote (switches off every week) Duration – 6 Month Contract Required SkillsPower BI - Develop and maintain Power BI dashboards and reports to visualize data and demonstrate business value.SQL - Utilize SQL for data manipulation,...

  • Power BI Developer

    1 month ago

    richmond, United States V-Soft Consulting Group, Inc. Full time

    Title - Data Visualization Consultant /PowerBI Developer Location: Richmond, VA (Hybrid work schedule - 1 week onsite / 1 week remote (switches off every week) Duration – 6 Month Contract Required SkillsPower BI - Develop and maintain Power BI dashboards and reports to visualize data and demonstrate business value.SQL - Utilize SQL for data manipulation,...

  • Senior Power BI/SQL Developer

    1 month ago

    Richmond, California, United States Cadre Technologies Services LLC Full time

    Job Title: Power BI/SQL DevelopersJob Summary:We are seeking a highly skilled Power BI/SQL Developer to join our team at Cadre Technologies Services LLC. As a Power BI/SQL Developer, you will be responsible for developing and maintaining reports, dashboards, and data visualizations using Power BI and SQL Server.Key Responsibilities:* Develop and maintain...

  • Power BI SQL Developer

    1 month ago

    richmond, United States Rose International Full time

    Date Posted: 10/24/2024Hiring Organization: Rose InternationalPosition Number: 473320Job Title: Power BI SQL DeveloperJob Location: Richmond, VA, USA, 23219Work Model: HybridShift: 2 days onsite per week (Tues and Wed each week required)Employment Type: TemporaryEstimated Duration (In months): 8Min Hourly Rate($): 60.00Max Hourly Rate($): 65.00Must Have...

  • Senior Power BI/SQL Developer

    4 weeks ago

    Richmond, California, United States Trillium Staffing Full time

    Job SummaryWe are seeking a highly skilled Power BI/SQL Developer to join our team at Trillium Staffing. As a key member of our data quality enhancement initiative, you will be responsible for developing and maintaining Power BI reports and dashboards, as well as optimizing SQL queries and stored procedures. If you have a strong background in data...

  • Senior Power BI/SQL Developer

    4 weeks ago

    Richmond, Virginia, United States TMS Full time

    Job Title: Senior Power BI/SQL DeveloperJob Summary:We are seeking a highly skilled Senior Power BI/SQL Developer to join our team at TMS. As a key member of our Data Office, you will play a critical role in the Data Quality Enhancement initiative, collaborating with business, IT, and other stakeholders to drive data-driven decision making.Key...

  • Senior Power BI/SQL Developer

    1 month ago

    Richmond, Virginia, United States Software People, Inc. Full time

    Job DescriptionSoftware People, Inc. is seeking a highly skilled Senior Power BI/SQL Developer to join our team. The ideal candidate will have a strong background in developing reports, dashboards, and data visualizations using Power BI, as well as experience in SQL Server development, including writing complex queries, stored procedures, and performance...

  • Senior Power BI/SQL Developer

    4 weeks ago

    Richmond, California, United States DATASOFT TECHNOLOGIES Full time

    About the JobThis is a contract position with a minimum duration of 6 months, with the possibility of extension. The ideal candidate will be available within the next 6 weeks.Job SummaryWe are seeking a highly skilled Power BI/SQL Developer to assist with overall Power BI/SQL Support related to the Data Quality Enhancement initiative and other development...