T-SQL Denormalized Data Analysis Power BI Analyst (Jobs in Richmond, VA)   Requirement id 137844 Job title Analyst Job location in Richmond, VA Skills required SQL Knowledge, T-SQL, Denormalized, Data Analysis Power BI Open Date 02-Dec-2022 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: SQL Knowledge, T-SQL, Denormalized, Data Analysis Power BI Hybrid Start date :12/19/2022 End Date :06/30/2023 Submission deadline :12/7/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   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 137844 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 Knowledge job openings in Richmond, VA Jobs List ODGA - Power BI Developer (701670) Create date: 06-Jan-2023 start date: 01/30/2023 End date: 07/30/2023 submission deadline: 1/11/2023 client info : SOA Note : * 4 DAYS IN-OFFICE, 1 DAY REMOTE, LOCAL CANDIDATES ONLY * Hybrid * Web Cam Interview Only Description: The Virginia Office of Data Governance and .... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) DOE-Sr Tableau Programmer Analyst-(697001) Create date: 01-Nov-2022 Remote Start date :11/14/2022 End Date :06/30/2023 Submission deadline :11/3/2022 Client Info :DOE Description : UPDATE from Mgr: We have decided to go in a different direction for many of the Tableau projects, but still need someone part-time (20 hour/wk) to do some of the work, inc.... (This job is for - Tableau Jobs in VA Richmond Analyst - (in Richmond, VA))    SQL Knowledge job openings in other states Jobs List ITSAC 40523R0006837 Data Analyst/Report Writer 2 -SP Create date: 03-Jan-2023 Bid URL: Note: Total estimated hours per Candidate shall not exceed 1176 hours. Submission Deadline: 1/10/2023 5:00 PM CT Start Date: 2/1/2023 End Date : 8/31/2023 Client: Texas Department of Public Safety (DPS) Description: Years Required/Preferred Experience 4 Required Experi.... (This job is for - SQL Jobs in TX Austin Analyst - (in Austin, TX)) Callidus Software Developer - 72158 Create date: 19-Feb-2021 Candidate must be our W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Candidates RTR form should be only on the name of APEX Systems Description: Job Description a. CALLIDUS EXPERIENCE b. SQL knowledge—basic knowledge, un.... (This job is for - CALLIDUS Communication Jobs in NC Charlotte Developer - (in Charlotte, NC)) Business Analyst 3 (608935) Create date: 22-Oct-2019 start date:11/4/2019 End date:10/30/2020 submission deadline: 10/28/2019 client info :DTMB- CEPI Description:Years of Experience: 8-11 years of experience in the field or in a related area. Job Description: Relies on experience and judgment to plan and a.... (This job is for - Jobs in MI Lansing Analyst - (in Lansing, MI)) ITS63 Business Analyst II -SP Create date: 23-Aug-2019 Bid Number: BD-20-1107-1107T-TRC01-43276 Note: Online Submission Note: Total number of positions sought: 2 Note: Maximum number of resumes per ITS63 Vendor: 2 Submission Deadline: 9/6/2019 04:00:00 PM EST Start Date: 9/16/2019 End Date: 3/15/2020 Client: Trial Court Description: .... (This job is for - Oracle MS Office Jobs in MA Boston Analyst - (in Boston, MA)) Test Data Management - J-11-423-076 Create date: 05-Jul-2019 start date:7/3/2019 End date:01/03/2020 submission deadline:7/3/2019 Description: Test Data Managem Good Knowledge in Test Data Management, Testing capabilities and BFS domain knowledge will be added advantage with Good Knowledge inAgile methodolog.... (This job is for - JMeter Jobs in OH Cleveland Consultant - (in Cleveland, OH))     (Analyst: SQL Knowledge, T-SQL, Denormalized, Data Analysis Power BI in Richmond, VA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)