Citizens is pleased to offer this opportunity on a remote / virtual basis.  Preference will be given to (1) local, (2) FL based and (3) east coast candidates.  Visa sponsorship IS NOT being offered for this position at this time.

Searching for a place to make your mark? Every great team depends on the individual contributions of its members – the skills, talents and the passion that each team member brings. At Citizens, we’re building a workforce of top achievers committed to our company’s mission and vision. Our company values the knowledge that comes from experienced and dedicated individuals with a variety of backgrounds, in or out of insurance.

Citizens’ Mission is to provide property insurance protection in Florida to those who are, in good faith, unable to obtain coverage through the private market while also providing the utmost in customer service. Our Values are public service, integrity, respect, responsiveness and sound judgment. We strive to not only provide affordable insurance products and services but also to provide sound financial responsibility to the citizens of Florida.

At Citizens, we are a team of dedicated, service-minded professionals committed to our policyholders. Come achieve and maximize your potential with us!

JOB SUMMARY:

This position is responsible for analyzing, designing, developing, and testing reports and data models using Power BI or equivalent as part of data engineering development lifecycle.  Our ideal candidate will have knowledge and experience of data warehouses to query databases and data structures and solve complex problems utilizing subject matter expertise and collaborative skills. 

JOB DUTIES / ESSENTIAL FUNCTIONS:

Models ethical behavior and executes job responsibilities in accordance with Citizens’ core values, ethics, and information protection policies.

Senior:

1.     Plan, design, develop, modify, debug and evaluate complex software for functional areas.

Analyze existing data models or work to formulate logic using SQL on complex systems and devises complex algorithms.

Analyze the design and use of complex data sources.

Monitor and employ source code control techniques and configuration management.

2.     Negotiate with stakeholders on the creation of software specifications.

Negotiate project plans with stakeholders.

3.     Perform complex data analysis on OLAP and OLTP databases and test/debug complex queries, ETL’s and jobs.  

Apply moderately complex programming security practices.

4.     Develop and execute moderately complex stored procedures and SQL execution plans

Develop conversion and system implementation plans.

5.     Recommend and implement changes in development, maintenance and system standards.  Understand and apply industry practices, architectural standards and department policies and procedures relating to work assignments.

6.     Interact with senior level internal personnel.  Regularly report progress on projects.  Provide on-call support. Assist end users on report related training and mentor junior team members.

Intermediate:

1.     Plan, design, develop, modify, debug and evaluate reports and data models for functional areas.

Analyze existing data models or work to formulate logic using SQL on complex systems and devises complex algorithms.

Analyze the design and use of complex data sources.

Monitor and employ source code control techniques and configuration management.

2.     Negotiate with stakeholders on the creation of report specifications.

Negotiate project plans with stakeholders.

3.     Perform complex data analysis on OLAP and OLTP databases and test/debug complex queries, ETL’s and jobs.

Apply moderately complex programming security practices.

4.     Develop and execute moderately complex stored procedures and SQL execution plans

Develop conversion and system implementation plans.

5.     Recommend and implement changes in development, maintenance and system standards. Understand and apply industry practices, architectural standards and department policies and procedures relating to work assignments.

6.     Interact with senior level internal personnel. Regularly report progress on projects. Provide on-call support

REQUIRED EDUCATION AND EXPERIENCE:

Senior:

• Bachelor’s Degree OR 4 years relevant experience, OR a combination of college and experience equivalent to 2 years

PLUS

• 5 - 7 years of development experience (6+ years preferred)

Intermediate:

• Bachelor’s Degree OR 4 years relevant experience, OR a combination of college and experience equivalent to 2 years

PLUS

• 2 or more years of development experience (3+ years preferred)

TECHNICAL SKILLS:

• Data Visualization/processing tools - Power BI & Azure is required
• RDMS Database (preferably SQL Server) is required
• Report Builder or SSRS is required
• Python programming skills is required
• Application Packaging & Deployment is required
• DevOps, Cloud security, CI/CD (Continuous Integration & Continuous Development) is required
• Azure is required
• Systems Development Life Cycle (SDLC) is required
• Agile / Scrum Methods is required
• DAX is desired
• Web Application Development Frameworks is desired
• Cloud ETL/ELT Technologies (data pipelines), Cloud data services/storage platforms is desired
• Guidewire knowledge is desired
• Spark Architecture, Spark-SQL, DataFrames, Datasets and Spark Streaming is desired

PREFERRED EXPERIENCE:

• Advanced knowledge of secure software development of Advanced Analytics (AA) & Engineering.
• 4 or more years of experience in report and data model development utilizing Power BI, SSRS or equivalent
• 4 or more years of experience with SQL Development and Report Writing
• 3 or more years of Data Warehouse experience with hands on experience in ETL

OTHER SKILLS AND ABILITIES:

• Demonstrated skills associated with software design, modification, implementation and deployment, including object-oriented programming concepts. (Senior level should have advanced skills
• Demonstrated ability to develop conversion & system implementation plans, understand functional needs and how systems can support those needs
• Effective communication and interpersonal skills. Ability to effectively present technical topics to small and medium size technical groups.
• Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels of the organization.
• Demonstrated ability to create software specification, to contribute technical narrative to grant proposals and to follow software specifications, along with development of proof-of-concepts and demos for internal and external presentations
• Experience with identification and use of code libraries and open-source forums
• Demonstrated software repository skills, testing and test planning skills
• Experience with planning for deployment and creation of feedback mechanisms
• Thorough experience with common programming tools. Knowledge of secure software development
• Self-motivated and work independently and as part of a team. Able to learn effectively and meet deadlines
• Works under broad supervision on priorities and short-term goals
• Demonstrated broad problem-solving skills
• Knowledge or experience in Property & Casualty Insurance is preferred

We offer unlimited career potential, excellent training and development opportunities, and a structured Career Development program to explore future roles of interest while growing and developing in your existing role.

Citizens offers a competitive compensation and benefits package that includes comprehensive medical/dental, Retirement Savings Plan, Vacation and Sick Time, EAP, Tuition Reimbursement, Community Service and much more!

• Retirement savings plan with a generous company match
• Medical, dental and vision coverage
• Company Paid employee basic life insurance and short-term disability
• Generous paid time off: vacation, sick and holiday leave
• Employee Assistance and Wellness Programs
• Tuition reimbursement
• Professional and leadership development opportunities
• Company Paid Parking
• Employee recognition programs
• Relocation assistance (where applicable)
• Community and volunteering opportunities
• Casual dress

Citizens is proud to be an Equal Opportunity Employer. 

Visa sponsorship IS NOT available for this position at this time