Job Title: SQL Developer II
Salary: $90,000/yr on W2 all-inclusive with benefits
REMOTE
Job Description
Must-Haves
2+ years IT development experience required.
Fundamental understanding of relational and dimensional databases required
Bachelor's degree or equivalent certifications / experience required
Reponsibilities:
• 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 with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance process
• 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
• Demonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management Disciplines
• 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 Experience, Education, Certification / Training Required:
• Bachelor's degree or equivalent certifications / experience required
• 2+ years IT development experience required. Operational and/or Incident management experience a plus
• 1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plus
• Fundamental understanding of relational and dimensional databases required
• Fundamental database and SQL experience required. Microsoft T-SQL preferred
• Experience 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 plus
• Experience in the Insurance industry and/or LOMA coursework; ALMI designation a plus