Junior Data analyst

Ledgent Technology; Vancouver (WA); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Ledgent Technology is seeking a meticulous Data Specialist to uphold data quality across ERP and business systems in a Vancouver, WA environment. The role emphasizes governance, audits, and cross-functional collaboration to maintain reliable data for operations.

You will work with ERP systems, ETL, EDI, and BI tools to ensure data integrity, support scheduling, and enable insights across departments. Strong Excel and BI skills are essential for success.

Qualifications

• Experience with ERP systems and enterprise business applications.
• Strong understanding of data quality, data governance, and master data management.
• Experience analyzing, validating, and correcting large datasets.
• Proficiency with Excel and data analysis tools.
• Troubleshooting and problem-solving skills.
• Ability to work independently while collaborating across departments.
• Excellent organizational skills and attention to detail.
• Strong written and verbal communication skills.

Responsibilities

• Serve as a primary steward of company data, ensuring data governance standards are followed.
• Audit master data and system records to identify and resolve data quality issues.
• Manage creation, maintenance, and validation of master data records (customer, product, pricing, routing, etc.).
• Analyze data discrepancies using reporting/analytic tools and implement corrective actions.
• Monitor and resolve EDI transmission and data errors.
• Collaborate daily with cross-functional stakeholders to complete data updates and processing.
• Perform root cause analysis of data/process issues and implement solutions.
• Support production scheduling and related operational processes.
• Assist with database modeling, maintenance, and execution within business apps.
• Develop SOPs and process documentation with metadata.
• Monitor ETL processes and escalate issues when needed.
• Support reporting/BI initiatives using analytics platforms and data visualization tools.
• Assist with troubleshooting datasets, report structures, and reporting issues.
• Continuously learn and support emerging reporting, analytics, and data management technologies.

Skills

Data governance

Data quality

Data analysis

Troubleshooting

Cross-functional collaboration

Attention to detail

Communication skills

Tools

Microsoft Excel

Power BI

Microsoft Access

ETL concepts

Fabric (Microsoft)

Job description

Data Specialist

w2 only no C2C or 3rd party

Location: Onsite/Hybrid Vancouver, WA Employment Type: Full-Time

Position Overview

We are seeking a detail-oriented Data Specialist to support enterprise-wide data quality, business operations, and systems integration initiatives. This role is responsible for maintaining accurate and reliable data across multiple ERP and business systems, ensuring data integrity, consistency, and operational effectiveness. The ideal candidate has a passion for data governance, process improvement, troubleshooting, and cross-functional collaboration.

This position offers exposure to ERP systems, reporting technologies, EDI processes, ETL monitoring, production scheduling support, and database management within a fast-paced operational environment.

Key Responsibilities

• Serve as a primary steward of company data, ensuring adherence to established data governance standards and best practices.
• Conduct regular audits of master data and system records to identify, investigate, and resolve data quality issues.
• Manage the creation, maintenance, and validation of customer, product, pricing, routing, and other master data records.
• Analyze data discrepancies, duplicates, and inaccuracies using reporting and analytical tools, implementing corrective actions as needed.
• Monitor, troubleshoot, and resolve Electronic Data Interchange (EDI) transmission and data errors.
• Collaborate daily with cross-functional stakeholders to ensure timely completion of critical data updates and processing activities.
• Perform root cause analysis of data and process issues and implement sustainable solutions.
• Support production scheduling and related operational processes.
• Assist with database modeling, maintenance, and execution within business applications.
• Develop and maintain standard operating procedures (SOPs), process documentation, and supporting metadata.
• Monitor critical ETL (Extract, Transform, Load) processes and elevate issues when necessary.
• Support reporting and business intelligence initiatives, including exposure to modern analytics platforms and data visualization tools.
• Assist with troubleshooting datasets, report structures, and reporting-related data issues.
• Continuously learn and support emerging reporting, analytics, and data management technologies.

Qualifications

Required:

• Experience working with ERP systems and enterprise business applications.
• Strong understanding of data quality, data governance, and master data management principles.
• Experience analyzing, validating, and correcting large datasets.
• Proficiency with Microsoft Excel and data analysis tools.
• Strong troubleshooting and problem-solving skills.
• Ability to work independently while collaborating effectively across multiple departments.
• Excellent organizational skills and attention to detail.
• Strong written and verbal communication skills.

• Experience with Microsoft Dynamics NAV, Dynamics 365 Business Central, or similar ERP platforms.
• Knowledge of EDI transactions and troubleshooting.
• Experience with relational databases and Microsoft Access.
• Familiarity with ETL processes and data integration concepts.
• Exposure to reporting and analytics platforms, including Microsoft Fabric, Power BI, or similar tools.
• Manufacturing, distribution, supply chain, or operations industry experience.

What You'll Bring

• A data-first mindset with a focus on accuracy and continuous improvement.
• Curiosity to investigate and solve complex data-related issues.
• Ability to manage multiple priorities in a deadline-driven environment.
• Strong analytical thinking and a passion for improving business processes through better data.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Los Angeles County Fair Chance Ordinance, and San Francisco Fair Chance Ordinance.