Junior SQL Developer / BI Analyst

Verified Job On Employer Career Site

Job Summary:

P&S Transportation is one of the fastest growing flatbed trucking operations with terminals nationwide, committed to enhancing its services through top talent in the Logistics and Transportation field. The SQL Developer and BI Analyst will transform raw data into actionable insights, enhance decision-making processes, and drive business success through data manipulation, visualization, and custom programming.

Responsibilities:

• Collaborate with stakeholders across departments to gather, document, and analyze business requirements. Understand both current and future-state business processes to identify opportunities for improvement and innovation.

• Extract, manipulate, and interpret data from multiple sources using advanced SQL querying. Use data-driven approaches to identify trends, patterns, and business opportunities.

• Design and develop interactive dashboards, reports, and business intelligence solutions using Power BI. Translate complex data sets into clear and actionable insights for business users at all levels.

• Validate data integrity, ensure consistency of reports and dashboards, and troubleshoot issues related to data accuracy, system integration, and business logic.

• Create comprehensive documentation for business requirements, technical specifications, data models, analytical methodologies, and standard operating procedures.

• Comfortable working in a fast-paced environment and adjusting priorities based on evolving business needs.

• Develop custom programming solutions to address specific business needs, automate repetitive tasks, and enhance data workflows.

• Troubleshoot and resolve data-related issues, performance bottlenecks, and system errors.

• Stay current with industry trends, best practices, and emerging technologies in SQL, BI, and programming languages.

• Provide technical support and end user training, enabling users to utilize BI tools and SQL effectively.

• Participate in cross-functional projects including system migrations, process automation and digital transformation initiatives.

• Design, develop, and maintain API integrations to facilitate seamless data exchange between internal systems and external platforms.

• Monitor API performance and troubleshoot integration issues, ensuring timely resolution and robust connectivity.

• Document API specifications, usage guidelines, and best practices for both internal teams and external partners.

• Administer, monitor, and maintain database systems to ensure optimal performance, security, and reliability.

• Manage database access and user permissions in accordance with compliance and security policies.

• Optimize SQL queries, indexes, and database structures to improve application speed and resource efficiency.

• Proactively identify and resolve database issues, ensuring minimal disruption to system availability and user productivity.

• Support and maintain SSIS packages for data transformation and integration across systems.

• Perform light SQL Server administration tasks, including database backups, user permissions, and performance monitoring.

• Collect business intelligence data from sources which may include industry reports, public information, field reports or purchased findings. This may mean updating your knowledge about relevant technology trends or emerging markets in your industry, in addition to gathering data related to the customers and the market.

• Analyze the data to identify any trends that could impact your business’ strategies.

• Utilize the results of the analysis to support recommendations for action to improve or even grow the company.

• Prepare analytical reports to summarize findings and share with the appropriate company stakeholders through established communication processes.

• Work with a variety of people, both internally and externally, to stay aware of trends in your own business and the industry at large. Manage the flow of information, so data is analyzed, summarized and routed to the proper stakeholders in a timely manner.

Qualifications:

Required:

• 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 with the ability to convey technical concepts to non-technical stakeholders

• Ability to manage multiple tasks simultaneously with a commitment to producing high-quality, accurate, and reliable outputs

• 4 year degree

• 3-5 years experience

Preferred:

• Bachelor’s degree in information technology or related field preferred, or equivalent experience

Company:

PS Logistics provides full-service transportation services, including asset-based transportation, and non-asset-based transportation. It is a sub-organization of P & S Transportation. Founded in 2004, the company is headquartered in Birmingham, Alabama, USA, with a team of 1001-5000 employees. The company is currently Late Stage.