Business Intelligence Analyst( Power BI, T-SQL and Project Management) - Triune Infomatics

Oakland, CA 94612

About the Job

Business Intelligence Analyst( Power BI, T-SQL and Project Management)
Contract To Hire
San Leandro, CA – Hybrid

Must - Project management experience, strong Power BI, Reporting tools, and TSQL

Major Tasks, Duties and Responsibilities:

Data Extraction and analysis of organizational data
Compiling data regarding various challenges and offering remedies that improve the operation of processes and systems
Analyzing business requirements and processes and recommending them to management for implementation
Creating and maintaining documentation that includes the design, requirements and training materials for the organization.
Identifying the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and optimization
Write specifications, develop visualization concepts, artifact and contribute to BI roadmap
Partner with stakeholders to understand their specific reporting needs and requirements, and develop using the Microsoft PowerBI platform
Provide thought leadership, best practices, and standards related to effectively managing an analytics technology platform based on PowerBI, SQL Data Warehouse, and or Snowflake
Support monitoring and reporting on BI platform, provide visibility into resource utilization, identify and recommend areas of improvement
Evaluate and report on effectiveness and usability of solutions based on quantitative usage data and qualitative discussions with end-users and stakeholders
Collaborate with data architect and data engineer team to identify key cross-sector data, data cleansing and completeness processes for source systems
Designing, developing, implementing, monitoring and updating business intelligence tools, systems, databases, dashboards, spreadsheets, data outputs, and other methods in order to collect, model, research, analyze, interpret, present, or report on areas of focus for HCSA
Support HCSA IS Business Intelligence team in data analysis and reporting services design, development, management, maintenance, and program coordination in relation to HCSA SHIE (Social Data Health Information Exchange) data & analytics service fulfillment to intra-agency and external customers.
Supports HCSA IS Business Intelligence team in working with internal/external stakeholders requesting data to:
- Develop data and report requests to meet their program needs.
- Design or identify proxy measures when needed.
- Translate stakeholder program data needs to technical staff and technical capacity to stakeholders.
- Provide recommendations on additional useful analytics drawn from previous report development experience using cross-sector SHIE data.
- Refine data visualization requests to provide meaningful and actionable results.

Required Education and Experience:

1 plus years of experience in Health Care, Public Sector or related informatics field, performance management, or analysis with strong database SQL skills
2 plus years of experience with PowerBI for dashboard development required.
2 plus years of experience with leading processes analyzing large, complex, and varied data sets, using current analytical tools to create reports, visualizations, other artifacts to inform decision-making.
Ability to write intermediate/advanced queries using SQL required.
Working knowledge of Snowflake, SQL database concepts

Knowledge/Skills/Abilities Required/Preferred:

Experience preferred with big data platforms, data warehousing, data lake/data mart, and data hub concepts.
Experience preferred with analytics tools/capabilities including SQL, SQL DB, Snowflake, PowerBI, Data Structure Algorithms and use of Python, R, and DAX language.
Experience preferred with the software development lifecycle and project management ticket-based work request or issue tracking software such as Azure DevOPs or JIRA

Source : Triune Infomatics