Apply on Employer Site

Committee for Children · 5 hours ago

BI Data Analyst

United States

Full-time

Remote

Senior Level

$110K/yr - $125K/yr

5+ years exp

Committee for Children is a social enterprise dedicated to advancing the well-being of children through the development of essential human skills. As a BI Data Analyst, you will interpret and analyze complex datasets to provide actionable insights that drive decision-making processes and collaborate with cross-functional teams to develop data-driven strategies and create visual reports for stakeholders.

EducationNon Profit

Responsibilities

Develop and maintain datasets, data models, and data visualizations to support business decisions

Develop different data warehouse designs like star schema, snowflake schema, and dimensional modeling

Identify data sources, definitions, and timelines appropriate for analysis

Write, optimize and maintain complex SQL queries to support data analysis and reporting needs

Develop and generate ad hoc reports based on stakeholder requirements to support decision making processes in various departments

Work with Fabric to connect to various data sources such as databases, cloud storage, or APIs

Integrate data warehouse with business intelligence tools to create reports and dashboards

Design and build interactive reports using Power BI to present findings and identify trends to stakeholders

Ensure data quality and integrity by identifying and resolving data issues

Perform root cause analysis and uncover core issues using data, then assist the organization to improve

Analyze and interpret various sources of internal data and external data sources to support business decision-making

Design, build and maintain automated workflows using Power Automate to streamline business processes

Identify opportunities for process improvement and develop solutions to reduce manual effort

Qualification

Power BISQLData warehousingETL processesMicrosoft Fabric AnalyticsExcelAnalytical skillsCritical thinkingProblem-solvingTeam collaboration

Required

5+ years' experience working with relational database systems

5+ years' experience performing business and financial analysis

3+ years' experience working with Power BI to develop reports and dashboards

Advanced proficiency in Power BI (Power Query M, DAX), Power Automate, Excel, SQL, and Microsoft Fabric Analytics

Experience with ETL processes, data warehousing, subscription business models, and SaaS KPIs

Experience with different data warehouse designs

Ability to prioritize tasks and manage work efficiently maintaining a high level of productivity

Demonstrated ability to navigate and articulate the workflow between data warehousing, data transformation, and reporting tools to ensure accuracy and relevance of insights generated

Experience working independently and in a team-oriented, collaborative environment

Strong critical thinking, analytical, and problem-solving skills

Sound decision making, discretion, and confidentiality

This role involves occasional travel to the Seattle office, typically between 1 to 4 times per year

Preferred

Experience with ERP systems (NetSuite preferred)

Benefits

We cover 100% of your premiums for medical, dental and vision coverage and 50% for your dependent’s medical and dental premiums

Retirement plan + company match up to 3%; CFC also may make an annual discretionary non-elective contribution on your behalf at the end of the year!

A flexible work subsidy: $100 per month that you can use on things like phone and internet costs, office supplies, or even commuting costs

16 paid holidays (including winter break and 1 floating holiday), 3 weeks' vacation in your first year, and separate sick leave accrual

Other great benefits include: monthly contribution to childcare and/or dependent expenses, FSA account, parental leave, sabbatical leave, employee assistance program, annual wellness reimbursement, growth and development opportunities, disability and life insurance.