Associate SQL Developer Analyst
Join us for an exciting opportunity to be part of a team that values your growth, fosters innovation, and encourages a positive work-life balance.
PAM Transport was founded in Tontitown, Arkansas, in 1980 by Paul Allen Maestri as a 5-truck operation. In our 40+ years of being in business, we have become an international company with more than 2,200 trucks and 8,000 trailers. Our goal is to provide exceptional service to our customers, and we believe that starts with having exceptional employees who are passionate about their work. Our culture is unique in that we offer the growth opportunities of a large company, but we still maintain that "small town feel" and community here at PAM.
About this opportunity
The Associate SQL Developer Analyst is a member of the analytics team who supports the business by creating and maintaining database structures. They will be writing and maintaining stored procedures, triggers, and maintaining documentation on our data warehouse environment. The position also works closely with business analysts, web developers, and business teams to meet data needs.
Pay and Schedule
This position is on site Monday - Friday 8:00AM to 5:00PM. The pay range is $55,000 to $65,000 dependent on experience.
Benefits
- Medical/Dental/Vision
- 401k Match Program
- Paid Time Off
- Direct Deposit
Main Job Tasks and Responsibilities
- Partner with IT team and Business to capture the requirements for data structures
- Create and Maintain database structure (tables, views, indexes)
- Write and maintain stored procedures, triggers, and user-defined functions
- Desire to learn new database systems
- Import/export data between systems
- Work with ETL tools or write custom scripts
- Work with others and communicate effectively across the business as well as IT personnel
Knowledge and Skills Required
- Understand normalization and relational database design
- SQL proficiency
- Familiarity with Microsoft SQL Server, MySQL
- Experience with Git
- Strong communication skills
- Familiarity with Power BI Dataflows (not required, but helpful)
- Background knowledge of transportation industry (not required, but helpful)
- Working knowledge with Word, Excel, PowerPoint
The company will provide reasonable accommodations to employees who require them to perform the essential functions of their job to the extent it does not impose an undue hardship or create a risk of harm to the employee or others. PAM Transport is proud to be an Equal Opportunity Employer and Drug Free workplace. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, among other things, or status as a qualified individual with disability.
Experience a workplace where your contributions matter and where you can thrive in a supportive environment.