IT Data Analyst, Consultant

2 weeks ago

Oakland, United States Blue Shield Of California Full time

Your Role

The Data Analyst team is responsible for performing detailed data analysis, source to target designs, data profiling, and metadata management in support of new development, implementation or enhancement of existing data assets. The Data Analyst, Consultant will report to the Manager of Data Solutions and Asset Management. In this role you will participate in design, development, and implementation of large enterprise data warehouse/BI solutions. In addition, you will support operations and assist with production, incident resolution. This position requires strong collaboration with cross functional team consisting of business system analysts, business partners, third party vendors, solution leads, data modelers, analysts, and development teams. The analysts will be responsible for understanding business requirements, researching/analyzing requirements and understanding datasets that support business functions, conduct data profiling, provide appropriate source to target transformations rules/logic for the implementation. Data Analysts are expected to integral part of full development lifecycle process from concept, design, development through testing, and implementation.

Your Work

In this role, you will:

  • Be responsible for performing data analysis which includes inspecting, profiling, transforming with the goal of discovering useful information, suggesting conclusions, and supporting decision-making
  • Own and manage portfolios and multiple assets within healthcare portfolio and partner with analytics and business counterparts in providing solutions
  • Perform data analysis, gap and impact analysis for medium to large sized assignment (with mid/large number of data elements, one-to-multiple sources, business impact, and visibility)
  • Drive data analysis and profiling for complex data issues with options and recommendations
  • Develop extensible and flexible data analysis process based on long term strategy and promote reuse of existing structures when possible
  • Work on multiple projects as a project leader or sometimes as a project advisor on projects of varying complexity
  • Use documented procedures to create source-to-target mapping, capturing business and technical metadata, and complete data lineage.
  • Partner with Business Subject Matter Experts, Business System Analysts, Solution Technical Leads, Data/Application architects and development teams to analyze data requirements to ensure data design is aligned with business strategy, project and scope
  • Manipulate and analyze high-volume, high-dimensionality data from various sources using a variety of tools and data analysis techniques
  • Perform ad hoc, live research to demonstrate/present data issues, patterns, relationships, findings and/or recommendations, risks, and assumptions
  • Work with cross functional teams: data stewards, architects, data governance, data modeler, data quality, development, solution leads, and QA team to address data and mapping questions
  • Work collaboratively with data quality analysts, data stewards, and data governance team to resolve data quality issues
  • Influence stakeholders to make product improvements that yield business value by effectively making compelling cases through storytelling, visualizations, and other influencing tools
  • Mentor and provide guidance to peers and junior staff

Your Knowledge and Experience

  • Requires a bachelor's degree preferably in computer science, statistics, or mathematics or equivalent experience
  • Requires at least 8 years experience in data analysis
  • 8+ years of hands-on experience in SQL, including querying large and complex data sets
  • 8+ years of experience in one or more relational or columnar databases or appliances like Snowflake, DB2, Oracle, MS SQL Server, Netezza, Redshift etc.
  • 8+ years acting as team lead or leading individual effort is preferred
  • Experience in cloud architecture, Azure framework, data vault methodology and data catalog tool like or similar to Collibra
  • Strong experience in data management, data integration, data warehouse, data virtualization and data quality design patterns and techniques
  • Preferred working experience in Domain models, Canonical models and API interfaces
  • Proven track record of full life cycle successes from inception to successful completion and production support
  • Ability to effectively communicate status, design, and approach to management/business sponsors/product managers
  • Familiar with standard software development tools, including incident tracking, version control, documentation and testing systems
  • Self-directed, ability to work with limited management direction and exercises considerable latitude in determining technical objectives of the assignment
  • Experience with iterative development life cycle methodologies and application of those principles, especially agile development practices
  • Demonstrated experience working with vendor partners, cross-functional and development teams in terms of end-to-end technical delivery
  • Strong analytic, process flow, problem-solving, communication, customer service, organization skills, required
  • Excellent verbal and written communications skills
  • Capable of delivering on multiple competing priorities with little supervision
  • Prior Healthcare experience is a plus

Pay Range:

The pay range for this role is: $ 118800.00 to $ 178200.00 for California.

Note:

Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.

