Associate Business Intelligence Developer Jobs in California

Advanced organizational and project management skills.

Nine years of related experience, education/training, OR a Bachelor’s degree in related area plus five years of related experience/training.

Advanced critical thinking and problem-solving skills to manage highly-complex information, assess problems, and develop effective solutions.

Advanced interpersonal skills for effective collaboration with managers, professional and technical staff.

Strong knowledge of data visualization techniques and dashboard design using Tableau.

In-depth knowledge of business intelligence functions, advanced analytics, industry standards and best practices.

Develop comprehensive dashboards to track revenue and operational metrics.

Transform complex data into actionable insights, enable data-driven decision making.

Maintain and improve data pipelines, extracting raw data from various APIs (Stripe, WooCommerce, etc.), cleaning and consolidating it for unified analysis.

Automate routine tasks, freeing teams to focus on high-impact work.

A strong inclination towards analytical problem-solving. Comfortable and enthusiastic about manipulating large and complex datasets to reveal practical, impactful solutions.

Proficiency in building scalable, efficient solutions to complex problems. Ability to continuously improve processes using data, automation and documentation.

At least 5 years of experience of developing data model and data reports in PowerBI.

At least 5 years of experience of designing and developing data analytic reports, dashboards, Business Intelligence reports, and data warehouses.

At least 3 years of experience with Advanced Data Analytics or Machine Learning technologies.

Bachelor’s degree or equivalent experience in Computer Science, Information Technology, or similar field of study. (Please provide copy of bachelor degree)

Certifications of Business Intelligence, or Advanced Data Analytics, or Machine Learning. (Please provide copies of certifications)

Experience with Agile methodologies and Software Development life cycle.

· Experience using project management tools (Zoho, Monday, Trello, etc.)

· Working knowledge of SQL (ability to write SQL queries).

· Experience working with databases, data modeling, warehousing, and building ETL pipelines.

· Experience with data visualization tools (Domo, Power BI, Tableau, or others).

· Knowledge of Agile Software Development Lifecycle.

· Knowledge of Linux, Git, VMs, Docker, k8s, and Machine Learning tools/libraries/packages.

Certifications of Business Intelligence, or Advanced Data Analytics, or Machine Learning. CalSTRS

Experience with Agile methodologies and Software Development life cycle.

Experience in State agency or Financials or Investment portfolios or other regulated industry highly

Ability to use business knowledge and expertise to build analytical data models and reports that can

Experience with MS Power BI DAX to create tabular models.

Excellent writing skills and documentation skills.

At least 5 years of experience of developing data model and data reports in PowerBI.

At least 5 years of experience of designing and developing data analytic reports, dashboards, Business Intelligence reports, and data warehouses.

At least 3 years of experience with Advanced Data Analytics or Machine Learning technologies.

Experience with Agile methodologies and Software Development life cycle.

Experience in State agency or Financials or Investment portfolios or other regulated industry highly preferred.

Ability to use business knowledge and expertise to build analytical data models and reports that can serve to business users.

Technical knowledge enterprise reporting technologies (Tableau, PowerBI, SSRS); Tableau certification a plus

Maintains and enhances existing dashboard solutions to meet and exceed functionality and performance requirements

2+ years’ experience in developing business intelligence dashboards

Ability to translate business needs into technical requirements

Knowledgeable in dashboarding and data visualization techniques

Strong interpersonal skills for working in a quick moving, dynamic team that is constantly iterating and improving their own work

Strong management skills for planning and executing complex multi-team projects that crosses multiple domains

Make business recommendations, conveying findings at multiple levels including managers and peers through visual displays of quantitative information

4+ years of relevant work experience

3+ years of experience in SQL

3+ years of experience developing reporting solutions and dashboards using visualization tools (e.g. PowerBI, Tableau, Looker)

Experience using data to develop metrics, assess performance, run exploratory analyses, find improvement areas, and generate recommendations to improve business performance

3+ years of work experience in data or business analytics or engineering related field.

2+ Experience working with Python for data analytics.

Strong analytical skills with ability to combine and find patterns across multiple datasets.

Family-building, fertility, adoption and surrogacy benefits

401(k) with employer match, Employee Stock Purchase Plans, and other financial benefits

Voluntary benefits to include: critical illness, hospital indemnity, accident insurance, theft & legal services, and pet insurance

Education and practical experience using common data sources and APIs such as ODBC, OData, MS SQL, and Azure SQL

