SQL Developer II
USA, Remote
$75,000 - $90,000
The work we do has an impact on millions of lives, and you can be a part of it.
We help protect our customers against life’s uncertainties. Regardless of where you work within the company, you’ll be helping provide protection and peace of mind when our customers need it most.
The Engineer II App Dev will work as part of the Data & Reporting team under the direction of the Director of App Dev and under the general guidance of a Lead App Dev Engineer. The position relies on experience and judgment to support, enhance and create Information Delivery solutions, requiring a broad degree of independence, knowledge and problem solving skills.
The ideal candidate for the EDID is a technical resource that has experience building comprehensive data solutions (cubes, dashboards, visualizations, reports/extracts, etc.) to present data from multiple source systems or models, transform data according to Business Rules and MDM, work with the Enterprise Data team to assure attributes are properly governed and also loaded into operational and presentation models. The role is required to analyze sources of data, determine optimal reporting methodologies, map and model to operational and presentation layer data models, identify enhancements, and other needs relative to the Enterprise Data Services area. The role additionally has input into Enterprise Data Services architecture, procedures and workflow. The role is also expected to have a business acumen in order to provide effective and efficient solutions. Individuals in this role are expected to have the ability to multitask on various projects and priorities and keep them all moving forward. The role influences others in ITthrough sharing of specialized Enterprise Data Services technical knowledge. This role is expected to support and expand a culture of operational excellence.
This position requires a technical individual that has the ability to communicate clearly with other IT professionals using technically sound terminology and excellent communication skills.
The ideal candidate will be a self starter working in a fairly autonomous environment. They will need to have experience coding technically sound solutions following industry best practices specifically around Enterprise data presentation solutions. This candidate will have the ability to work on multiple workstreams at any given time. The candidate will possess institutional knowledge of the insurance and Enterprise Data Services industries in order to craft the most effective and efficient solutions for the business. The ability to understand complex business needs, logical problem solving skills, and strong written and verbal communication skills are required. Additionally, anunderstanding of database methodology and the MS BI stack are required.
Reponsibilities:
o Simultaneously address multiple units of work within a given timeframe/sprint to ensure timeline is adhered to, quality requirements are followed and acceptance criteria is met.
o Use Microsoft BI stack (SQL, SSIS, SSRS, SSAS) to develop Data Integration solutions as part of the continued development and maturation of the Enterprise Data assets
o Work with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance process
o Assure Data Integration solutions follow the department’s software development lifecycle processes and that all required artifacts and documentation have been created to support a seamless migration to the Enterprise Data Operations Support team
o Demonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management Disciplines
o Deploy solutions with written implementation, test and back-out plans according to the change control process
o Drive and own the necessary development tasks to support functional specifications
o Provide assistance to tier 4 support for Enterprise Data Assets and other legacy data stores/solutions. (Note: Tier 1 support is our NOC, tier 2 support is off-shore, tier 3 support is onshore and tier 4 support are our Sr. and Lead Data Integration developers)
o Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flow
o Apply our Enterprise Data Services standards in all development to ensure consistency and quality of work product
o Work within an agile environment following sprint commitments and release schedules
o Additional Duties:
o Actively participate in team meetings to support the group
o Actively participate in the culture of excellence as part of a BI delivery team
o Actively participate in team design reviews and co-operative architecture design sessions
o Work directly with Sr Enterprise Information Delivery Developers, Enterprise Business Intelligence
o & Analytics Developers and Enterprise Business/Data Analysts on data requirements and quality assurance
o Work efficiently and Effectively to ensure successful and timely completion of assigned project deliverables
o Work with manager to effectively define and manage toward goals that impact personal, team and company related objectives
o Create and manage timelines for all Enterprise Data Integration team members
o Drive and manage meetings that sole purpose is to communicate status of an individual team member’s project workload
Work Experience, Education, Certification / Training Required:
o Bachelor’s degree or equivalent certifications / experience required
o 2+ years IT development experience required. Operational and/or Incident management experience a plus
o 1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plus
o Fundamental understanding of relational and dimensional databases required
o Fundamental database and SQL experience required. Microsoft T-SQL preferred
o Experience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)
o Hands on experience with Microsoft SQL Server preferred. SQL Server 2012 Required and 2016 a plus
o Experience in the Insurance industry and/or LOMA coursework; ALMI designation a plus
o ITIL Foundation V3 Certification a plus
Knowledge, Skills and Abilities Required:
o Strong aptitude to pick up new skills and knowledge through research and perserverance
o The adaptability to work in an everchanging and dynamic environment
o Ability to think outside the box to provide innovative solutions
o Self-starter that can initiate research and/or contact with others in order to solve issues
o Embrace team environment and success
o Technically capable to perform job responsibilities and passion for technical growth
o Willingness not only to understand the technical nature of the task, but to build the subject domain knowledge around why the task is being done and how the results are being utilized by the business
o Strong communication skills
The roles targeted salary range for this position is $75,000 to $90,000. Actual salaries may vary depending on factors, including but not limited to, job location, skills, and experience. The range listed is just one component of our companies total compensation package for employees.
This position also offers additional incentive opportunities through an annual incentive based on individual and Company performance.
Employee Benefits:
We aim to protect our employees' wellbeing through a broad benefits offering. For example, we protect physical wellbeing through health, dental and vision insurance. We protect mental wellbeing through mental health benefits and an employee assistance program. We protect time away from work with a variety of paid time away benefits (e.g., paid time off, paid parental leave, short-term disability, and a cultural observance day). We protect financial wellbeing through contributions to healthcare accounts, a pension plan, and a 401(k) plan with Company matching. All employees are encouraged to protect their overall wellbeing by engaging in ProHealth Rewards, our company platform to improve wellbeing while earning cash rewards.
Eligibility for certain benefits may vary by position in accordance with the terms of the Company’s benefit plans.
Diversity and Inclusion:
We are committed to providing an inclusive culture where all employees are able to fully contribute and thrive. Our goal is to grow and develop our people, attract diverse talent and support strong, diverse communities.
We support diversity, equity, and inclusion by working to develop a culture of inclusion and belonging led by leaders who develop potential and embrace unique skills and abilities. Our aim is to create an equitable and accountable environment for all leaders and employees that will drive performance and impact business strategy. In this way, we can increase overall diversity for leadership roles and pipelines of talent by maturing our hiring practices, robust development opportunities and focus on retention of key talent.
We are proud to be an equal opportunity employer committed to being inclusive and attracting, retaining, and growing the talents of a diverse and inclusive workforce.