744695 |
Albemarle County - Data Analyst 2 |
Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.
We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.
YSI is seeking a highly qualified Data Analyst 2. The selected candidate will be able to communicate effectively (written/verbal), possess strong interpersonal skills, be self-motivated, and be innovative in a fast-paced environment.
Data Analyst needed to create, customize SSRS reports, analyze, clean and load SQL data for migration project, create Business Intelligence reports and dashboards.
The selected candidate must be able to work IN PERSON (ON SITE) for the first full week (5 days) of the engagement - then a minimum of one day a week ON SITE thereafter REQUIRED. The candidate must have access to broadband internet and a home office free from distractions to qualify for remote work. The candidate can optionally work in person if preferred. Pls do not submit if they cannot agree to this arrangement.
Additional in-person days may be necessary for meetings with clients.
Parking is free at our facilities.
The employee cannot have billable hours on our government holidays.
Must work independently or as part of a small team on projects.
Years of Experience: 4-6
Days on Site per week: 1-2
Day to day responsibilities
Initial workload will be heavily focused on creation of SSRS reports, utilizing mockups provided by a configuration team to customize standard vendor provided reports.
Working on ETL processes to clean and load data to on-prem and cloud databases, SQL Server scripting and querying, and Business Intelligence report creation are other likely duties.
The Data Analyst will work with other ACIT team members, department stakeholders, vendors, and partners in the design, development and implementation of reporting, integration and data analytics solutions.
Required Skills
- Expertise in designing, developing, and deploying SSRS reports.
- Proficiency with SQL Server
- Strong knowledge of SQL for querying relational databases
- Experience with complex queries, joins, subqueries, and data manipulation.
- Perform data analysis, data profiling, SQL coding/query tuning, data modeling, and data validation
- Work and partner with internal stakeholders to develop reports or address data access and visualization needs
- Experience in data modeling with strong and demonstratable data management skills
Desired Skills/Experience
- Power BI report development
- Experience with Azure data warehousing solutions
- Experience with Azure ETL (Extract, Transform, Load) processes and tools
- Experience with Microsoft Fabric
- Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.
YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
|