SQL Developer / BI Analyst

P & S Transportation • AL, AL

121d

About The Position

Join our dynamic team at P&S Transportation as a SQL Developer and BI Analyst. In this role, you will play a crucial part in transforming raw data into actionable insights, enhancing our decision-making processes, and driving business success. If you thrive in a collaborative environment, possess exceptional technical skills, and have a keen eye for detail, we want to hear from you!

Requirements

• 2-3 years' experience as a Business Analyst, Data Analyst, DBA or similar role.
• Proven proficiency in SQL, Power BI, and API integrations.
• Excellent written and verbal communication skills.
• Ability to manage multiple tasks simultaneously with a commitment to high-quality outputs.
• Bachelor's degree in information technology or related field preferred, or equivalent experience.

Nice To Haves

• 3-5 years experience in a relevant role.
• Good organizational skills and customer service orientation.

Responsibilities

• Collaborate with stakeholders across departments to gather, document, and analyze business requirements.
• Extract, manipulate, and interpret data from multiple sources using advanced SQL querying.
• Design and develop interactive dashboards, reports, and business intelligence solutions using Power BI.
• Validate data integrity, ensure consistency of reports and dashboards, and troubleshoot issues related to data accuracy.
• Create comprehensive documentation for business requirements, technical specifications, data models, and standard operating procedures.
• Develop custom programming solutions to address specific business needs and enhance data workflows.
• Troubleshoot and resolve data-related issues, performance bottlenecks, and system errors.
• Provide technical support and end user training for BI tools and SQL.
• Participate in cross-functional projects including system migrations and process automation.
• Design, develop, and maintain API integrations for data exchange between internal systems and external platforms.
• Monitor API performance and troubleshoot integration issues.
• Administer, monitor, and maintain database systems for optimal performance and security.
• Optimize SQL queries, indexes, and database structures to improve application speed.
• Support and maintain SSIS packages for data transformation and integration.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree