Business Intelligence Analyst

Why join our team?

With a mission that spans the globe, the USO provides a rewarding and fulfilling work environment. Our team is exceptional, and we offer generous paid time off, including volunteer days and military leave. We have a remarkable 401k match, comprehensive benefits, and opportunities for training and education reimbursement. Our team members are passionate about putting the mission first, and we have a lot of fun while doing it. Working for the USO isn't just a job - it's a calling, and we believe in doing what you love and loving what you do.

Don't take our word for it. The external "Great Place To Work" survey found that:

• The USO is a Certified Great Place to Work 2023-2024
• 93% feel good about the ways we contribute to the community.
• 93% are proud to tell others they work here.
• 88% feel their work has special meaning: this is not "just a job."
• 89% feel that when you join the company, you are made to feel welcome.
• 91% feel people here are treated fairly regardless of their race.
• 87% feel people here are treated fairly regardless of their gender.

The Business Intelligence Analyst is responsible for gathering data from enterprise and adhoc sources to prepare and organize it in efficient information mart-type data models to provide ad hoc reporting, data analysis and creating dashboards as needed for the operation success of the USO Development and Marketing Enterprise. The expectation of this position is to provide directive driven reporting and dashboard development in a timely manner. The Business Intelligence Analyst will use tools, techniques, and best practices to effectively extract value and insights to develop quality reporting deliverables, and effective reporting throughout the department.

Principal Duties and Responsibilities (*Essential Duties)

• Drive return on investment in USO's data infrastructure to produce data-informed insights more reliably and rapidly. *
• Develop frameworks and deliver analyses to lead executive-level decision-making and prioritization across the organization. *
• Collect and query data from different sources such as the enterprise data lake and data lake house databases, spreadsheets, and file exports from software applications to enhance insights, process data leveraging statistical packages, and create tools and models to identify donor and revenue trends, primarily through an Azure Databricks, Microsoft PowerBI, & Microsoft Excel based ecosystem. *
• Prepare and model data as information marts following industry standards and best practices.
• Develop and lead internal data fluency training efforts and new user training for data analytics tools. *
• Develop and maintain documentation such as data dictionaries, data models, data workflows, user guides and working instructions to define a common language across Development teams and support the creation of curated master data sets used for effective cross-team / cross-data source reporting.
• Processes reporting requests daily, either requiring the execution of existing reports, or creation of new solutions. At times reports will need to be adjusted or updated to fit the changing needs of the department, while considering for specific requests in data. Responsible for interpreting organizational needs and presenting data in a way that will drive successful organizational decisions.
• Expected to support reviewing and testing files for compatibility and stability, often working with large data sets. Expected to remain inquisitive and forward-thinking in technology integration, reporting platforms, individual records management, and overall approaches to information accuracy, in order to support the long-term growth in data maturity at the Organization.
• Cross-collaboration with the Department of Information Technology to ensure reporting and operational redundancies for institutional continuity.
• Collaborate with other teams to ensure data quality, integrity, accuracy, and consistency. Identify and resolve data issues in partnership with technical owners, system owners, and data stewards.
• Apply statistical, descriptive, and other analytical techniques in conjunction with USO's standard tools and technology to interpret data, uncover patterns, trends, and correlations that lead executive-level decision-making and prioritization across the organization.
• Ideate, design, develop, test, and maintain clear, concise, and actionable interactive reports, dashboards, and visualizations to effectively present findings and insights to business leaders and decision makers.
• Conduct ad-hoc analysis to address specific business questions and provide actionable recommendations.
• Makes edits in Database to ensure accurate data while validating reports that have been written.
• Collaborates with cross-functional teams to refine data collection processes, increase end-to-end data quality, and improve overall organizational BI capabilities.
• Other duties as assigned.

Job Specifications

• Bachelor's Degree in Business Administration, Information/Data Sciences, or closely related field.
• 5+ years of proven experience as a Data Analyst, Business Intelligence Analyst, or similar role in the data management field with full understanding and practice of the reporting analytics from design to implementation. Experience at a not-for-profit, military, multicultural and/or global organization is a plus.
• 3+ years of hands-on experience using SQL for querying data and the Power BI (PBI) platform (both PBI Desktop and PBI Services) to extract, model, and report data. Familiarity with Spark SQL is a plus.
• 3+ years of hands-on experience using Microsoft Power BI and creating dashboards.
• Proven experience with statistics and data modeling for the purposes of data analysis and forecasting, as well as ability to present results and methods in a meaningful way for operational and business planning.
• Advanced analytical skills with the ability to interpret complex datasets and communicate findings effectively.
• Experience working with large datasets and databases. Preferably from data lakes and lake houses.
• Experience with star-schema data modeling for information marts.
• Excellent problem-solving and critical-thinking abilities.
• Must show initiative, self-motivation, creativity, and desire to innovate with strong attention to detail and quality.
• Strong interpersonal, communication, and presentation skills with the ability to communicate complex findings to non-technical stakeholders in simple ways and collaborate effectively with cross-functional teams.
• Ability to learn and stay current with industry trends and best practices in data analytics and business intelligence.
• Ability to work independently and manage multiple projects simultaneously.
• Excellent verbal and written communication skills.
• Strong interpersonal, customer service and problem-solving skills. Ability to articulate and translate technical concepts to a non-technical audience.
• Must show initiative, self-motivation, desire to innovate, and attention to detail and quality.
• Ability to obtain and maintain proper credentials necessary to access USO Center locations and facilities including but not limited to security, credit and/or background screening, SOFA status, valid driver's license.
• Must be a strong advocate of the USO's mission to lift the spirits of America's troops and their families.

Details

• This position is a remote position.
• USO locations will adhere to local area and DOD guidelines regarding COVID vaccination/testing requirements. Employees may be required to be vaccinated or tested regularly per local requirements.
• Resume and cover letter are required for full consideration.
• Background check - education, criminal and driving required.
• The statements contained herein describe the scope of the responsibility and essential functions of this position but should not be considered to be an all-inclusive listing of work requirements. Individuals may perform other duties as assigned including work in other areas to cover absences or relief to equalize peak work periods or otherwise balance the workload.

If that's not enough to convince you, here are some direct quotes from employees:

• The organization truly cares about the people who work here.
• I have been with the USO for 4 years and have consistently been able to grow in my knowledge and position. It is a fun place to work and my work/life balance is manageable. The way the organization has handled COVID has been top notch - I never felt fearful that I would lose my job or be put in a situation where I did not feel safe. The benefits are great - PTO and 401k matching are top level.
• There is great consideration given and extended in the following areas: organizational core values for all, work-life balance, impact we can actually see (and even experience as a staff member- the feeling of making an impact is priceless), autonomy with respect to current position within the organization.
• Everyone is friendly and easy to talk to. We collaborate well together and share ideas and interests to create fun activities for our overall goal in the community. I couldn't think of a better organization to work for.
• The mission alone provides a positive and meaningful purpose, where people should want to work and be a part of. Most of the people who work for the USO and volunteer for the USO have giving hearts and want to make a difference. This also makes the organization a place where people would want to work.
• The mission and opportunities to make a Difference are amazing. There is no doubt that the USO is one of the most forward-facing, frontline serving nonprofits that I know of.

#theUSO

Apply today. Join the mission. Join Team USO.