ParallelDesk
Login

SQL Developer II

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. \nReponsibilities: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.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 assetsWork with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance processAssure 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 teamDemonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management DisciplinesDeploy solutions with written implementation, test and back-out plans according to the change control processDrive and own the necessary development tasks to support functional specificationsProvide 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)Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flowApply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work productWork within an agile environment following sprint commitments and release schedulesAdditional Duties: Actively participate in team meetings to support the groupActively participate in the culture of excellence as part of a BI delivery teamActively participate in team design reviews and co-operative architecture design sessionsWork directly with Sr Enterprise Information Delivery Developers, Enterprise Business Intelligence & Analytics Developers and Enterprise Business/Data Analysts on data requirements and quality assuranceWork efficiently and Effectively to ensure successful and timely completion of assigned project deliverablesWork with manager to effectively define and manage toward goals that impact personal, team and company related objectives Create and manage timelines for all Enterprise Data Integration team membersDrive and manage meetings that sole purpose is to communicate status of an individual team member’s project workload Work Experience, Education, Certification / Training Required: Bachelor’s degree or equivalent certifications / experience required2+ years IT development experience required. Operational and/or Incident management experience a plus1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plusFundamental understanding of relational and dimensional databases requiredFundamental database and SQL experience required. Microsoft T-SQL preferredExperience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)Hands on experience with Microsoft SQL Server preferred. SQL Server 2012 Required and 2016 a plusExperience in the Insurance industry and/or LOMA coursework; ALMI designation a plusITIL Foundation V3 Certification a plusKnowledge, Skills and Abilities Required: Strong aptitude to pick up new skills and knowledge through research and perserveranceThe adaptability to work in an everchanging and dynamic environmentAbility to think outside the box to provide innovative solutions Self-starter that can initiate research and/or contact with others in order to solve issues Embrace team environment and successTechnically capable to perform job responsibilities and passion for technical growthWillingness 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 businessStrong communication skills\nEmployee 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, Protective’s 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: At Protective, 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.

Job Type
Full Time
Salary
N/A
Experience
N/A
Posted
14 days ago

Similar Jobs from Partners

More Jobs

Full Time Administrative Assistant

Palen Kimball / Saint Paul
16 hours ago

Apply

Project Manager - Building Automation and Controls

Systems Contractors / Ashburn
16 hours ago

Apply

Executive Information Security - Vakola Mumbai

Star Jobs Private Limited / Thane
14 days ago

Apply

Group Manager - Quality - GGN - NH8 - REF38049J

WNS Global Services / Gurugram
14 days ago

Apply

Sr Azure Cloud Engineer

ANI Calls India Private Limited / null
14 days ago

Apply

ParallelDesk News

Stellenmarkt des Kölner Studierendenwerks - Deine Stadt. Dein Job.

Srini | 21 December 2022

How do I make an HTTP request in Javascript?

Paralleldesk | 20 December 2022

Remote Jobs a Brief

Srini | 19 December 2022

US Green Card Immigration

Srini | 19 December 2022

Covid Conspiracy

Srini | 19 December 2022