Data Analyst

At Bitfocus, our employees are the foundation of our success as an industry-leading software company. We are a team of talented, hard-working individuals who are passionate about the mission of ending homelessness. We strive to live by our core values and foster a culture of respect, collaboration, and inclusion. We actively look for ways to continue developing our foundation at all levels at Bitfocus.

We also believe in having fun and cultivating a positive environment where employees can bring their whole selves to work. We recognize that everyone brings unique perspectives, experiences, and strengths. We believe in supporting and developing our employees to provide an 11-star experience to our customers and ultimately help communities use data to tackle their greatest social challenges.

We hope you consider bringing your talent and drive, and join us in helping end homelessness!

We seek a highly motivated and experienced Data Analyst to join our Data Services team. The successful candidate will be responsible for working closely with internal and external teams to support, design, and develop custom dashboards, act as a subject matter expert on federal reporting requirements, analyze, transform, and load data from external systems into Clarity Human Services, and complete ad-hoc projects as assigned. This position ensures accurate and timely data reporting and provides insights to drive business decisions. A passion for data, detail, and concern for data integrity is key to success.

Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, veteran status, or disability.

THIS IS A FULLY REMOTE, FULL-TIME POSITION - SUCCESSFUL CANDIDATES WILL BE REQUIRED TO WORK FROM HOME.

Compensation:

We are committed to providing competitive pay and benefits that are in line with industry standards. We analyze and carefully consider several factors when determining compensation, including skills, qualifications and professional experience, which can cause your compensation to vary. This role has an annual targeted total compensation range of $50,000 - $80,000, which includes variable compensation (bonus) eligibility.

About the Data Services Team:

Our Data Services team's mission is to promote a data-driven decision-making culture to solve homelessness. We do this by combining a team of experts in data modeling, analytics, and integration with social services experience. From one-time data migrations into Clarity Human Services to real-time dashboarding, the Data Services team plays an integral role in supporting communities to make data-driven decisions.

As a Data Analyst, you will:

• Support: Provide guidance and support to internal teams to ensure the successful completion of reporting projects and data integration projects. This includes troubleshooting, data analysis, and effective collaboration with other departments. Additionally, actively participate in data analysis and troubleshooting efforts while collaborating effectively with other departments.
• Migration Projects: Manage HUD and custom data migration projects, as well as special projects, ensuring that data is accurately and efficiently integrated into the system
• Database Tools: Demonstrate a basic understanding of database management concepts, knowledge of data security tools/solutions, and basic understanding in SQL, Data Integration tools, data transformation tools, and data analysis tools.
• Design: Assist customers to design and develop custom Looker dashboards as well as designing native dashboards for our product offerings. This includes identifying customer requirements, creating mockups, and implementing dashboards.
• Looker: Utilize Looker proficiently for data analysis, creating and maintaining standard reports and dashboards across various departments. Collaborate closely with stakeholders to define data needs and provide actionable insights. Serve as a subject matter expert on federal reporting requirements and Looker ad-hoc reporting, staying updated on the latest regulations and advising internal teams on compliance. Take ownership of complex reporting projects, including advanced dashboards and analytics, and proactively identify opportunities to optimize data processes while offering valuable insights.
• Learning Agility: Develop learning agility as a Data Analyst by effectively utilizing free online resources like tutorials, webinars, and open-source documentation to enhance proficiency in data analysis and tools. Actively engage in online communities and stay updated on industry trends through free publications and forums to continuously improve skill sets and adapt to evolving demands.
• External and Internal Liaison: Serve as a key liaison between internal teams and data sources, facilitating accurate data collection and ensuring seamless communication. Collaborate effectively with external partners to support data-related initiatives, while also solidifying reporting requirements by acting as a bridge between external partners and internal teams. Proactively gather data requirements from various internal stakeholders and communicate with external partners to clarify needs, gather data, and provide updates on reporting progress. Cultivate and maintain strong relationships with both internal and external stakeholders to enhance data collaboration and insights.
• Ad-Hoc Projects: Complete ad-hoc projects as assigned, which may involve data analysis, report development, or other tasks as needed.

You will love this position if:

