JOB DESCRIPTION
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, Senior 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 teams consisting of business system analysts, business partners, third party vendors, solution leads, data modelers, analysts, and development teams. The 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 the 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 adhoc, 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
• Manipulate and analyze high-volume, high-dimensionality data from various sources using a variety of tools and data analysis techniques, requiring strong proficiency in SQL
• 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

QUALIFICATIONS
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
• Experience in one or more relational or columnar databases or appliances such as 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
• 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.


#LI-CM1

ABOUT THE TEAM
Blue Shield of California’s mission is to ensure all Californians have access to high-quality health care at a sustainably affordable price. We are transforming health care in a way that genuinely serves our nonprofit mission by lowering costs, improving quality, and enhancing the member and physician experience.
To fulfill our mission, we must ensure a diverse, equitable, and inclusive environment where all employees can be their authentic selves and fully contribute to meet the needs of the multifaceted communities we serve. Our continued commitment to diversity, equity, and inclusion upholds our values and advances our goal of creating a healthcare system that is worthy of our family and friends while addressing health disparities, promoting social justice, and integrating health equity through our products, business practices, and presence as a corporate citizen.
Blue Shield has received awards and recognition for being a certified Fortune 100 Best Companies to Work, Military Friendly Employer, People Companies that Care, a Leading Disability Employer, and one of California’s top companies in volunteering and giving. Here at Blue Shield, we strive to make a positive change across our industry and communities – join us!
Our Values:

• Honest . We hold ourselves to the highest ethical and integrity standards. We build trust by doing what we say we're going to do and by acknowledging and correcting where we fall short.
• Human . We strive to be our authentic selves, listening and communicating effectively, and showing empathy towards others by walking in their shoes.
• Courageous . We stand up for what we believe in and are committed to the hard work necessary to achieve our ambitious goals.

Our Workplace Model:
Blue Shield of California is dedicated to making work-life balance a reality. Whether you prefer to work in an office or from home, we understand flexibility is more important than ever. That’s why Blue Shield is a hybrid company, offering you the opportunity to decide where you can do your best and most meaningful work.
Two ways of working: Hybrid (our default) and office

• Hybrid – In a business unit approved office a few times per year to 3 days per week, on average

• Office – In a business unit approved office 4+ days a week, on average. If the role you’re applying for is deemed an “Essential Role,” the company has determined that the role can only be performed in a Blue Shield office or in the field and would require your to meet the office worker classification.

Physical Requirements:
Office Environment - roles involving part to full time schedule in Office Environment. Due to the current public health emergency in California, Blue Shield employees are almost all working remotely. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of work day.


Equal Employment Opportunity:
External hires must pass a background check/drug screen. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws.