What are the responsibilities and job description for the SQL PROGRAMMER position at Romph & Pou Agency?
Summary:
We are seeking an intermediate-level SQL developer to join our team. Candidate will working in a cloud-based Azure/SQL Server environment. Team members work in cohesion to enhance our SCORPIO proprietary database tool, which consists of maintenance, improvements and streamlining of all data intakes, data storage, stored procedures and automation, data manipulations and calculations and tool output/client deliverables.
Skills & Responsibilities:
- Programming complex views, stored procedures and functions
- Developing Report Server reports (Builder or Visual Studio) and accompanying queries/datasets
- Creating database triggers for automation, e.g., Agent jobs, automatic email notifications, etc.
- Writing queries to fulfill user requests (data extraction/importation, etc.)
Administrative Skill Required:
- Creating Integration System packages (Excel file upload/download, etc.) for data automation
- Writing queries for and assisting integration of third party applications (Power BI, Tableau, etc.)
- Creating table indexes to improve database performance
- Reviewing query performance and optimizing code
- Data modeling to visualize database structure
- Designing and creating tables to store user requests & application data
- Keeping detailed documentation of all created items
Other:
- Secondary programming languages a plus, especially Python, .NET and VBA
Benefits:
- Medical Coverage
- Dental Coverage
- Vision Coverage
- 401K
- Life Insurance (both Automatic and Supplemental up to $100,000)
- Paid Vacation Days/Personal Days/Sick Days
- 11 Weeks of Short-Term Disability Coverage
- Rewards Program for Length of Service
Perks:
- Free Sodas and Coffee
- Monthly Employee Work Anniversaries and Birthdays Celebrations
- Christmas Party in December
- Employee Crawfish Boil
- Halloween Potluck Lunch
- New Hire Breakfast Meet and Greets
- Business Casual Dress Code
- Community Involvement
Salary : $100,000
