Sr. Data Analyst

Overview :

The Office of Performance Analysis and Integrity manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) which resides on one Oracle M8 Supercluster database and thirteen application servers.

Our team provides the technical services required to sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications as well as enhancement and maintenance of business intelligence capabilities and predictive analytics.

• Large databased envt - The EDW system environment is comprised of three core elements, each of which are defined below.
• The EDW hardware (EDW-H) currently consists of one Oracle M8 Supercluster database and thirteen (13) application servers that are configured to operate on the Windows, Linux and UNIX platforms.

The EDW Database (EDW-D) and Tools consists of approximately 442 schemas (Transactional Snapshots and Star Schemas) and 85,029 tables which are updated on a daily, weekly, and monthly basis as required to meet the business community’s requirements. The EDW-D environment also includes the tools leveraged to develop the reports such as Oracle Databases, GoldenGate, APEX, OBIEE, Tableau, Informatica, PowerBI, SAS, C#, .NET, etc.

Responsibilities:

• A Senior Data Analyst has min of 5-10 years exp In this capacity, the Senior Data Analyst builds statistical models, diagnoses, validates, and improves the performance of these models over time in addition to creating efficient and reusable SQL code meant for the improvement, manipulation, and analysis of data. The Senior Data Analyst is also tasked with the regular maintenance and upgrade of data warehouse servers such as SQL and provides technical and extensive experience in the coordination of program and project leaders to identify requirements for system architecture.
• The Senior Data Analyst has to have had at least 5 years in a Data Analyst position, preferably working as a Data Analyst in a fast-paced and dynamic business setting. The Senior Data Analyst will also have had experience working in report creation, modeling, and trend forecasting. A suitable candidate will have a strong background in SQL as well as experience performing administrative tasks on servers such as SQL.
• The Senior Data Analyst will also demonstrate an ability to create, troubleshoot, and enhance the business’s data loadings. He will additionally have a clear understanding of key IT business systems, reporting and analytics, general ledger management, and data warehousing.

Core Technology Skills:

• SQL (Structured Query Language): Proficiency in SQL is crucial for querying databases, data manipulation, and analysis. A senior analyst should be adept at complex query writing, optimizing queries for performance, and understanding database schemas.
• MySQL: Experience with MySQL or similar relational database management systems (RDBMS) for creating, accessing, and managing databases.
• TOAD (Tool for Oracle Application Developers) or Similar Database Tools: Knowledge of TOAD or equivalent tools like SQL Developer for database management, development, and optimization.
• Data Visualization Tools: Proficiency in Tableau, Power BI, or similar tools for creating dashboards and visualizations that communicate data insights effectively.
• Python/R for Data Analysis: Ability to use Python or R for data manipulation, statistical analysis, and machine learning. Familiarity with libraries like Pandas, NumPy, SciPy, and Scikit-learn is advantageous.
• Data Warehousing and ETL Tools: Experience with data warehousing concepts and ETL (Extract, Transform, Load) processes and tools such as Informatica, Talend, or SSIS for data integration and transformation.

Soft Skills:

• Analytical Thinking: Ability to think critically, analyze complex data sets, and derive actionable insights.
• Communication Skills: Excellent verbal and written communication skills for explaining data insights and recommendations to both technical and non-technical stakeholders.
• Problem-Solving: Strong problem-solving skills to tackle data-related challenges and provide effective solutions.
• Project Management: Ability to manage multiple projects, prioritize tasks, and meet deadlines in a fast-paced environment.
• Collaboration: Proficient in working collaboratively with cross-functional teams, including data engineers, business analysts, and decision-makers.

Additional Skills:

• Data Governance and Quality: Understanding of data governance principles and practices to ensure data integrity and quality.
• Business Acumen: Strong understanding of business processes and objectives to align data analysis with strategic goals.
• Regulatory Compliance: Awareness of data privacy and protection regulations relevant to the industry (e.g., GDPR, HIPAA).

A Senior Data Analyst with this skill set is well-equipped to handle complex data analysis projects, provide insights that drive strategic decisions, and lead initiatives that enhance data-driven cultures within organizations.
Excellent problem-solving skills and the ability to work under pressure.
Strong communication skills and a collaborative mindset.
Must be authorized to work for any employer in the U.S.
Must be able to obtain and maintain the required security clearance.
Must be authorized to work for any employer in the U.S.
Must be able to obtain and maintain the required security clearance.

Job is on site and could eventually go hybrid.

Job Type: Full-time

Pay: $85,404.00 - $102,715.00 per year

Benefits:

• Dental insurance
• Health insurance
• Paid time off
• Retirement plan

Schedule:

• 8 hour shift

Experience:

• Data analysis skills: 5 years (Required)

Ability to Commute:

• Washington, DC 20006 (Required)

Ability to Relocate:

• Washington, DC 20006: Relocate before starting work (Required)

Work Location: In person