Data Analyst – Business Applications Support

Job Description

Data Analyst | Lexicon, Inc.

The Tone:
This is a full-time role at Lexicon, Inc., situated in an office environment with occasional travel to job sites as needed. Lexicon is a company that provides comprehensive services across heavy industrial, commercial, and roadway projects, including construction management, fabrication, erection, mechanical installation, and plant maintenance. They also offer a full spectrum of golf course construction and management services. This Data Analyst position is critical for administering and improving key business applications, delivering reliable reporting, providing end-user training, and generating insightful analyses. The role ensures secure access provisioning, accurate data synchronization between systems, and actionable insights that directly support Lexicon’s operational and business goals.

The TL;DR
• Role: Full Time
• Type: Full-time
• Location: In-person, Office environment

• Mission: This role is responsible for ensuring secure access, accurate data synchronization, and actionable insights to drive strategic planning and operational decision-making.
• Tech Stack: SQL, Excel (including pivots/lookups, Power Query, VBA), Power BI, ERP, CRM, enterprise applications, file feeds, APIs, ETL/ELT concepts, Python, PowerShell, ticketing systems

What You’ll Actually Do
• Application Administration: Administer and support critical business applications, encompassing configuration, module setup, user management, issue triage, and troubleshooting to ensure seamless functionality.
• Data Integrity & Security: Own ERP/account access provisioning workflows, monitor and validate data synchronization, perform reconciliations, investigate exceptions, and coordinate fixes to uphold data integrity and secure user access.
• Insight Generation: Analyze operational and business data using SQL and Excel to uncover trends, identify root causes, and pinpoint improvement opportunities, translating these findings into clear insights and recommendations for strategic decision-making.
• User Empowerment: Provide comprehensive end-user training and support for business applications and reporting tools, creating and maintaining user guides, standard operating procedures (SOPs), and quick-reference documentation.
• Process Improvement: Partner with various departments to gather reporting and system requirements, clarify data definitions, and prioritize enhancements that streamline workflows, reduce manual effort, and improve overall accuracy while maintaining appropriate controls.

The Must-Haves
• Background: Bachelor’s degree in Data Science, Computer Science, Information Technology, Business, Analytics, or a related field.
• Experience: 0-4 years of experience in a data, reporting, systems, or application support role, including internships, co-ops, and relevant project work.
• Skills: Proficiency with Excel (including pivots/lookups) and SQL for querying and analysis, excellent analytical, organizational, problem-solving, and communication skills.
• Bonus: Experience supporting or administering enterprise applications (ERP, CRM), familiarity with data integrations (file feeds, APIs, ETL/ELT), comfort documenting requirements/UAT/SOPs, and basic scripting/automation (Python, PowerShell, or Excel VBA).