SQL Server Developer II - Remote

This position will be Remote.

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.6 million Ohioans through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement and individual plans.

Medical Mutual’ s status as a mutual company means we are owned by our policyholders, not stockholders, so we don’t answer to Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us and help our members achieve their best possible health and quality of life.

ETL/Software developer for the design, development, and support of the company’s operational data stores. Job duties involve profiling data, designing data models, developing data transformation jobs and processes, measuring data quality, and testing the performance. Developer will partner with other software developers, business systems analysts, and liaisons to translate user requirements and systems objectives into a logical, efficient, and optimal system design.

Responsibilities

• Determines data storage needs.
• Uses different data integration concepts to build a data store used with microservices and downstream operational systems
• Creates and enhances data solutions enabling near real time delivery of data and is responsible for collecting, parsing, managing, and analyzing sets of data.
• Participates in the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Designs, develops, automates, and support complex applications to extract, transform, and load data.
• Ensures data quality
• Meets with business to understand data, capture agreement on business rules, understand analyst and stakeholder objectives, and support usage of data to solve business problems
• Collaborates with other IT teams to deliver robust solutions end to end
• Data profiling, data documentation, and measuring data quality with manual verification and automation.
• Learns new technical concepts and software languages as needed.
• Performs other duties as assigned

Qualifications

Education and Experience:

• Bachelors degree in Computer Science, business or related field or equivalent experience.
• Minimum 2 years information systems experience.

Technical Skills and Knowledge:

• Communicates well, both written and verbal.
• Solid understanding of programming design and coding techniques.
• Solid understanding of systems development life cycle
• Experience with relational database technologies and query semantics
• Experience with multiple hardware and software platforms (e.g. mainframe, distributed, cloud, etc.).
• Excellent troubleshooting and problem-solving skills to dig into complex code issues and data analysi
• Experience with ETL technology and techniques
• Understanding of data modeling theory and techniques
• Experience with SSIS development
• Experience with C#, .NET Framework 4.6 (or later); .NET Core 2.1 (or higher)
• Microsoft Team Foundation Server (TFS), including build and deployment automation; GIT
• Modeling tools experience
• Experience with or knowledge of next generation data integration tools/languages, such as Azure Data Factory, Databricks, event messaging, and Spark

Medical Mutual is looking to grow our team! We truly value and respect the talents and abilities of all of our employees. That's why we offer an exceptional package that includes:

A Great Place to Work:

• Top Workplace in Northeast Ohio. Year after year we've received this recognition!
• On-site wellness center at most locations. Enjoy personal trainers, towel service, locker room, weight room, elliptical machines, and a variety of classes!
• On-site cafeteria serving hot breakfast and lunch, at most locations. Choices ranging from salad bar, made to order, hot and cold sandwiches, or a variety of entrees cooked fresh daily. Convenience store at most locations
• Employee discount program. Discounts at many places in and around town, just for being a Medical Mutual team member
• Business Casual attire

Excellent Benefits and Compensation:

• Competitive compensation plans
• Employee bonus program
• 401(k) with company match and an additional company contribution
• Excellent medical, dental, vision, and disability insurance

An Investment in You:

• Career development programs and classes
• Mentoring and coaching to help you advance
• Education reimbursement up to $5K per year

About Medical Mutual:

We strive to create peace of mind. Our customers can trust us to do things right and to help them get value from their health plan. We're the largest health insurer in Ohio and for over 85 years, we've been serving our members and the Ohio communities where they live and work. Medical Mutual is a Top Place to Work in Northeast Ohio with exceptional career opportunities that offer challenge, growth and a great work/life balance. We want talented, innovative, and driven people to help us continue to be the best health insurance choice of Ohioans and help make Ohio the best it can be! Our headquarter building is located in the heart of downtown Cleveland and we have multiple offices throughout the state. Join us at one near you!

At Medical Mutual and its family of companies we celebrate differences and are mutually invested in our employees and our community. We are proud to be an Equal Employment Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, veteran status, or disability status.

We maintain a drug-free workplace and perform pre-employment substance abuse and nicotine testing. #CB