Sql Developer Ii Jobs

***This position is for our client***

SQL Developer II

Must-Haves

1. 2+ years IT development experience required.
2. Fundamental understanding of relational and dimensional databases required
3. Bachelor’s degree or equivalent certifications / experience required

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 IT through 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:

• Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flow
• Actively participate in team meetings to support the group
• Deploy solutions with written implementation, test and back-out plans according to the change control process
• Work with manager to effectively define and manage toward goals that impact personal, team and company related objectives
• 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)
• Work with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance process
• Work directly with Sr Enterprise Information Delivery Developers, Enterprise Business Intelligence
• 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
• 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
• Work efficiently and Effectively to ensure successful and timely completion of assigned project deliverables
• Actively participate in team design reviews and co-operative architecture design sessions
• Demonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management Disciplines
• Actively participate in the culture of excellence as part of a BI delivery team
• Drive and manage meetings that sole purpose is to communicate status of an individual team member’s project workload
• Additional Duties:
• Create and manage timelines for all Enterprise Data Integration team members
• & Analytics Developers and Enterprise Business/Data Analysts on data requirements and quality assurance
• Drive and own the necessary development tasks to support functional specifications
• 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.
• Work within an agile environment following sprint commitments and release schedules
• Apply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work product

Work Experience, Education, Certification / Training Required:

• 2+ years IT development experience required. Operational and/or Incident management experience a plus
• Fundamental understanding of relational and dimensional databases required
• 1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plus
• Experience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)
• Bachelor’s degree or equivalent certifications / experience required
• Hands on experience with Microsoft SQL Server preferred. SQL Server 2012 Required and 2016 a plus
• Fundamental database and SQL experience required. Microsoft T-SQL preferred
• Experience in the Insurance industry and/or LOMA coursework; ALMI designation a plus
• ITIL Foundation V3 Certification a plus

Knowledge, Skills and Abilities Required:

• Self-starter that can initiate research and/or contact with others in order to solve issues
• 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
• Strong communication skills
• Technically capable to perform job responsibilities and passion for technical growth
• The adaptability to work in an everchanging and dynamic environment
• Embrace team environment and success
• Strong aptitude to pick up new skills and knowledge through research and perserverance
• Ability to think outside the box to provide innovative solutions