Tokio Marine HCC
SQL Database Developer
Tokio Marine HCC, Kennesaw, Georgia, us, 30156
Tokio Marine HCC (TMHCC) brings 50 years of service to the specialty insurance industry, today offering over 100 products to commercial customers in 180 countries worldwide. Organic growth and over 60 successful acquisitions have grown our 2022 Gross Written Premium (GWP) to $5 Billion. Our workforce has grown to 4,300 worldwide ... big, but not so big that you cannot make a difference. Our Good Company values, including integrity, empowerment, and commitment to customer service, and a culture of innovation, communication, and collaboration make TMHCC a great workplace.
TMHCC Stop Loss, a $2 billion division within TMHCC, leads the way in providing medical stop loss insurance sold to employers. Medical Stop Loss provides an added layer of insurance protection to employers who choose to self-fund their health benefit plans. Self-funding can incur risks from catastrophic claims, and Medical Stop Loss insurance from Tokio Marine HCC is designed to protect employers from that risk.
This is hybrid role located onsite in Birmingh, AL
Position Summary:
Designs, develops, implements, and maintains software solutions using SQL Server. Writes and maintains stored procedures, functions, or queries meant to assist the organization in accessing and analyzing business data. Maintains SSAS cube and creates relational and cube reports. Follows work plans, established timelines, and pre-defined goals for assigned work. Relying on instructions and pre-established guidelines, responsible for accomplishing the following as guided by others.
Key Responsibilities: Consult with users to identify current business operating procedures and to clarify program objectives. Design, create, test, and document data models that illustrate relationships between tables and other database objects. Create and document constraints that ensure integrity of data. Design, create, test, and document queries that are efficient with an emphasis on performance. Develop stored procedures, views, and functions. Diagnose and tune poorly performing queries. Implement transactions when appropriate to ensure data integrity. Work with analysts, end users, and other developers to analyze and design solutions that meet business objectives. TMHCC Stop Loss has business analysts and end users who participate in system development. These personnel have varying analytical skills which require SQL developers to collaborate with these individuals and develop solutions that meet business objectives. Design, create, test, and document SSIS packages as needed that do various ETL processes. Design, create, test, and document SSRS reports as needed. Data sources for these reports will be SQL Server Analysis Services cubes or stored procedures. Analyze and update SSAS Cube. Education, Experience & Knowledge
4 Year / Bachelors Degree in Computer Science, a related field, or the equivalent education and/or experience 2 Years Relevant and progressive professional experience Preferred MCSA: SQL Server 2012/2014 or higher Possess and have ability to apply broad knowledge of principles, practices, and procedures Excellent written and verbal communications skills with an emphasis on confidentiality Exceptional organizational and analytical skills; demonstrated ability to manage multiple tasks simultaneously Minimum 5 years database development in Microsoft SQL 2012 or above. T-SQL performance tuning. Past success creating database objects (tables, stored procedures, etc.) to support various interfaces and processes. Demonstrated experience with database design and analysis. Strong experience with data analysis. Ability to create SQL Server Integration Services packages. Knowledge of SQL transactions and how to utilize transactions when appropriate. Experience with SQL Server Reporting Services. Basic understanding of SQL Database Administration. Including but not limited to database backups/restores, transaction logs, and performance criteria. Working knowledge of SQL Server security: authentication, logins/roles, users/schema, permissions, encryption. Power BI Development experience in Reports, Dashboards and DAX queries is a plus Cloud Database experience is strongly preferred, including cloud native SQL solutions SSAS cube and MDX experience is preferred Strong Attention to Detail Demonstrated ability to quickly grasp new technological concepts and implement them Demonstrated ability to analyze and understand written procedures Possess developing analytical skills, as well an aptitude for decision-making and problem-solving Familiarity with cloud services including cloud databases Advanced proficiency and experience using Microsoft Office Package (Excel, Access, PowerPoint, Word) Primary responsibilities would be working with the Plexis HealthCare Systems', Quantum Choice databases and other systems. Tokio Marine offers a competitive salary and benefits package including:
Generous paid time off (PTO), 12 paid company holidays, 401(k) Retirement Plan with 6% company match. Health and dental insurance, vision plan available. Company provided long-term disability and life insurance. Opportunities for advancement in a successful and growing organization. Flexible work schedules and a great work/life balance. Paid Parental Leave. Volunteer Time Off. Enjoy casual dress and work in a modern, comfortable office with free parking. Hybrid work schedule
The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package. We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals. The Tokio Marine HCC Group of Companies is an equal-opportunity employer. Please visit www.tmhcc.com for more information about our companies.
#LI-CM3 #stoploss1
TMHCC Stop Loss, a $2 billion division within TMHCC, leads the way in providing medical stop loss insurance sold to employers. Medical Stop Loss provides an added layer of insurance protection to employers who choose to self-fund their health benefit plans. Self-funding can incur risks from catastrophic claims, and Medical Stop Loss insurance from Tokio Marine HCC is designed to protect employers from that risk.
This is hybrid role located onsite in Birmingh, AL
Position Summary:
Designs, develops, implements, and maintains software solutions using SQL Server. Writes and maintains stored procedures, functions, or queries meant to assist the organization in accessing and analyzing business data. Maintains SSAS cube and creates relational and cube reports. Follows work plans, established timelines, and pre-defined goals for assigned work. Relying on instructions and pre-established guidelines, responsible for accomplishing the following as guided by others.
Key Responsibilities: Consult with users to identify current business operating procedures and to clarify program objectives. Design, create, test, and document data models that illustrate relationships between tables and other database objects. Create and document constraints that ensure integrity of data. Design, create, test, and document queries that are efficient with an emphasis on performance. Develop stored procedures, views, and functions. Diagnose and tune poorly performing queries. Implement transactions when appropriate to ensure data integrity. Work with analysts, end users, and other developers to analyze and design solutions that meet business objectives. TMHCC Stop Loss has business analysts and end users who participate in system development. These personnel have varying analytical skills which require SQL developers to collaborate with these individuals and develop solutions that meet business objectives. Design, create, test, and document SSIS packages as needed that do various ETL processes. Design, create, test, and document SSRS reports as needed. Data sources for these reports will be SQL Server Analysis Services cubes or stored procedures. Analyze and update SSAS Cube. Education, Experience & Knowledge
4 Year / Bachelors Degree in Computer Science, a related field, or the equivalent education and/or experience 2 Years Relevant and progressive professional experience Preferred MCSA: SQL Server 2012/2014 or higher Possess and have ability to apply broad knowledge of principles, practices, and procedures Excellent written and verbal communications skills with an emphasis on confidentiality Exceptional organizational and analytical skills; demonstrated ability to manage multiple tasks simultaneously Minimum 5 years database development in Microsoft SQL 2012 or above. T-SQL performance tuning. Past success creating database objects (tables, stored procedures, etc.) to support various interfaces and processes. Demonstrated experience with database design and analysis. Strong experience with data analysis. Ability to create SQL Server Integration Services packages. Knowledge of SQL transactions and how to utilize transactions when appropriate. Experience with SQL Server Reporting Services. Basic understanding of SQL Database Administration. Including but not limited to database backups/restores, transaction logs, and performance criteria. Working knowledge of SQL Server security: authentication, logins/roles, users/schema, permissions, encryption. Power BI Development experience in Reports, Dashboards and DAX queries is a plus Cloud Database experience is strongly preferred, including cloud native SQL solutions SSAS cube and MDX experience is preferred Strong Attention to Detail Demonstrated ability to quickly grasp new technological concepts and implement them Demonstrated ability to analyze and understand written procedures Possess developing analytical skills, as well an aptitude for decision-making and problem-solving Familiarity with cloud services including cloud databases Advanced proficiency and experience using Microsoft Office Package (Excel, Access, PowerPoint, Word) Primary responsibilities would be working with the Plexis HealthCare Systems', Quantum Choice databases and other systems. Tokio Marine offers a competitive salary and benefits package including:
Generous paid time off (PTO), 12 paid company holidays, 401(k) Retirement Plan with 6% company match. Health and dental insurance, vision plan available. Company provided long-term disability and life insurance. Opportunities for advancement in a successful and growing organization. Flexible work schedules and a great work/life balance. Paid Parental Leave. Volunteer Time Off. Enjoy casual dress and work in a modern, comfortable office with free parking. Hybrid work schedule
The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package. We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals. The Tokio Marine HCC Group of Companies is an equal-opportunity employer. Please visit www.tmhcc.com for more information about our companies.
#LI-CM3 #stoploss1