#LI-CM1

  • Energy Resources Data Analyst

    3 months ago

    Oakland, United States Pivotal Talent Search Full time

    Job DescriptionJob DescriptionWe are seeking an Energy Resources Data Analyst who has experience in the energy industry with an electric utility, Community Choice Aggregator (CCA), power marketer, energy portfolio manager, or regulatory entity who ideally has knowledge of CAISO. This individual will utilize their experience in data analytics, database...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Senior Data Analyst

    3 months ago

    Oakland, United States Worker's Compensation Insurance Rating Bureau Full time

    Job DescriptionJob DescriptionThe Workers' Compensation Insurance Rating Bureau of California (WCIRB) is California's trusted, objective provider of actuarially-based information and research, advisory pure premium rates, and educational services integral to a healthy workers' compensation system. The WCIRB is a California unincorporated,...

  • Senior Data Analyst

    2 months ago

    Oakland, United States Workers' Compensation Insurance Rating Bureau of California Full time

    The Workers' Compensation Insurance Rating Bureau of California (WCIRB) is California's trusted, objective provider of actuarially-based information and research, advisory pure premium rates, and educational services integral to a healthy workers' compensation system. The WCIRB is a California unincorporated, private, nonprofit association comprised of all...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Data Engineer, Consultant

    3 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Data Analyst for Energy Resources

    1 week ago

    Oakland, California, United States Pivotal Talent Search Full time

    Job OverviewPivotal Talent Search is looking for a Data Analyst for Energy Resources with a solid background in the energy sector, particularly within electric utilities, Community Choice Aggregators (CCAs), power marketing, or regulatory bodies. The ideal candidate will have expertise in data analytics, database management, and dashboard creation to enhance...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, CA, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development,...

  • Expert Operations Data Analyst

    4 weeks ago

    Oakland, United States Pacific Gas and Electric Company Full time

    Position SummaryThe Operations Data Analyst extracts operations data for analysis, leadership support and responses to ad hoc data requests. The incumbent maintains operations tools & databases ensuring that it is kept up-to-date using data from various PG&E systems. They develop, maintain, and enhances operational metric database tools for the broader...

  • Strategic Data Analyst

    2 weeks ago

    Oakland, California, United States Axelon Services Corporation Full time

    Axelon Services Corporation is seeking a highly motivated and analytical Decision Support Analyst to join our growing team. In this role, you will play a vital part in providing critical insights and data-driven recommendations to key stakeholders and hospital leadership. As a Decision Support Analyst, you will be responsible for analyzing operational...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, CA, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development,...

  • Data Engineer, Consultant

    2 weeks ago

    Oakland, CA, United States Blue Shield of California Full time

    Your Role The Data Engineering development team Is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Consultant will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Financial Data Analyst

    18 hours ago

    Oakland, California, United States Dolls Kill Full time

    About the RoleWe are seeking a highly skilled Financial Data Analyst to join our team at Dolls Kill. As a key member of our organization, you will play a critical role in driving business growth and decision-making through data-driven insights.Key ResponsibilitiesDevelop and maintain a deep understanding of our business operations, including financial...

  • Operations Data Analyst, Principal

    2 weeks ago

    OAKLAND, United States PG&E Corporation Full time

    Requisition ID # 158309 Job Category: Business Operations / Strategy Job Level: Manager/PrincipalBusiness Unit: Electric OperationsWork Type: HybridJob Location: Oakland  Position SummaryExtracts operations data for analysis, leadership support and responses to ad hoc data requests. Maintains operations tools & databases to ensure that it is kept...

  • Data Processing Analyst

    2 weeks ago

    Oakland, United States The Norland Group Full time $65 - $85

    Job DescriptionJob DescriptionDescription: **OPEN TO LOCAL & NON-LOCAL*** HYBRID may need to come to OGO as needed. TOP THINGS: Demonstrable evidence of experience and capability to develop a process framework and deliver modular hierarchical processes from level zero (organizational context) to level three (procedure level).· Experience identifying,...

  • Sr. Data Strategy Consultant

    7 days ago

    Oakland, United States VeeAR Projects Inc. Full time

    Title: Sr. Data Strategy ConsultantLocation: Oakland, CA - RemoteDuration: 12+ months contract with possible extensionJob Description Data Strategy – This workstream involves partnering with Data and insight experts in defining building, and coordinating requirements across portfolios. It would include but is not limited to Program communication, Training...

  • IT Planning Analyst

    2 days ago

    Oakland, United States Servsys Corporation Full time

    Title: IT Planning Analyst Location: Oakland, CA Duration: 6 months Job Responsibilities/Qualifications Exceptional ability to engage with executives and diverse internal stakeholders, technical team and adapting messages to suit varying levels of analytical proficiency. Proven experience in data management, data assessment and data governance, ensuring...

  • Business Intelligence/Data Analyst, Customer Success

    4 weeks ago

    Oakland, United States Block Full time

    Company DescriptionSince we opened our doors in 2009, the world of commerce has evolved immensely, and so has Square. After enabling anyone to take payments and never miss a sale, we saw sellers stymied by disparate, outmoded products and tools that wouldn't work together.So we expanded into software and started building integrated, omnichannel...