Job Title: Data Engineer

Founded in 2003, Roundstone is not your typical insurance company. We’re on a mission to help employers save on healthcare benefits so they can put those savings towards bettering their businesses and taking care of their employees
Role Description
Responsible for the design, development, and installation of scalable SQL software solutions. The ideal candidate must have strong SQL & ETL experience. A strong aptitude for data analysis and data management is required.

Key Duties & Responsibilities:

Develop efficient and scalable technical solutions based on business requirements
Document solutions through a variety of ways; flowcharts, layouts, diagrams, charts, and code comments
Source code version control maintenance
Analyze existing SQL structures for optimization and automation
Collaborate with other technology members to design, implement and test for performance, data integrity and scalability
Responsible for managing and processing incoming and outgoing files (ETL)
Work to ensure that all project deliverables are on time and high quality
Adapt to changes in a fast paced and growing environment
Build scalable data pipelines and integrate new APIs to manage increasing data volume and complexity
Collaborate with data analytics and business teams to enhance data models for business intelligence tools, improving data accessibility and fostering organization-wide data-driven decision-making
Implement processes and systems to monitor data quality, ensuring accurate and available production data for stakeholders and critical business processes
Engage in data analysis to resolve data-related issues
Create data integrations and establish a framework for data quality
Collaborate with business units and IT teams to devise long-term data platform architecture strategy
Automate data movement within the data platform and incorporate monitoring, alerting, and data quality checks for accuracy
Design and deploy cloud-based data warehousing environments, processing frameworks, and models.
Implement cloud-based data infrastructure, optimizing for scale and performance.

Desired Qualifications:

Experience troubleshooting inaccurate data files or data errors
Setup and manage user security and SQL Agent jobs.
Experience with EDI X.12 formats
Technical competency across a variety of programming methods and tools
Familiar with file transfer protocols (FTP, SFTP, FTPS, SCP, HTTPS…)
MSSQL database experience using stored procedures, functions, views, scripting methods
ETL data transformation
Analytical and detail-oriented with well-developed critical thinking and problem-solving skills
Excellent verbal and written communication skills
Proficient in leveraging Azure cloud platform to develop scalable and cost-effective data solutions
Advanced level of Python or Java programming experience
Experience in designing, building, and maintaining data processing systems using modern data platforms

Better Benefits:

We’re leaders in our industry, so naturally we look out for our employees’ best interests with a robust benefits package. Roundstone employees are eligible for:

Medical, dental and vision benefits
Annual bonus
Parental leave
Dependent care 100% match up to max allowable
PTO beginning on Day 1
Tuition reimbursement
Health work/life balance
Hybrid office schedule
401(k) plan with company match
Employee Assistance Program
On-site gym with personal trainer access
Life insurance and short term disability insurance

More About Roundstone

Headquartered in Lakewood, Ohio, Roundstone is regularly recognized as a Northeast Ohio Top Workplace by the Plain Dealer and cleveland.com. We are especially proud to be recognized as a Top Workplace since this honor is determined by anonymous feedback from our own employees. Roundstone employees enjoy a supportive workplace where they are engaged, valued and regularly recognized for their hard work at monthly company meetings. Roundstone’s core values are evident every day and are shared with the community through the sponsorship of community events and outreach.

Our Core Values

Live well: Be healthier and bring positive energy to all you do.
Work smarter: Get things done, better.
Own it: Accountability is your middle name. Be on time, do what you say, and finish what you start.
Be intellectually curious: Always be learning. See opportunity everywhere and have a drive to know.

Culture and fit are integral to success and in an effort to achieve a better match both from a candidate's perspective and our organization, please take a minute, click on the link and take the really brief survey:

https://go.cultureindex.com/p/92FH9vpLnRvn7xN7kG

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Roundstone Insurance we are dedicated to building a diverse, inclusive, and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Roundstone

New Jobs

Data Engineer - Cleveland Based