Data Analytics & Integration Developer

This job was posted by https://www.kansasworks.com : For more information, please see: https://www.kansasworks.com/jobs/13698459 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. {=html} - 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 {=html} - Professional Growth Opportunities: Advance your career with ongoing training and development programs. {=html} - Dynamic Work Environment: Collaborate with a team of passionate and driven individuals in a work environment that promotes flexibility. {=html} - Trust and Stability: Work for one of the most trusted companies in Kansas with over 80 years of commitment, compassion and community. {=html} - 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 {=html} - Incentive pay program (EPIP) {=html} - Health/Vision/Dental insurance {=html} - 6 weeks paid parental leave for new mothers and fathers {=html} - Fertility/Adoption assistance {=html} - 2 weeks paid caregiver leave {=html} - 401(k) plan matching up to 5% {=html} - Tuition reimbursement {=html} - 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. {=html} - Fulfill data requests by developing and implementing data integration solutions, integrating disparate data sources to support reporting, analytics, business needs, and vendor data delivery. {=html} - Maintain a knowledge repository documenting data sources, business rules, and processing methodologies. {=html} - Collaborate with data analysts, business stakeholders, and IT teams to align data solutions with organizational needs. {=html} - 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. {=html} - Develop and optimize data solutions using SQL and scripting languages for data manipulation. {=html} - Utilize modern data integration technologies, including cloud platforms (AWS, Azure) and big dat solutions (e.g., Spark), to streamline data processing and enhance analytics capabilities. {=html} - Provide mentorship, training, and assistance to colleagues to foster a culture of continuous improvement and self-service analytics. {=html} - Maintain system performance by performing regular and critical maintenance tasks within defined service levels. What you need Knowledge/Skills/Abilities - Experience utilizing ETL tools and frameworks, including Informatica, SSIS, and data pipelines, for efficient data extraction, transformation, and loading processes. {=html} - Strong proficiency in SQL with experience accessing and querying various corporate and disparate data sources for analysis and reporting. {=html} - Familiarity with modern data architectures, including data lakes, relational databases, and data models. {=html} - Hands-on experience with reporting and visualization tools, including Power BI, Tableau, and other related platforms. {=html} - Excellent problem-solving skills with a proactive approach to addressing data management challenges, including data quality, data profiling, and other related issues. {=html} - Project management skills with a demonstrated ability to complete small to medium-sized projects successfully. {=html} - Knowledge of data governance, data security, and compliance best practices.