Associate Business Intelligence Developer Jobs in San Diego, 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.

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

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

• 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.

Understands complex business requirements and creates technically sustainable solutions

Shares knowledge and complex topics clearly and concisely in a way that demonstrates patience, collaboration and inclusiveness

Perform other duties and responsibilities as assigned

3+ years’ work experience in Business Intelligence, Reporting or Data Analytics projects

3+ years’ experience in SQL, data relationships/modeling and warehousing concepts

3+ years’ experience using BI tools performing development, deployment, and maintenance

Be experienced with Power Apps and Power Automate

Experience working on Report Builder

Experience in other BI platforms like WebFOCUS and migrating to PowerBI

To create dashboards and visual interactive reports using Power BI

To analyze data and present it through reports that can help in decision-making

To design, develop, and deploy Power BI scripts and perform efficient detailed analysis

Preferred previous experience/working knowledge of health insurance industry, processes and data requirements.

Adheres to coding standards defined by technical management.

Applies knowledge of industry trends and developments to improve service to our clients.

Two (2) years experience in applying quantitative analytics tools, methods and processes.

Strong analytic, problem solving, and troubleshooting skills.

Experience with data visualization, charts, dashboards and reporting tools.

• Experience with data mining and data optimization.

• Proven problem-solving and decision-making skills with strong judgement.

Their role is to develop, enhance and support AI/EXY dashboard using the Power BI tool.

• Performs code reviews, evaluates and recommends alternative solutions when appropriate.

• Builds performant tabular and multi-dimensional models for self-service in Microsoft Power BI.

• Performs other job-related duties as assigned or apparent.

Bachelor’s Degree in Computer Science, Information Management Systems, Business Management, Statistics or equivalent work experience.

A minimum of three (3) years of work experience that include business requirements gathering and business intelligence report writing.

Good interpersonal skills, with the keenness or experience of interacting with global teams of different cultures or nationalities.

Work Location: Medley, FL - hybrid: 3 days onsite & 2 days remotely

Annual Salary Compensation: $80-$85K + Benefits

Proven experience in effectively partnering with business teams to deliver their goals and outcomes by designing user-friendly reports and dashboards.

At least 2+ years experience in purchasing/procurement in manufacturing

Bachelor’s Degree in Computer Science or related field

Proficient in Microsoft Excel, Python and ERP systems a plus

Minimum Education and Experience Requirements:

EMR system experience (Epic preferred)

Strong problem-solving, quantitative and analytical abilities.

Hands-on experience with large relational databases/data warehousing, including ability to query databases using SQL or similar language.

Excel skills, including complex functions, formulas and formatting.

Excellent communication, collaboration and delegation skills.

Solicit business requirements, provide daily support and monitor performance of reporting / analytic solutions.

5+ years of experience in Reporting / Analytic solution development.

Tuition Assistance Program that covers professional continuing education.

Design and develop moderately complex enterprise and departmental business intelligence, data warehousing and reporting solutions.

Create all forms of information delivery including online visualization tools and traditional printed reports.

Ensure reporting / analytic solutions have been tested for accuracy.

Collaborate with key business users to identify needs and opportunities for improved data management and delivery.

Experience working with end-users to gather requirements and build technical solutions from concept to implementation.

Provide technical and business knowledge support to the Business Intelligence (BI) team.

Ensure effective communication of user requirements.

8 - 10 years related experience.

Experience in the design and building of enterprise data warehouses.

Full project management and development life cycle experience.

Assist in the development of data management policies, procedures, and corporate data strategy.

Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Analyze user requirements and, based on findings, design functional specifications for BI front-end applications and analytical tools.

Produce ETL design guidelines and maintain ETL processes to ensure a robust and manageable ETL infrastructure for BI systems.

Proven experience in BI/data warehousing planning and development.

Applies broad knowledge of data integration functions to accurately anticipate system or project impacts.

Ensures unit test is completed and meets the test plan requirements

Advanced skills in performance tuning, monitoring, and troubleshooting data integration solutions

Solid communication, interpersonal, and collaborative skills and a demonstrated ability for creative problem solving of business and technical challenges

Experience moving data to/from the following: Teradata, DB2, Hadoop, SQL Server, Flat Files, DB2, SQL Server

Experience with ETL tools (Informatica, Talend, etc.)

· Must have working knowledge in business intelligence and analytics platforms such as WebFOCUS or Tableau.

· Prior experience in creating dashboards and interactive reporting applications is highly preferred.

· Prior experience in data analytics is highly preferred.

· Must have excellent oral and written communications skills, and demonstrated ability in business writing.

· Must have a Bachelors Degree in Computer Science, Mathematics, or related field.

· Exposure to Object Oriented programming techniques, HTML 5 or JavaScript is preferred.

Knowledge, Skills & Abilities (KSAs):

Work with management and project management offices to develop and maintain project objectives and plans

Bring projects to completion, on time and within budget using the System Design Life Cycle and the established Project Management methodologies

REQUIREMENT: Bachelor’s Degree and 8+ years of related experience, or equivalent combination of experience

Plan, manage, and provide project status following the adopted agency’s Software Development Life-Cycle (SDL) from inception to implementation

Perform unit and integration testing to ensure business requirements are met and programming logic executes as expected

Knowledge and experience with different types of database structures, joins and data blending techniques.

Drive data quality across the business with advanced/expert experience in data engineering and data warehousing.

Maintains knowledge and familiarity with current and emerging technologies, best practices, business processes, industry trends, and information security considerations.

Relevant work experience may serve as a substitute for Bachelor's degree

3-5+ Years’ experience in ETL and Data wrangling.

Mathematical problem solving, statistical, and analytical skills are required.

Experience as a Power BI Developer

Extensive knowledge and expertise in business intelligence, databases, and especially, technical aspects of BI tools (Microsoft Power BI prreferred)

Experience in Microsoft SQL Server and SQL

Strong problem-solving and analytical skills

Understanding business requirements in the BI context and designing data models to convert raw data to meaningful insights.

Ability to work in a team.

Knowledge of SQL queries and SQL Server Management Studio.

Strong understanding of database management systems, online analytical processing, and ETL frameworks.

SQL Server Management Studio (SSMS)

Medical, Dental, Prescription & Vision Benefits

Industry experience as a BI Developer or Data Scientist.

Possesses excellent interpersonal communication skills.

Identify and leverage opportunities to continually improve the quality of data management systems, processes, and standards.

Experience analyzing requirements, deriving work estimates, and coordinating User Acceptance Testing (UAT).

Experience with SQL Server Integration (SSIS) and Reporting (SSRS) Services

Experience with performance tuning and query optimization.

Experience troubleshooting database integrity, performance, blocking/deadlocking, connectivity, indexes and data replication issues.

Experience collaborating on database design and performance tuning.