- Develop, maintain, and enhance complex databases used for a variety of areas and functions using SQL, VB, VBA, Access, Excel and other software as applicable.
- Work with users to capture and analyze business and data requirements necessary to meet business needs and corporate strategies/goals.
- Write programs, develop and maintain distributed architecture databases for major corporate functions and develop required reporting.
- Evaluate and recommend to management appropriate hardware/software platform upgrades.
- Maintain documentation of all requests, data parameters and reports in an accurate and accessible manner.
- Streamline reporting as much as possible by automating queries, etc. and/or placing reports in production to minimize manual efforts.
Required Job Qualifications:
- Bachelors degree and 7 years experience in areas of information technology and 5+ years of relevant database and application development experience.
- Strong SQL expertise with the ability to write complex queries.
- MS SQL Server & SSIS experience
- Create, update, and maintain indexes, stored procedures, and triggers.
- Demonstrated experience in troubleshooting, resolving database problems, and tuning database/objects
- Design, implement, and maintain database objects (tables, views, indexes, etc.)
- Understanding of database design practices, including database normalization concepts
- Must be analytical, results-driven and able to employ the right approach and methods to make the maximum use of time and resources.
- Interprets business issues and recommends business solutions. Takes initiative to solves complex problems that have a far-reaching impact on the business. Works independently with minimal guidance.
- Verbal and written communication skills as well as interpersonal skills necessary to work in team environment.
- Organizational skills and experience managing completion of multiple projects.
Preferred Job Qualifications:
- Bachelors degree with concentration in Business, Math or Computer Science.
- Experience with Azure DevOps, PowerBI, Tableau