Data Systems Developer

LiveTrends Design Group

Umatilla (FL)

On-site

USD 60,000 - 80,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive pay structure

Matching 401k

Medical insurance

Paid time off

Onsite gym

Job summary

A leading design company in Florida is seeking a Data Systems Developer responsible for designing and maintaining data systems. The ideal candidate will have proficiency in SQL, experience with SAP/ERP systems, and the ability to automate data processes. This full-time role offers competitive pay and benefits including medical insurance and a 401k matching program.

Qualifications

Proficiency in SQL development and complex querying.
Experience with SAP/ERP data structures.
Advanced skills in Excel and Access for data manipulation.

Responsibilities

Design and maintain data systems for various data sources.
Develop SQL queries to manipulate and manage data effectively.
Implement automation and process improvement in data workflows.

Skills

SQL Query Development

Data Analysis

Automation

Problem-Solving

Attention to Detail

Education

Bachelor's degree in Computer Science or related field

Tools

SAP

SQL Server

Excel

Access

Power BI

Tableau

Job description

Join to apply for the Data Systems Developer role at LiveTrends Design Group

Direct message the job poster from LiveTrends Design Group

LiveTrends Design Group (LTDG) is the leading design company within the global home décor industry. At LiveTrends 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

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 & Requirement

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

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.

Seniority level