Data Analytics & Integration Developer

Blue Cross & Blue Shield of Kansas, Inc.; Topeka (KS); Hybrid; USD 96,000 - 131,000; Full time

Benefits offered by this job

Health insurance

Vision/Dental insurance

6 weeks parental leave

Fertility/Adoption assistance

2 weeks caregiver leave

401(k) matching

Tuition reimbursement

Job summary

Blue Cross and Blue Shield of Kansas is seeking an experienced Data Analytics and Infrastructure System Administrator to integrate diverse data assets and support insightful reporting. The role involves extracting data from a data warehouse for requests, optimizing workflows, and delivering data solutions with visualizations that drive business strategy.

Responsibilities include collaboration with analysts, stakeholders, and IT to ensure data solutions meet organizational needs; support for

Qualifications

• Experience with ETL tools and data pipelines for extraction, transformation, and loading.
• Strong SQL skills across multiple data sources for analysis and reporting.
• Familiarity with data governance and security best practices.
• Experience with BI/reporting tools (Power BI/Tableau/SSRS) and data visualization.
• Ability to manage small to mid-size projects and document processes.
• Knowledge of regulatory health care data requirements and governance.

Responsibilities

• Extract, analyze, and transform data to support BI and reporting needs.
• Develop data integration solutions by combining disparate data sources for analytics.
• Maintain knowledge repository of data sources, rules, and processing methods.
• Collaborate with stakeholders and IT teams to align data solutions with needs.
• Support reporting tools (Power BI, Tableau, SSRS) and optimize data accessibility.
• Develop data solutions using SQL and scripting for data manipulation.
• Leverage cloud platforms (AWS, Azure) and big data tools to enhance analytics.
• Mentor colleagues to promote self-service analytics and continual improvement.

Skills

ETL tools

SQL

Data governance

Data security

Tableau

Power BI

SSRS

Project management

Education

Bachelor's degree in CS

Technical certification

Tools

Informatica

SSIS

Power BI

Tableau

Python

Azure

AWS

GitLab

Job description

Are you ready to make a difference? Choose to work for one of the most trusted companies in Kansas. Why Join Us? Make a Positive Impact: Your work will directly contribute to the health and well-being of Kansans. Family Comes First: Total rewards package that promotes the idea of family first for all employees. Paid vacation and sick leave with paid maternity and paternity available immediately upon hire Professional Growth Opportunities: Advance your career with ongoing training and development programs. Dynamic Work Environment: Collaborate with a team of passionate and driven individuals in a work environment that promotes flexibility. Trust and Stability: Work for one of the most trusted companies in Kansas with over 80 years of commitment, compassion and community. Inclusive Work Environment: We pride ourselves on fostering a workplace where everyone is valued and respected.

Benefits & Perks

• Base compensation is only one component of your competitive Total Rewards package
• Incentive pay program (EPIP)
• Health/Vision/Dental insurance
• 6 weeks paid parental leave for new mothers and fathers
• Fertility/Adoption assistance
• 2 weeks paid caregiver leave
• 401(k) plan matching up to 5%
• Tuition reimbursement
• Health & fitness benefits, discounts and resources

Job Summary

The Data Analytics and Infrastructure System Administrator is responsible for integrating corporate data assets from various sources to support insightful reporting and decision-making. This position involves working with data, extracting insights, and transforming information into compelling reports and visualizations that drive business strategy. Responsibilities include extracting and preparing data from the data warehouse for one-time requests and analytic purposes, optimizing data workflows, developing and delivering data solutions for analytics and reporting, and ensuring seamless integration of data across systems while leveraging visualization tools to present findings effectively. “This position is eligible to work remote, hybrid or onsite in accordance with our Telecommuting Policy.”

What you’ll do

• Extract, analyze, and transform data to support business intelligence and reporting needs.
• Fulfill data requests by developing and implementing data integration solutions, integrating disparate data sources to support reporting, analytics, business needs, and vendor data delivery.
• Maintain a knowledge repository documenting data sources, business rules, and processing methodologies.
• Collaborate with data analysts, business stakeholders, and IT teams to align data solutions with organizational needs.
• Support reporting and visualization tools, including Power BI, Tableau, SSRS, internal solutions, and third-party products; while utilizing approved technologies to develop and optimize solutions that improve accessibility.
• Develop and optimize data solutions using SQL and scripting languages for data manipulation.
• Utilize modern data integration technologies, including cloud platforms (AWS, Azure) and big data solutions (e.g., Spark), to streamline data processing and enhance analytics capabilities.
• Provide mentorship, training, and assistance to colleagues to foster a culture of continuous improvement and self-service analytics.
• Maintain system performance by performing regular and critical maintenance tasks within defined service levels.

