Data Integration Analyst
Lincoln - Lincoln Square
Full Time Mid-level / Intermediate USD 70K - 85K
Nelnet
Learn more about Nelnet businesses. Explore jobs and internships in a variety of fields and locations to serve areas across the globe.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 corporaterecruiting@nelnet.net.
Nelnet is a Drug Free and Tobacco Free Workplace.
Tags: Computer Science Data analysis Data management Data pipelines Data warehouse Engineering ETL Excel Finance .NET Pipelines Power BI Python Snowflake SQL SSIS Tableau
Perks/benefits: Career development Equity / stock options Health care Insurance Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.