Data Analytics & Integration Developer

Blue Cross and Blue Shield of Kansas•Topeka, MO

1d•$96,240 - $131,500

About The Position

The Data Analytics and Infrastructure System Administrator integrates corporate data assets from various sources to support reporting and decision-making. The role extracts and prepares data from the data warehouse for requests and analytics, optimizes data workflows, develops and delivers data solutions for analytics and reporting, and ensures data is integrated across systems. It also uses visualization tools to present findings effectively. The position supports business intelligence and reporting by transforming data, fulfilling data requests, maintaining documentation about data sources and business rules, and collaborating with analysts, business stakeholders, and IT teams. It supports reporting and visualization platforms and develops solutions using SQL, scripting languages, cloud platforms, and big data technologies. The role also maintains system performance through regular maintenance within defined service levels and helps colleagues develop skills in self-service analytics. The position may be performed remotely, in a hybrid arrangement, or onsite in accordance with the company’s Telecommuting Policy. It is open to multiple job levels: IT&S 16 requires at least five years of IT and/or application development experience; IT&S 17 requires at least eight years. Compensation ranges are $96,240–$114,300 for IT&S 16 and $110,800–$131,500 for IT&S 17.

Requirements

High school diploma or equivalent.
Technical training with certification in assigned technology, as applicable.
At least five years of experience in IT and/or application development; the IT&S 17 level requires at least eight years.
Experience with ETL tools and frameworks, including Informatica, SSIS, and data pipelines.
Strong SQL proficiency and experience accessing and querying 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 such as Power BI and Tableau.
Problem-solving skills and a proactive approach to data management challenges, including data quality and data profiling.
Project management skills and ability to complete small- to medium-sized projects.
Knowledge of data governance, data security, and compliance best practices.
Knowledge of data gateways and pipelines for integrating and securely transferring data between on-premises and cloud-based sources.
Demonstrated experience maintaining assigned technologies, 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.
Experience working with operational data in the health care industry and understanding regulatory requirements related to health care data.
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, integrating disparate data 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 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 encourage continuous improvement and self-service analytics.
Perform regular and critical maintenance tasks to maintain system performance within defined service levels.
Manage assigned technologies by performing regular maintenance tasks, including updates, monitoring, and troubleshooting, within defined service levels.