VetJobs - The Leading Military Job Board

JOB SUMMARY The Senior Database Engineer position is responsible for creating and maintaining the integrity of reports, data integration, ETL, and the warehousing of system data. This position creates data models and modifies reports from various business systems, designs and creates data transfer from the business systems to the reporting databases. This position works directly with all departments to collaborate on projects and to solve complex business needs. Architecture and maintenance of the SQL Server are also within the responsibilities of this position. Daily monitoring and auditing of reports, applications, and database performance are required for this position. This position is also responsible for creating and maintaining documentation and flow charts for all job functions of the position. Performance and effectiveness of this position are indicated by, but not limited to, the accuracy of reports, the integrity of the databases, the consistent and accurate transferring of data between business systems and databases, helpdesk issue trend analysis, and performance in project execution and change requests.

Business Systems are defined as but not limited to Irium, Microsoft Navision (ELC), EveryWare, Microsoft Business Center, Oracle CRM, Microsoft Dev Ops, ManageEngine ServiceDesk Plus, Microsoft SQL Server, SQL Reporting Services, SQL Integration Services, Microsoft Power Platform, Azure SQL Services, and Microsoft Data Factory.

WHAT YOU’LL BE DOING

· Directly responsible for the data warehouse and system integrations.

· Directly responsible for the SQL Reporting Services reporting system and its related information systems, including but not limited to consistency and accuracy for all reporting areas; data quality assessments; training; system security; documentation; system change management; and testing and validation.

· Develops and maintains all process flowcharts and procedural documentation for all areas of responsibility.

· Ensures data quality and integrity and identifies most efficient use of system capabilities. Provides results to executive and operations management.

· Works directly with Business System Support Analysts in reviewing helpdesk and DevOps requests to identify trends and enhancement opportunities.

· Develops and employs database monitoring tools to pinpoint exception errors prior to processing and reporting.

· Creates and monitors programs and applications to solve business needs or improve processes and performance.

· Works directly with the IT department on the implementation of all reporting system hardware and software changes, including operating system software patches and upgrades, database uploads, hardware changes and upgrades, testing and validating all changes before going live and coordinate with functional leaders on the implementation.

· Requires staying abreast of emerging technologies and system enhancements to recommend new solutions as opportunities for increased business productivity may be realized.

· Learn all critical roles within each business unit and understand how these roles interact with our business systems and impact our customers and company.

· Creation and development of data sources, datasets, and multi-source data integrations.

· Actively participate in various meetings that assist in the gathering or analytical data or extracting meaningful recommendations as directed by Management.

· Participate in other analytical projects and activities as directed by Management.

· All other duties as assigned or required.

EXPERIENCE & SKILLS TO BE CONSIDERED

· Four-year Bachelor’s degree in Business, Computer Science, or Accounting or comparable educational degree with 4+ years of appropriate experience

· 4+ years of experience in database administration/development

· Strong knowledge of the Microsoft Power Platform, Azure SQL Services, Visual Studio, Data Factory, ETL

· Strong knowledge and experience in database management and administration, as well as data integration between various database types

· Excellent skills in developing complex reports in Power BI and SQL reporting services

· Experience in an ERP environment and good working knowledge of Microsoft Office products

· Excellent analytical and reasoning skills, strong knowledge and experience with Excel

· Strong communication skills, including oral, written and listening

· Must exhibit detail orientation and ability to manage multiple priorities simultaneously

· Ability to work and secure confidential information

· Soft skills including a willingness to learn, strong customer service, self-driven and strong collaboration experience (communication, creativity and working well under pressure)