A firm understanding of software change management process and testing

Work with business teams and finance reporting personnel to analyze data and translate business needs into technical specification

Experience using Power BI, MS Visual Studio is an asset.

Don’t have every single qualification?

Utilize BI platforms and BI tools to develop and maintain self-service data models and repositories

Experience with data pipeline and workflow management tools (Airflow preferred)

Education: BS/MS in Computer Science, Engineering, Information Technology/Systems, another related discipline or relevant experience.

Advanced SQL knowledge and in-depth RDBMS development experience. Strong knowledge of Data Warehousing and Multidimensional Data Modeling

Experience and knowledge in back-end and front-end: SQL Server, HTML, .Net, Python, REST services, JSON, M query, DAX, MDX, SSAS, etc.

Microsoft Power Apps + Dynamics 365 Developer Certification is a plus. Experience creating PowerShell scripts is a plus

Gather, analyze, and document business requirements and translate into technical specifications, prototypes, and end state products

• Experience with Structured Query Language (MS SQL Server, Oracle) required

• Experience in using Hadoop Hive/Impala as data platform for the Qlik reports/dashboards.

• Knowledge in designing, developing, and testing Qlik scripts and User interfaces

• Knowledge of full software development cycle, programming and documentation policies in software development, testing and release

• Exemplifies excellent analytical, and verbal and written communication skills

• Demonstrates strong documentation skills

Utilizes sound knowledge of IS strategies and development tools to translate business requirements into system solutions that meet project requirements

Uses effective analysis skills to elicit business requirements

3 years’ experience working with business intelligence tools that included systems analysis and/or information technology activities

Perform comprehensive analysis, programming design and development activities associated with business intelligence

Interprets and translates functional specifications into appropriate database design documents and technical specifications using department standards

Demonstrates forward thinking by conducting thorough analyses of data requests and changes to implement proposed solutions

• Knowledge about database management, SQL querying, data modeling, Online Analytical Processing.

• Prefer Undergraduate degree and 4-6 years relevant experience or Graduate degree and 2-4 years relevant experience.

• 4-6 years relevant work experience

• Experience in development and administration of BI tools.

• Experience in building rich dashboards, write DAX expressions, and also implement security

• Experience with data security principles and ensure appropriate security practices are embedded in data solutions

3-5 years of relevant experience in healthcare data management

Advanced SQL Management Studio and SQL query experience

Expertise with data management concepts such as data lineage/lifecycle and data warehousing

Manage multiple priorities and proactively communicate issues to Director

Technical skills: Intermediate to Advanced level skills in Microsoft suite of products

Excellent interpersonal, oral and written communication skills

Certifications and/or experience working with Incorta Business Intelligence software.

Interpret business requirements and KPIs to determine optimal BI solutions to meet user needs and translated to technical BI specifications.

Experience in data warehouse design.

Experience in working with one or more BI or Visualization tools end to end (such as Tableau, MicroStrategy, Power BI, etc.).

Strong problem-solving and analytical skills.

Good written, verbal, and interpersonal skills.

Certifications and/or experience working with Incorta Business Intelligence software.

Interpret business requirements and KPIs to determine optimal BI solutions to meet user needs and translated to technical BI specifications.

Experience in data warehouse design.

Experience in working with one or more BI or Visualization tools end to end (such as Tableau, MicroStrategy, Power BI, etc.).

Strong problem-solving and analytical skills.

Good written, verbal, and interpersonal skills.

SPECIAL QUALIFICATIONS (SKILLS, ABILITIES, LICENSE):

Manage user requests for licenses, facilitate onboarding and basic training, and respond to user questions.

Perform business analysis and requirement gathering of assigned projects.

Work autonomously and collaboratively with report requestors, providing guidance to define report requirements and validate results.

Consult with managers, IT, and employee users.

Manage and prioritze with meeting deliverables and expectations.

Participate in design sessions with organizational stakeholders and business owners to design and build data warehouse to meet business requirements.

Conduct or participate in meetings with organizational stakeholders to identify and build Infomart architectures that meet business requirements.

Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement and will produce guidelines to ensure a manageable infrastructure.

Strong design skills in creating data solutions, easy to understand data models and business views

Full understanding of the Structured Query Language (SQL) with the ability to create complex SQL statements within various data structures.

Ability to design, develop, implement, and support SQL products including SSIS packages, Agent jobs, RDLC solutions and more.