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