Data Systems Developer

Description

About LiveTrends Design Group

LiveTrends is the leading design company within the global home décor industry. At LiveTrends Design Group (LTDG) we deliver inspiration and joy to over 10 million homes a year by combining two timeless forces, Nature and Art, into unforgettable home decor. Through constant innovation, creativity, and exceptional design we provide retail market leaders across North America and Europe with products and services that are changing the industry. All three of LTDG brands (LiveTrends, Urban Jungle, BeYou) are currently available at retailers such as Lowe’s, Kroger, Target, Costco, Trader Joe’s, Wegmans, and many more.

POSITION OBJECTIVES:

The Data Systems Developer is responsible for designing, developing, and maintaining data systems that involve extracting, transforming, and analyzing data from various sources. Their role involves working with SQL queries, SAP/ERP systems, Excel, and Access to manipulate and manage data effectively. They would also leverage Python and other tools to configure automations and API connections.

Requirements

• Data Extraction and Transformation: Extracting data from SAP/ERP systems and other sources, transforming and cleansing it as necessary to ensure accuracy and consistency.
• SQL Query Development: Developing complex SQL queries to retrieve and manipulate data from databases efficiently. This may include joining tables, filtering data, aggregating results, and implementing business logic.
• Data Analysis and Reporting: Analyzing data using Excel and Access, creating reports to present insights and trends, and generating data visualizations to facilitate decision-making.
• Data Integration: Integrating data from multiple sources, ensuring data consistency, and developing processes for data synchronization and consolidation.
• Database Design and Development: Designing and developing databases using SQL Server, Access, or other database management systems. This includes creating tables, views, indexes, and stored procedures based on data requirements.
• Data Validation and Quality Assurance: Implementing data validation checks and ensuring data accuracy, integrity, and quality throughout the data systems. This may involve performing data profiling, data cleansing, and data reconciliation activities.
• Automation and Process Improvement: Identifying opportunities to automate data processes, optimize data workflows, and improve data system performance. Developing scripts, macros, or automation tools to streamline data operations.
• Data Security and Compliance: Implementing data security measures to protect sensitive information.
• Documentation and Knowledge Sharing: Creating and maintaining documentation for data systems, including data dictionaries, process flows, and system architecture. Sharing knowledge with team members and stakeholders to ensure understanding and continuity.

SPECIFIC SKILLS

•  SQL Querying and Database Skills: Proficiency in SQL query development, including complex joins, aggregations, and data manipulation. Strong knowledge of relational database concepts, indexes, and performance optimization techniques.
• SAP/ERP Data Experience: Familiarity with SAP or other ERP systems and their data structures. Understanding of SAP modules and the ability to extract, transform, and load (ETL) data from SAP into other systems.
• Excel and Access Expertise: Advanced skills in Excel, including data manipulation, formula creation, pivot tables, and data visualization. Proficiency in Microsoft Access for managing and analyzing data, creating queries, and generating reports.
• Data Analysis and Reporting: Experience in data analysis, interpretation, and report creation. Knowledge of statistical analysis, data visualization tools (e.g., Power BI, Tableau), and Excel macros/VBA is a plus.
• Data Integration and ETL: Understanding of data integration methodologies and ETL processes. Familiarity with tools like SSIS (SQL Server Integration Services) or other data integration platforms.
• Familiarity with automation, API, and relevant tools.
• Problem-Solving and Analytical Skills: Strong analytical thinking and problem-solving abilities to identify data-related issues, troubleshoot problems, and propose effective solutions.
• Attention to Detail: Meticulous attention to detail to ensure data accuracy, perform thorough data validation, and identify anomalies or inconsistencies.
• Communication and Collaboration: Ability to interact with other team members and departments.

BENEFITS

• Competitive pay structure
• Matching 401k
• Medical insurance and additional health benefits
• Paid time off and paid holidays throughout the calendar year
• Onsite gym
• Sabbatical

Local Candidates Only

To Apply: https://recruiting.paylocity.com/recruiting/jobs/Details/3439094/Livetrends-Design-Group-LLC/Data-Systems-Developer

LiveTrends is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, religion, color, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit-based factors, or any other protected categories protected by federal, state, or local laws.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

LiveTrends does not accept unsolicited resumes from search firms or any other vendor services. Any unsolicited resumes will be considered property of LiveTrends and no fee will be paid in the event of a hire.

Disclaimer: “We do not advertise, recruit nor hire via Google Hangout. We do not request confidential information via email.” Any and all correspondences will come from an official “@livetrends.com” e-mail and that all candidates in any recruitment process will complete an in-person interview at our corporate office in Central, FL.