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.