Data Analyst

GetInsured; Dallas (TX); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Life insurance

Disability insurance

Vision insurance

HSA/FSA

401k

Paid time off

Holidays 13 days

Education assistance

Gym discounts

Commuting/travel assistance

Job summary

GetInsured is seeking a Data Analyst to join our team in Dallas. You will own and optimize day-to-day data operations, automate ETL tasks, and work with clients to ensure accurate data transfer and integration across platforms.

You will use SSIS, SQL, Python, and PowerShell to build data solutions, diagnose issues, and document processes, collaborating with engineering and IT to implement improvements.

Qualifications

• Minimum 3 years of technical and execution experience in data operations or data management with ETL.
• Advanced knowledge of relational database development and maintenance, including SSIS, stored procedures, and functions.
• Experience with Python to process data in CSV and XLSX formats.
• Experience using PowerShell to automate tasks.
• Excellent analysis and data logic skills.
• Ability to collaborate and engage with individuals at all levels of the organization.
• Proven ability to manage priorities and timelines with limited supervision in a fast-paced environment.
• Detail-oriented with strong problem-solving skills and anticipation of future issues.

Responsibilities

• Own, improve, and automate assigned data operations tasks using SSIS, PowerShell, SQL scripts, and stored procedures.
• Integrate data synchronization with third-party vendors and maintain related scripts.
• Coordinate data updates between our platform and client systems, resolving data discrepancies.
• Collaborate with clients on data transfer, file layout, extraction, and delivery requirements.
• Diagnose, research, and resolve technical data issues independently or with the team.
• Perform root cause analysis and present findings with proposed solutions.
• Develop scripts to process data for business analysis, benchmarking, and optimization.
• Work with engineering and IT to identify and validate ongoing improvements.

Skills

ETL

SQL

SSIS

Stored procedures

Functions

Python

PowerShell

Data analysis

Data logic

Collaboration

Prioritization

Problem-solving

Tools

SSIS

PowerShell

SQL

Python

CSV/XLSX

Jira

Job description

About GetInsured What started as the “Expedia” of health insurance, has grown to a market-leading company that is transforming government IT infrastructures with our proven SaaS and AI technology. Our innovative approach to health insurance shopping and enrollment has expanded beyond exchanges, and we’re now reinventing the way states administer safety net programs such as Medicaid, SNAP (food stamps), childcare, and unemployment insurance. With our cutting-edge technology, we’re helping agencies help more people, faster, and transform health care service delivery as we know it.

We are looking for a Data Analyst to join our GetInsured team.

Responsibilities

• Own, improve, and automate assigned day-to-day data operations tasks, using SSIS, PowerShell, SQL scripts, stored procedures, and functions. Day-to-day tasks will include the following or similar
• Integrated data synchronization with third-party vendors, including maintenance of SSIS, SQL, and PowerShell scripts, data remediation, and vendor communications.
• Call center data updates between our platform and client systems using standard data layouts and tools, including identifying and resolving data discrepancies.
• Work with clients on data transfer and integration details, including file layout, extract, and delivery requirements.
• Diagnose, research, and resolve technical issues independently or with other team members.
• Conduct root cause analysis and understand impact for data feed issues, present findings and proposed solutions.
• Develop scripts to process data to support business analysis, benchmarking, and optimization efforts, including independently creating data sets for analysis.
• Work with engineering, IT, and other teams to identify and validate ongoing improvements for fixes.
• Be responsible for updating documentation of data operations processes and procedures.

Qualification

• Basic qualification/Skills -
• Have a minimum of 3 years of technical and execution experience in data operations or data management organization, including ETL.
• Have advanced knowledge of relational database development and maintenance, including SSIS, stored procedures, and functions.
• Have experience with Python to process data in CSV and XLSX formats
• Have experience using PowerShell to automate tasks.
• Have excellent analysis and data logic skills.
• Have the ability to collaborate and effectively engage with individuals at all levels of the organization.
• Have the proven ability to manage priorities and timelines with limited supervision in a fast-paced environment.
• Be detail-oriented, have strong problem-solving skills, and the ability to anticipate potential future issues.

Preferred qualification/Skills –

• Familiarity with basic Web and Network Stacks that include:
• IIS Web Server
• Basic C# and Java
• Cloud-based VMs
• Understanding of how DNS and Firewalls work
• Familiarity with Ticketing Systems (e.g., Jira)
• Nice to have
• Experience with call center operations, data generated within call centers
• Exposure to Genesys, NICE, or other contact center platforms.
• Experience with accounting and billing systems
• Familiarity with the health insurance industry
• Familiarity with Secure Data Practices
• Data Encryption via PGP
• SFTP

Compensation and Benefits-

• Competitive compensation - Please note that salary and compensation may vary based on factors such as skills, experience, performance and location.)
• We offer a comprehensive benefits package, including but not limited to: Health, Dental, Life, Disability, and Vision insurance
• Healthcare spending or reimbursement accounts (HSA/FSA)
• Retirement benefits (401k)
• Paid time off
• Holidays: 13 paid days per year
• Education assistance or tuition reimbursement-
• Employee discounts for Gym memberships & commuting/travel assistance

Our Values -

• We believe that working hard, when it is imbued with purpose, can and should be fun.
• You’ll find we are a “can do” place where people work together and roll up their sleeves to get the job done.
• Everyone has a voice; everyone’s ideas count, and everyone is respected.
• We have built a company, as well as a community of friends and colleagues, with respect for each other.