What you need

• Experience utilizing ETL tools and frameworks, including Informatica, SSIS, and data pipelines, for efficient data extraction, transformation, and loading processes.
• Strong proficiency in SQL with experience accessing and querying various corporate and disparate data sources for analysis and reporting.
• Familiarity with modern data architectures, including data lakes, relational databases, and data models.
• Hands-on experience with reporting and visualization tools, including Power BI, Tableau, and other related platforms.
• Excellent problem-solving skills with a proactive approach to addressing data management challenges, including data quality, data profiling, and other related issues.
• Project management skills with a demonstrated ability to complete small to medium-sized projects successfully.
• Knowledge of data governance, data security, and compliance best practices.
• Experience working with operational data in the Health Care Industry and a solid understanding of regulatory requirements related to health care data.
• (Preferred) Knowledge of data gateways and pipelines for integrating and securely transferring data, ensuring seamless connectivity between on-premises and cloud-based data sources.

Education and Experience

High school diploma or equivalent required. Bachelor’s degree or completion of a Computer Science Program from a Technical Trade School is preferred. Technical training with certification in assigned technology is required as applicable. Minimum of five years’ experience in I.T. and/or application development is required. Demonstrated experience in managing assigned technologies by performing regular maintenance tasks, including updates, monitoring, and troubleshooting, within defined service levels. Preferred experience with technologies such as Python, SSRS, Visual Studio (.NET/C#), Power BI, Tableau, SQL, SSIS, cloud platforms (AWS, Azure), GitLab, and data integration frameworks.

Physical Requirements

Prolonged periods of sitting at a desk and working on a computer. Manual dexterity to operate a keyboard, mouse, and other IT-related tools. Ability to work in a standard office environment, including attending meetings in person or virtually.

Compensation

This position is open to multiple job levels. IT&S 16: Requires a minimum of five years’ experience in I.T. and/or application development $96,240 - $114,300 IT&S 17: Requires a minimum of eight years’ experience in I.T. and/or application development $110,800 - $131,500 Blue Cross and Blue Shield of Kansas offers excellent competitive compensation with the goal of retaining and growing talented team members. The compensation range for this role is a good faith estimate, it is estimated based on what a successful candidate might be paid. All offers presented to candidates are carefully reviewed to ensure fair, equitable pay by offering competitive wages that align with the individual's skills, education, experience, and training. The range may vary above or below the stated amounts.

Our Commitment to Connection and Belonging

At Blue Cross and Blue Shield of Kansas, we are committed to fostering a culture of connection and belonging, where mutual respect is at the foundation of our workplace. We provide equal employment opportunities to all individuals, regardless of race, color, religion, belief, sex, pregnancy (including childbirth, lactation, and related medical conditions), national origin, age, physical or mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military or veteran status, family or parental status, or any other characteristic protected by applicable law. Blue Cross and Blue Shield of Kansas conducts pre-employment drug screening, criminal conviction check, employment verifications and education as part of a conditional offer of employment. For more than 70 years, Blue Cross and Blue Shield of Kansas has built a reputation of trust. As we move forward in this new era of health care we want to continue that tradition. Whether a member needs Blue Cross to cover an annual check-up or give them peace of mind during a major medical crisis, we want our members to know they can trust BCBSKS to meet their needs. Our mission: Being the insurer Kansans trust with their health.

Our Commitment to Connection and Belonging

At Blue Cross and Blue Shield of Kansas, we are committed to fostering a culture of connection and belonging, where mutual respect is at the foundation of our workplace. We provide equal employment opportunities to all individuals, regardless of race, color, religion, belief, sex, pregnancy (including childbirth, lactation, and related medical conditions), national origin, age, physical or mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military or veteran status, family or parental status, or any other characteristic protected by applicable law. Blue Cross and Blue Shield of Kansas conducts pre-employment drug screening, criminal conviction check, employment verifications and education as part of a conditional offer of employment.