Idaho State Job Bank is hiring: Data Integration Analyst in Boise
Idaho State Job Bank, Boise, ID, United States
Data Integration Analyst at Nelnet in Boise, Idaho, United States Job Description Nelnet is a diversified and innovative company committed to enriching lives through the power of service as a student loan servicer, professional services company, consumer loan originator and servicer, payments processor, renewable energy solutions, and K-12 and higher education expert. For over 40 years, Nelnet has been serving its customers, associates, and communities. The perks of working at Nelnet go beyond our benefits package. When you join the Nelnet team, you're part of a community invested in the success of each individual. That support comes through in our work, as we are united by our mission of creating opportunities for people where they live, learn, and work. We are seeking a Data Specialist with strong expertise in data extraction, transformation, and loading (ETL) processes, along with a solid understanding of reinsurance data. In this role, you will be responsible for designing and managing the ingestion pipelines for data from flat files and other sources into a data warehouse, ensuring accurate structuring and normalization. The ideal candidate will develop robust dashboards and conduct detailed analyses that drive business insights, supporting Nelnet's expanding financial initiatives. Your contributions will ensure data is well-organized, reliable, and accessible for key decision-making in reinsurance and broader financial strategies. At this time, we are unable to move forward with candidates that reside in these states: Alabama, California, Connecticut, Hawaii, Illinois, Maine, Massachusetts, Michigan, New Jersey, New York, Oregon, Rhode Island, Vermont, Washington. Nelnet believes in a hybrid work environment that accommodates both in-office and remote work. This model promotes a positive work-life balance and culture, enabling in-person collaboration when possible while also providing benefits associated with remote work. Nelnet has fully remote, fully in-office, and hybrid roles. Our hybrid roles have flexibility, based on the team. The standard hybrid work schedule includes a 3/2 (in-office/work-from-home) split for associates that reside within 30 miles of an office. This position may be filled remotely, if the selected candidate resides more than 30 miles from a Nelnet office. This position may be filled as a hybrid role, if the selected candidate is within a 30-mile radius of a Nelnet office. JOB RESPONSIBILITIES: + Develop and maintain ETL processes using Python and Snowflake to ingest data from various sources. + Become an expert in the reinsurance data structures and needs. + Working with the business leadership team to define requirements. + Build, structure, and maintain data warehouse to support reporting and analytics needs. + Design and build analysis and dashboards supporting strategic insights for key stakeholders. + Optimize data pipelines for performance, ensuring the scalability of solutions. + Collaborate with finance and accounting teams to identify data needs and address data-related issues. + Provide support for SQL Server, and SSIS processes as needed. EDUCATION: Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field is preferred. EXPERIENCE: + 3-5 years of experience in ETL processes or related field. + 1-2 years of experience in Data Analysis and reporting. COMPETENCIES - SKILLS/KNOWLEDGE/ABILITIES: + ETL Expertise : Proficient in extracting, transforming, and loading data from flat files, Excel, and other sources into data warehouses, ensuring accuracy and consistency in data handling. + Reinsurance Knowledge : Strong understanding of reinsurance concepts and data structures, enabling efficient data processing and insightful analysis specific to reinsurance industry needs. + Data Modeling : Ability to design and structure data models for reporting and analysis, ensuring optimized performance and scalability of data pipelines. + Dashboard & Reporting Tools : Experienced in building dynamic dashboards and reports using tools like Power BI, Tableau, or similar platforms, translating complex datasets into actionable insights. + Data Analysis : Skilled in performing in-depth data analysis to identify trends, patterns, and opportunities for improvement, contributing to strategic decision-making. + SQL & Python Proficiency : Advanced knowledge of SQL for querying, and Python for automating data workflows, enhancing efficiency in data management and reporting. + Problem Solving : Adept at identifying data discrepancies or inefficiencies in processes and implementing solutions to ensure data integrity and seamless operations. + Collaboration : Strong interpersonal skills, with the ability to work cross-functionally with business and technical teams to understand data needs and deliver results. Starting salary range for this position is: $70,000 - $85,000 Our benefits package includes medical, dental, vision, HSA and FSA, generous earned time off, 401K/student loan repayment, life insurance & AD&D insurance, employee assistance program, employee stock purchase program, tuition reimbursement, performance-based incentive pay, short- and long-term disability, and a robust wellness program. Click here to learn more about our benefits: LINK (. Nelnet is an Equal Opportunity Employer, complies with Executive Order 11246, and takes affirmative action to ensure that qualified applicants are employed, and that employees are treated during employment, without regard to race, color, religion/creed, national origin, gender, or sex, marital status, age, disability, use of a guide dog or service animal, sexual orientation, military/veteran status, or any other status protected by Federal or State law or local ordinance. Qualified individuals with disabilities who require reasonable accommodations in order to apply or compete for positions at Nelnet may request such accommodations by contacting Corporate Recruiting at 402-486-5725 or . Nelnet is a Drug Free and Tobacco Free Workplace. You may know Nelnet as the nation's largest student loan servicer - but we do more than that. A lot more. We're also a professional services company, consumer loan originator and servicer, payment processor, renewable energy innovator, and K-12 and higher education expert (and that's just a shortlist). For over 40 years, we've been serving our customers, associates, and communities to make dreams possible. EEO Info ( EEO Letter ( EPPA Info ( FMLA Info (To view full details and how to apply, please login or create a Job Seeker account