T-SQL Power BI Data Visualization Analyst (Jobs in Richmond, VA)   Requirement id 136747 Job title Analyst Job location in Richmond, VA Skills required SQL Analyst, T-SQL, Data Analysis, Power BI Data Visualization Open Date 03-Oct-2022 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: SQL Analyst, T-SQL, Data Analysis, Power BI Data Visualization Start date :09/05/2022 End Date :09/04/2023 Submission deadline :10/6/2022 Client Info :VDOT Description : *local candidates strongly preferred *candidates must interview onsite, NO exception *candidates must work onsite 3 days/wk, NO exception Relies on experience in data analytics and business process automation to create effective and innovative business solutions, independently perform tasks and provide guidance to team members. VDOT is looking for a data analyst starting as soon as possible to work as part of the Professional Services Procurement Office to create reports, visualizations, dashboards, and metrics to provide business insight that aid decision-making using Power BI and to use robotic process automation to automate business processes. Uses query languages like T-SQL, scripting languages like DAX, R or Python to perform meaningful quantitative or qualitative analysis. Works with ITD, SMEs and other team members to understand requirements and provide guidance for extensible reporting capabilities. Key responsibilities: • Developing dashboards, visualizations and reports using Power BI to improve business process • Utilizing Blue Prism or similar tool to automate business operations and data analysis and reduce manual labor • Curating data sets that drive data collection models to better consolidate information • Builds data models that help improve efficiency throughout the overall business operations • Performing quality assurance testing to ensure the data presented is correct • Identifying the development needs for the purpose of streamlining and improving efficiency and key insights • Collaborating with team members at all levels for the purpose of collecting data, documenting requirements, and executing on deliverables • Analyzing business requirements and processes to provide recommendations for improvement • Perform data profiling to identify anomalies • Creating and maintaining documentation that includes design, requirements, and user manuals • Learning and understanding the data landscape across multiple databases and applications • Coordinate with ITD to implement new models and inform long term solution options • Create presentations to present analysis findings Key qualifications: • 5+ years in analytical position • 3+ years using Power BI (other leading BI applications will be considered) • 3+ years of database design and work with unstructured data in a data lake environment • Strong knowledge of data collection software and protocol • Advanced Microsoft Excel proficiency – Advanced Formulas, Pivot Tables & Macros • Ability to structure business discussions and scope solutions • Excellent analytical and forecasting ability • Strong written and verbal communication skills • Understand current data protection and privacy laws • Ability to think through problems and provide recommendations to a solution • Demonstrated ability to manage multiple complex projects in parallel • Proven ability to develop and manage BI solutions using Power BI • Strong knowledge of T-SQL and DAX to support reports, dashboards, and data models • Demonstrated experience using Blue Prism or a similar tool to automate business operations and data analysis and reduce manual labor • Exceptional data visualization experience • Ability to analyze and mine data from multiple systems. • Ability to understand users needs and devise solutions accordingly. • In-depth knowledge of the data development life cycle • Excellent documentation skills. • Experience creating detailed reports and giving presentations. • Competency in Microsoft applications including Word, Excel, and Power Point • Advanced knowledge of Power BI, DAX, T-SQL, and Blue Pri   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 136747 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14), SQL Analyst job openings in Richmond, VA Jobs List VDOT Data Analyst 3 (723393) Create date: 06-Nov-2023 Hybrid Start date :11/20/2023 End Date :06/30/2024 Submission deadline : 11/8/2023 Client Info : VDOT Description : ------------------------------------------------------ **local Richmond, VA candidates required due to onsite requirement *Candidate must also be able to work onsit.... (This job is for - UIAPI Jobs in VA Richmond Analyst - (in Richmond, VA)) VDH Oracle APEX Developer (715866) Create date: 25-Jul-2023 Hybrid Start date :08/07/2023 End Date :06/28/2024 Submission deadline :7/27/2023 Client Info :VDH Description : ------------------------------------------------------ **local candidates strongly preferred **candidates must have strong knowledge with Oracle APEX **candidates.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) ELECT - Cloud Engineer 3 (703495) Create date: 22-Feb-2023 Hybrid Start date :03/06/2023 End Date :12/31/2023 Submission deadline :2/27/2023 Client Info :ELECT Description : --------------------------------------------- ON SITE as requested by Mgr/Team Lead. Schedule TBD. The VA Department of Elections (ELECT) is seeking a Cloud En.... (This job is for - job Jobs in VA Richmond Engineer - (in Richmond, VA)) VDH Business Analyst 3 (703449) Create date: 14-Feb-2023 Start date :03/06/2023 End Date :06/30/2023 Submission deadline :2/16/2023 Client Info :VDH Description : --------------------------------------------- * candidates should be local to Richmond, VA in order to work onsite at least one day each week *parking not provided *assignment to b.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) TAX - Sr. AUTOMATED QA Test Engineer (690200) Create date: 11-Aug-2022 Start date :08/29/2022 End Date :12/31/2022 Submission deadline :8/15/2022 Client Info :TAX Description : TAX - QA Automated Test Analyst. ON SITE Info to note: Currently, contractors are allowed to work remotely until further notice from the Government. As per current situation, if.... (This job is for - job Jobs in VA Richmond Engineer - (in Richmond, VA))    SQL Analyst job openings in other states Jobs List DCY - Programmer 5 (764660) Create date: 29-May-2025 Start date : 06/23/2025 End Date : 06/30/2026 Submission deadline : 06/03/2025 Client Info : DCY Note: * In Person Interviews * On Site 5 days a week to start - potential for hybrid later * Local candidates to Columbus, Ohio highly preferred Would like candidate to st.... (This job is for - JavaScript CSS Jobs in OH Columbus Consultant - (in Columbus, OH)) NCDOT - AASHTOWare Project Data Analytics (751368) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 12/09/2024 End Date : 12/18/2025 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ***The candidate will need to use their own equipment from home to remote into the worksite (PC set up in the organizatio.... (This job is for - Team Work Jobs in NC Raleigh Analyst - (in Raleigh, NC)) NCDOT - AASHTOWare Project (AWP) Developer (751410) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 01/13/2025 End Date : 01/23/2026 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ---------------------------------------------------- ****Preference will be given to candidates living in North Caro.... (This job is for - Programming Jobs in NC Raleigh Consultant - (in Raleigh, NC)) NCDOT - AASHTOWare Project (AWP) Developer (751406) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 01/13/2025 End Date : 01/23/2026 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ****Preference will be given to candidates living in North Carolina.The candidate will need to use their own equipment.... (This job is for - SCRUM Jobs in NC Raleigh Consultant - (in Raleigh, NC)) NCDOT - Technical Specialist- Junior (749745) Create date: 31-Oct-2024 No of Submissions : 2 Start date : 10/19/2024 End Date : 10/18/2025 Submission deadline : 11/06/2024 Client Info : NCDOT Note: * Agency Interview Type : Webcam Interview Only * Hybrid Description : *The candidate must come onsite on the first d.... (This job is for - Azure Jobs in NC Raleigh Specialist - (in Raleigh, NC))    SQL Analyst job openings in VA Jobs List ABC - Applications Analyst (681700) Create date: 25-Apr-2022 Start Date :05/02/2022 End Date : 06/30/2022 Submission Date : 4/28/2022 Client Info: ABC Description: Actual Duration Expected: Do not go by the 6/30 date in Vector (that is based on POs fiscal yr end). This engagement is expected to go 12 months. Parking is available on site for .... (This job is for - WM Jobs in VA Mechanicsville Analyst - (in Mechanicsville, VA)) (Analyst: SQL Analyst, T-SQL, Data Analysis, Power BI Data Visualization in Richmond, VA)

Featured Jobs GIS MICROSOFT Azure Developer (Jobs in Richmond, Virginia) Facilitation Analyst (Jobs in Richmond, Virginia) Testing Developer (Jobs in Madison, Wisconsin) Communication Analyst (Jobs in Madison, Wisconsin) JavaScript Agile Architect (Jobs in Madison, Wisconsin) ADFS RACF Access Analyst (Jobs in Madison, Wisconsin) Integration Azure Docker Architect (Jobs in Richmond, Virginia) Configuration Microsoft Consultant (Jobs in Petersburg, Virginia) Cobol DB2 CICS SQL Architect (Jobs in Madison, Wisconsin) - Consultant (Jobs in Bismarck, North Dakota)