Business Data Analyst

Ascendum Solutions; Irvine (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

A technology solutions company in California is seeking a Data Analyst who will be responsible for data analysis, collaborating with stakeholders, and ensuring data quality. The ideal candidate should have a Bachelor's degree and a minimum of five years' experience in data analysis roles, with strong skills in SQL and data visualization tools like Tableau or Power BI. This position emphasizes consultative skills and technical expertise to support operational decision-making.

Qualifications

• Minimum of five (5) years of experience in business systems analysis or data analysis roles.
• Demonstrates understanding of business analysis principles and techniques.
• Strong consultative and advisory skills.

Responsibilities

• Collaborate with stakeholders to gather and analyze business requirements.
• Perform complex data analysis and create insightful visualizations.
• Ensure data quality, consistency, and compliance with governance policies.

Skills

Business analysis principles

Data analysis

SQL

Data visualization tools

Cloud platforms

Effective communication

Education

Bachelor's degree in Computer Science or related field

Tools

Tableau

Power BI

Python

R

Job description

Get AI-powered advice on this job and more exclusive features.

This position can ONLY consider W2 candidates. C2C/1099 candidates are NOT eligible to be hired for this opportunity.

Job Description

The Data Analyst is responsible for acting as an advanced professional in the systems and process design and implementation space, focusing on low, medium, and high effort software implementation projects. The Analyst will solicit, understand, and document the customer’s business requirements, processes, and workflows developing both written and visual depictions of requirements and process flows. The Data Analyst works with developers to create the functional specifications that meet those requirements, serves as subject matter expert (SME) to the Developers building those functions, and works with the QA team to test the developed functionality. The DA will recommend and institute business analysis best practices, tools, and methodology towards standardization of deliverables and procedures, and collaborates with Developers and QA Leads to uphold and improve SDLC processes.

Responsibilities

• Collaborate with stakeholders to gather and analyze business requirements, translating them into technical specifications for data engineering projects.
• Performs complex data analysis and creates insightful visualizations to uncover actionable insights that support operational and strategic decision-making.
• Models, cleans, and categorizes data sets for effective use in analytics applications.
• Identifies data-related issues, assess their severity, and evaluate their business impact to inform data quality improvement initiatives.
• Implements corrective measures for inaccurate data values and other issues, while addressing their underlying causes.
• Develops data quality guidelines and best practices for end users to reduce the likelihood of future issues.
• Develops and maintains documentation for data flows, data dictionaries, and business processes.
• Ensures data quality, consistency, and compliance with data governance policies.
• Assists in the evaluation and implementation of new data technologies and tools.
• Performs other duties and projects assigned.

Requirements

• Demonstrates knowledge of, adherence to, monitoring and responsibility for compliance with state and federal regulations and laws as they pertain to this position.
• Demonstrate team leadership and staff development skills.
• Demonstrates understanding of business analysis principles, processes, and techniques.
• Ability to create use cases, functional, and technical requirements.
• Familiarity with data Lakehouse concepts and technologies (e.g., Delta Lake, Snowflake).
• Knowledge of big data processing frameworks (e.g., Apache Spark, Apache Dataflow).
• Preferred knowledge of machine learning concepts and their applications in business.
• Preferred familiarity with data streaming technologies (e.g., Dataflow Streaming, Amazon Kinesis)
• Strong consultative and advisory skills.
• Strong understanding of data warehousing concepts and dimensional modeling.
• Intermediate skills in computer terminal and personal computer operation; Microsoft Office applications including but not limited to: Word, Excel, PowerPoint and Outlook.
• Excellent communication skills and ability to translate complex technical concepts to non-technical stakeholders
• Effective organizational and time management skills.
• Ability to make decisions that have moderate impact on the immediate work unit and cross functional departments.
• Ability to organize and prioritize work schedules on a short-term and long-term basis.
• Ability to provide consultation and expert advice to management.
• Ability to make informal and formal presentations, inside and outside the organization; speaking before assigned team or other groups as needed.
• Ability to deal with complex difficult problems involving multiple facets and variables in non-standardized situations.
• Ability to work with little to no supervision while performing duties.

Technical Skills Required

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum of five (5) + years of experience in business systems analysis or data analysis roles.
• Proficiency in SQL and experience with at least one programming language (e.g., Python, R, or Scala).
• Experience with cloud platforms (AWS, Azure, or GCP) and their data services.
• Experience with data visualization tools (e.g., Tableau, Power BI, or Looker).
• Proven experience in data quality management and improvement initiatives.
• Preferred certifications in cloud platforms (e.g., AWS Certified Data Analytics, Azure Data Engineer Associate).
• Preferred experience with data governance and data quality tools.
• Preferred experience with version control systems (e.g., Git) and CI/CD pipelines.
• The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification.
• They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of employees assigned to this job.