• Remote Environment: Working remotely requires excellent communication and organizational skills. Skilled in a completely remote company and be comfortable with the unique challenges that come with remote work, such as coordinating with team members across different time zones and working in virtual environments.
• Documentation: You are skilled in creating clear and organized documentation for data analysis projects and refining skills through feedback and mentorship. You are also skilled in supporting junior team members in enhancing their documentation practices and striving to provide comprehensive records of data analysis processes, methodologies, and insights; and experienced in mentoring junior analysts and aiding them in improving their documentation effectiveness.
• Social Services/HMIS: You haveexperience in social services and/or HMIS is this is vital for a Data Analyst working in the field of homeless services. You are skilled in utilizing Looker proficiently to access and analyze data pertinent to homeless services, generating standard HMIS reports, contributing to data quality efforts, and aiding in the comprehension of homelessness data. You are skilled in precise data collection and reporting through Looker. You are familiar with the issues and challenges facing homeless populations and the ability to understand and analyze data in this field which contributes to data strategy improvements within the HMIS framework.
• Communication: You areskilled in English language proficiency, including reading, writing, and oral communication, with the ability to articulate technical concepts to non-technical stakeholders. You are skilled in communicating data insights to team members and stakeholders and refining communication skills through feedback and mentorship. You are proficient in supporting junior team members in enhancing their communication abilities and providing in-depth explanations of data analysis results and their business implications. You have the ability to mentor junior analysts, assisting them in improving their communication effectiveness.
• Helping Others: You have apassion for using data to drive social impact and are committed to improving the lives of homeless individuals and families.
• Data: You have a strong love for data and use it to make decisions. You should be able to analyze complex datasets, identify patterns, and draw insights that can inform decision-making processes.
• Database Management: You are skilled in MariaDB/MySQL or any database management system.
• ETL: You have ETL tool experience
• Meetings: You are able to conduct productive meetings over the telephone and web, including leading discussions, taking notes, and following up on action items.
• Teamwork: You are ateam player and enjoy working with others towards common goals.
• Independent Work: You areself-directed and results oriented. You should be able to work independently and with others to complete projects on time and deliver high-quality work.
• Interpersonal Skills: Youpossess excellent interpersonal skills and communicate and work effectively with internal and external stakeholders, including clients, partners, and other stakeholders.
• Technology: You are skilled in using Looker, Excel, and other advanced scripting and data visualization tools; and are also skilled in mentoring junior team members in foundational technologies and fostering their growth. You can master various data analysis tools, and expand your knowledge of scripting languages staying abreast of emerging trends in databases, data visualization tools, and programming languages. You are adaptable and willing to learn new technologies and data-related challenges, and are able to stay current in the ever-evolving field of Data.

We're excited about you because:

• A college degree (a major in information systems, computer science, mathematics, finance, accounting, statistics, or a related field is preferred).
• 1+ years of experience with Homeless Management Information Systems (HMIS).
• 1+ years in HMIS custom reporting environments (preferably using Looker).
• Demonstrated understanding of data systems, including data relationships and modeling, with the ability to learn and understand various data environments.
• Demonstrated planning and organizational skills with strong attention to detail.
• Demonstrated ability to handle multiple concurrent projects and priorities in a fast-paced, evolving environment.

Why Bitfocus:

• Opportunity to make a meaningful impact: Join a mission-driven company that is dedicated to using technology for social good and making a positive difference in the world.
• Collaborative and dynamic work environment: Work with a talented and diverse team of professionals who are passionate about innovation and creating solutions that matter.
• A unique, friendly, and caring culture! Hear more from our employees on Glassdoor.
• Work in a fully remote/virtual environment
• Medical, dental, and vision insurance for employees and dependents. (100% employer paid for employee only and 50% employer paid for dependents!)
• Voluntary benefits options include Critical Illness, Hospital, Short-Term Disability, and Long-Term Disability.
• Flexible Spending Account (FSA), Dependent Care Flexible Spending Account, and Health Saving Account options!
• Employer-sponsored life insurance
• 401K retirement plan w/ 4% match.
• One-time $500 Home Office Stipend
• $75 per month towards internet and phone bills
• 100% paid parental leave for 12 weeks for birthing, non-birthing, adoptive, and surrogate parents
• Apple Macbook for your home office