Data Analytics & Integration Developer

Blue Cross and Blue Shield of Kansas•Topeka, KS

About The Position

The Data Analytics and Infrastructure System Administrator integrates corporate data assets from varied sources to support reporting and decision-making. The role extracts and prepares data for requests and analytics, optimizes data workflows, develops data solutions for analytics and reporting, and integrates data across systems. It also uses visualization tools to present findings and support business strategy. The position is eligible for remote, hybrid, or onsite work in accordance with the company’s Telecommuting Policy. The role supports reporting and visualization tools and uses approved technologies to improve accessibility. It includes maintaining a knowledge repository of data sources, business rules, and processing methodologies; collaborating with analysts, business stakeholders, and IT teams; and mentoring colleagues to promote continuous improvement and self-service analytics. The employee is also responsible for regular and critical system maintenance within defined service levels. The position is open to multiple job levels. IT&S 16 requires at least five years of experience in IT and/or application development and pays $96,240–$114,300. IT&S 17 requires at least eight years of such experience and pays $110,800–$131,500. The stated compensation range is a good-faith estimate and may vary based on a candidate’s skills, education, experience, and training.

Requirements

High school diploma or equivalent required.
Minimum of five years’ experience in IT and/or application development required; the IT&S 17 level requires a minimum of eight years.
Technical training with certification in assigned technology is required as applicable.
Experience utilizing ETL tools and frameworks, including Informatica, SSIS, and data pipelines, for data extraction, transformation, and loading.
Strong proficiency in SQL and experience accessing and querying corporate and disparate data sources for analysis and reporting.
Familiarity with data lakes, relational databases, and data models.
Hands-on experience with reporting and visualization tools, including Power BI, Tableau, and related platforms.
Excellent problem-solving skills and a proactive approach to data management challenges, including data quality and data profiling.
Project management skills and demonstrated ability to complete small- to medium-sized projects successfully.
Knowledge of data governance, data security, and compliance best practices.
Demonstrated experience managing assigned technologies through regular maintenance, including updates, monitoring, and troubleshooting, within defined service levels.

Nice To Haves

Bachelor’s degree or completion of a Computer Science Program from a Technical Trade School is preferred.
Experience working with operational data in the health care industry and understanding regulatory requirements related to health care data.
Knowledge of data gateways and pipelines for integrating and securely transferring data between on-premises and cloud-based sources.
Experience with Python, SSRS, Visual Studio (.NET/C#), Power BI, Tableau, SQL, SSIS, AWS, Azure, GitLab, and data integration frameworks.

Responsibilities

Extract, analyze, and transform data to support business intelligence and reporting needs.
Fulfill data requests by developing and implementing data integration solutions, combining disparate sources for 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, using approved technologies to develop and optimize solutions that improve accessibility.
Develop and optimize data solutions using SQL and scripting languages for data manipulation.
Use modern data integration technologies, including cloud platforms such as AWS and Azure and big data solutions such as Spark, to streamline data processing and enhance analytics capabilities.
Provide mentorship, training, and assistance to colleagues to foster continuous improvement and self-service analytics.
Maintain system performance by performing regular and critical maintenance tasks within defined service levels.