ETL Developer / SQL Report Writer

DescriptionAt FST, we are owners who actively listen to each other, embrace change, support our mission with enthusiasm, do what we say, and seek solutions for our business every day. Our employee-owners are driven to help our company grow. We're personally invested in ensuring our day to day operations are handled safely and efficiently. The company transitioned to an Employee Stock Ownership Plan (ESOP) model in 2014 to give our employees control of FST's success.We are seeking a skilled ETL Developer/Report Writer to join our team. The ideal candidate will have extensive experience with MS SQL, Pentaho, data warehousing, and logistics. This role involves designing, developing, and maintaining ETL processes and creating insightful reports to support business operations and decision-making.Responsibilities:ETL Development:Design, develop, and maintain ETL processes using Pentaho.Extract, transform, and load data from various sources into data warehouses.Ensure data quality and integrity throughout the ETL process.Report Writing:Develop and maintain reports using MS SQL and other reporting tools.Collaborate with stakeholders to understand reporting requirements and deliver actionable insights.Data Warehousing:Design and implement data warehouse solutions to support business intelligence and analytics.Optimize data warehouse performance and ensure scalability.Logistics Support:Analyze logistics data to identify trends and opportunities for improvement.Develop reports and dashboards to support logistics operations and decision-making.Collaboration:Work closely with data analysts, business stakeholders, and IT teams to ensure data solutions meet business needs.Provide technical support and training to end-users on data tools and reports.Requirements:? Live FST Traits of Reliable, Responsive, Adaptable, Passionate, and Innovative Take ownership of your Duty to Communicate all required and relevant information to necessary people, departments, and customers Proven experience as an ETL Developer/Report Writer. Experience with data warehousing concepts and technologies. Knowledge of logistics and supply chain management. Excellent problem-solving and analytical skills. Strong communication and collaboration abilities. Ability to manage multiple tasks and projects simultaneously. Attention to detail and commitment to data quality. Experience with other ETL tools and reporting platforms. Familiarity with big data technologies and cloud platforms. Minimum of 5 years of experience working in a similar industry in a DBA, reporting, or BI position Strong working knowledge of customer relationship management (CRM), salesforce automation (SFA), Business Intelligence and the concepts of Data Warehouses and Data Cubes Strong knowledge of working within Microsoft SQL Server, IBM DB2, SSRS, Power BI, Pentaho, and Crystal Reports. Strong knowledge of ERP, WMS and Accounting concepts required Prior experience working in or consulting in the distribution, logistics or transportation industry Prior experience with implementing technology solutions Prior experience interacting between the business operations and technology operations Strong interpersonal, problem management, and time management skills Excellent business acumen, written, and verbal communication skills Strong customer networking and relationship building skills Experience with process design, documentation, and assessment Knowledge of the activities, tasks, practices, and deliverables for assessing and documenting business opportunities; ability to assess the benefits, risks, and success factors of potential applications Ability to rapidly learn new software applications and functionality Strong working knowledge of Microsoft suite, including Microsoft Outlook, Teams, Word, Excel, and PowerPoint Proven experience in working remote and interacting with team members through web conferencing Bachelor's degree in business, technical, or other related field preferred or 5 years of practical experience in such a fieldDisclaimer: This job description does not include every duty or responsibility that the employee may be asked to perform at some point in time. Management may, at its discretion, assign or reassign duties and responsibilities to this job at any time. Nothing in this job description is intended to give rise to an employer-employee relationship, but not limited to an assumed offer of employmentFST Logistics is an equal opportunity employer

Created: 2024-11-02