Sql Developer Ii Jobs

Job Title: SQL Developer II

Duration: Full time (Direct hire)

Location: Remote

Note: This full-time role and we are only looking for W2 candidates no C2C.

s

• 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 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 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.

Responsibilities:

• 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.
• Aid tier 4 support for Enterprise Data Assets and other legacy data stores/solutions. (Note: Tier 1 support is our NOC, tier 2 support is offshore, 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.
• Apply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work product.
• 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.
• 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.
• Deploy solutions with written implementation, test and back-out plans according to the change control process.
• Demonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management Disciplines
• Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes, and flow.
• Work within an agile environment following sprint commitments and release schedules.

Work Experience, Education, Certification / Training Required:

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