Data Integration Analyst

$70,000 - $85,000/Yr

Nelnet - Centennial, CO

Full-time - Mid Level

Remote - Centennial, CO

Credit Intermediation and Related Activities

About the position

The Data Integration Analyst at Nelnet is responsible for designing and managing data ingestion pipelines, ensuring accurate structuring and normalization of data from various sources into a data warehouse. This role requires strong expertise in ETL processes and a solid understanding of reinsurance data, with a focus on developing dashboards and conducting analyses that drive business insights to support financial initiatives.

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.
• Work 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.

Requirements

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field is preferred.
• 3-5 years of experience in ETL processes or related field.
• 1-2 years of experience in Data Analysis and reporting.
• Proficient in extracting, transforming, and loading data from flat files, Excel, and other sources into data warehouses.
• Strong understanding of reinsurance concepts and data structures.
• Ability to design and structure data models for reporting and analysis.
• Experienced in building dynamic dashboards and reports using tools like Power BI, Tableau, or similar platforms.
• Skilled in performing in-depth data analysis to identify trends, patterns, and opportunities for improvement.
• Advanced knowledge of SQL for querying, and Python for automating data workflows.
• Adept at identifying data discrepancies or inefficiencies in processes and implementing solutions.

Nice-to-haves

• Experience with data visualization tools such as Power BI or Tableau.
• Familiarity with financial data analysis and reporting.
• Knowledge of data governance and data quality best practices.

Benefits

• Medical, dental, vision insurance
• Health Savings Account (HSA) and Flexible Spending Account (FSA)
• Generous earned time off
• 401K with 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
• Robust wellness program