Senior Data Analyst

Top Technical Skills (Must haves):

• Active Secret Clearance
• Proficiency in Power BI, including dashboards, reports, and advanced DAX (DAX (Data Analysis Expressions) to perform calculations and data analysis and to perform real-time data analysis.
• Strong knowledge of SQL for data analysis and extraction.
• Experience with data modeling and ETL processes.
• Proven experience in data analysis, visualization, and reporting, preferably within a government or similar environment.

Job Description:

• The Data Analyst is a highly skilled and analytical individual who will provide critical support to a government customer and all teams on the program. This role focuses on delivering comprehensive project assistance and advanced data visualization solutions, particularly for the team on the program focusing on Control Systems. The ideal candidate will utilize their expertise in Power BI and data analytics to transform complex datasets into clear, actionable insights that inform strategic decisions. Success in this position requires a strong blend of technical proficiency, problem-solving abilities, and exceptional organizational skills to effectively meet program objectives and reporting requirements. The Data Analyst will work collaboratively with a multidisciplinary team to develop effective solutions for managing and visualizing large datasets, ensuring complex information is presented in a clear and accessible format.
• In addition to their primary responsibilities, the Data Analyst will support various team projects and initiatives as needed. This role may require the individual to take on additional tasks to assist with workload distribution and team effectiveness, thereby ensuring the overall success of the department. They will help move from one data repository to Power BI.

Data Analysis and Visualization:

• Conduct research, planning, analysis, and organization of technical and statistical data for use in briefings, reports, and publications.
• Consolidate and integrate data from multiple sources to generate accurate and actionable data elements.
• Utilize Power BI to analyze data and develop dynamic dashboards and interactive visual reports to facilitate informed decision-making.
• Utilize Power BI to design and develop interactive dashboards and reports that provide actionable insights.
• Leverage APIs to connect and integrate data from various sources into Power BI for seamless analysis and visualization.
• Optimize Power BI solutions by creating advanced data models, implementing DAX functions, and enabling dynamic filtering and drill-down capabilities.
• Collaborate with stakeholders to translate business needs into technical specifications and deliver tailored Power BI solutions.
• Ensure dashboards are scalable, user-friendly, and provide real-time updates to support decision-making processes.
• Establish and monitor key performance indicators (KPIs) to ensure alignment with program objectives and performance goals.

Data Modeling and Reporting:

• Design, develop, and maintain complex data models to enhance business analysis and reporting capabilities.
• Create, test, and deploy Power BI scripts, leveraging advanced DAX queries and functions to ensure accurate and efficient data visualization.
• Utilize SQL queries to extract, transform, and analyze data, optimizing it for reporting and visualization needs.
• Document data workflows and processes, including detailed explanations of algorithms, parameters, models, and data relationships, to ensure clarity and reproducibility.