Database Engineer II

Database Engineer IIUnder general supervision, the Database Engineer II is responsible for the overall development, testing and move to production of database products built in a cloud environment.Responsibilities include:Designs and creates moderately complex data models, develops and implements data products to support business needsDefines logical attributes and inter-relationships and designs data structures to accommodate business needsTests designed applications utilizing database management software or general programming softwareGathers system metrics pertaining to the running of data products to identify and resolve problems; determines and develops performance enhancements with measurable benchmarksWorks with DBA and Productions Services staff to monitor the running of data products to identify and resolve problems; continues performance enhancement with measurable benchmarksOwns the design/modeling portion of data projects through the all-project stages, preparing a technical design that reflects business requirements and is consistent with IT Strategy and overall IT ArchitectureEvaluate new technologies and develop project proposals for new IT services, including pilots and production applications and servicesWorks under minimal supervision with latitude for independent judgmentMay consult with senior peers on certain projectsMentors junior Database EngineersOther duties as assignedRequired qualifications include:Bachelor's degree in Computer Science or related fieldMinimum 3 years of Data Management experience proposing, documenting technology solutions and development experience with a focus on database architecture and data integration5+ years of expertise working with Data in a hands-on, developer role with advanced engineering principles and analytics developmentFluent in SQL (any flavor), having served in various capacities within design, development and deployment of data warehouses or relational/analytical/multi-dimensional data martsFamiliar with Virtual Data Warehousing or use of Snowflake DWaaSRelational Database Management Systems and expert SQL skills. Extract/Load/Transform (ELT) development skillsExperience with cloud migrations is desirableExperience building data pipelines on Azure following best practices in Cloud deploymentsDemonstrated ability to debug complex data issues while working on very large data sets with billions of recordsProven ability to work with business and technical audiences, on business requirement meetings, technical white boarding exercises, and SQL coding/debugging sessionsAbility to take the initiative to pursue assignments, responsibilities, and intake requests to a logical and final solution and to employ System Development Life Cycle (SDLC) standards is requiredExcellent verbal and written communication skills and strong analytical and problem-solving skills