IT Data Analyst, Senior

IT Data Analyst, Senior

Blue Shield of California

Oakland, CA 94616

Posted 7 months ago

  • Job Type(s)

    Full Time
  • Industry

    Technology
  • Job Description

    IT Data Analyst, Senior

    Your Role

    The Data Analyst teamis 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 Senior Data Analyst 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 and 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 Senior Data Analyst 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)
    • Use documented procedures to create source-to-target mapping, capturing business and technical metadata, and complete data lineage
    • Perform data profiling, present findings to various audience, and propose options
    • Perform ad hoc, live research to demonstrate/present data issues, patterns, relationships, findings and/or recommendations
    • 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

    Your Knowledge and Experience

    • Requires a bachelor's degree preferably in computer science, statistics, or mathematics or equivalent experience
    • Requires at least 5 years experience in data analysis
    • Requires at least 5 years hands-on experience in SQL, including querying large and complex data sets
    • 5+ years of experience in one or more relational or columnar databases or appliances like Snowflake, DB2, Oracle, MS SQL Server, Netezza, Redshift etc.
    • 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
    • Demonstrated experience working with vendor partners, cross-functional and development teams in terms of end-to-end technical delivery, including data stewards, architects, data governance, data modeler, data quality, development, solution leads, and QA team to address data and mapping questions
    • Ability to perform ad hoc, live research to demonstrate/present data issues, patterns, relationships, findings and/or recommendations, risks, and assumptions
    • 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 cloud-based project experience or prior Healthcare experience is a plus

    Pay Range:

    The pay range for this role is: $ 99000.00 to $ 148500.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.