Coordinate continuous improvement initiative ideas between personnel and management using established tools
Produce daily, weekly, and/or monthly reports, ensuring accuracy and relevance
Regularly examines data reports to identify and resolve data integrity issues
Participate in projects and other tasks assigned
Communicate the results of data analysis in written and verbal form to managers and external stakeholders, ensuring clarity and actionable insights
Process and safeguard confidential data and information with the highest level of integrity
Report development and maintenance as required to meet program needs
Managing and designing the reporting environment including data sources, security, and metadata
Support the program by revising reporting to meet new business requirements including initiatives for data integrity across all tools and reports
Assess tests and implement new or upgraded software while assisting with strategic decisions on new systems
Generate complex reports from single or multiple data sources ensuring comprehensive data analysis
Troubleshooting the reporting database environment ensuring tools and reports are working with the latest software revision requirements
Assemble large, complex data sets that meet functional/non-functional business
Identify, design, and implement internal process improvements including automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading data from a wide variety of data sources using Microsoft Excel, SQL procedures/queries, and other internally developed tools
Create data tools for analytics and team members that assist them in building and optimizing product workflows

Requirements

Ability to obtain a Public Trust Clearance
Bachelor’s Degree and a minimum of 6 years of prior relevant experience; Graduate Degree and a minimum of 4 years of prior related experience; Or, in lieu of a degree, a minimum of 10 years of prior related experience
2+ years of prior experience and understanding of Metrics principles, processes, and producing reports
Expert level experience in Microsoft Excel and Microsoft Office products
Self-directed and comfortable supporting the data needs of multiple teams, systems, and products
Analytical skills that allow for the development of data-driven reports
Demonstrated ability to manage time and prioritize projects to meet deadlines
Ability to use Microsoft Excel to create pivot tables, graphs and charts
Experience generating SQL procedures/queries necessary to pull analysis data from various databases
Experience using SQL Server Reporting Services (SSRS) tool to generate reports and metrics
Strong statistical and business metrics/performance analysis experience
Work experience as a data/business intelligence analyst, data engineer, or in related functions

Benefits

health and disability insurance
401(k) match
flexible spending accounts
EAP
education assistance
parental leave
paid time off
company-paid holidays

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

data analysisreport developmentdata integritydata extractiondata transformationdata loadingSQL procedurespivot tablesgraphscharts

Soft skills

analytical skillstime managementprioritizationself-directedcommunicationproblem-solvingcollaborationattention to detailadaptabilityinitiative

Certifications

Public Trust Clearance