What are the responsibilities and job description for the Data Analyst position at Apollo ITS?
Job Title : Data Analyst
Location : Charlottesville, VA-Hybrid
Duration : 10 Months
Note :
Mgr agrees to initial Virtual IVs but reserves the option to request an IN PERSON IV if needed .
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.
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.
Job Description :
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.
Required Skills :
Proficiency with SQL Server
Expertise in designing, developing, and deploying SSRS reports
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 turning, data modeling, and data validation
Work with partner and internal stakeholders to develop reports or address data access and visualization needs.
Experience in data modeling with strong and demonstratable data management skills
Power BI report development
Experience with Azure data warehouse 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.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Data Analyst?
Sign up to receive alerts about other jobs on the Data Analyst career path by checking the boxes next to the positions that interest you.
