Lighthouse Technology Services is partnering with our client to fill their Data Analyst with Snowflake and SQL expertise position! This is a 6+ month contract with potential to extend opportunity and will be hybrid on site 3 days per week in Charlotte, North Carolina. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.
Position Overview:
What You’ll Be Doing:
ERP Support & Optimization
-
Provide ongoing ERP system support, including troubleshooting data-related issues through a ticketing system.
- Administer ERP configuration changes and enhancements to maintain data integrity and integration accuracy.
-
Provide Snowflake and SQL expertise.
- Support adoption and optimization of new and existing transaction types, promoting data governance best practices.
- Manage post-implementation feedback and drive continuous improvement through data analysis.
Data Analysis & Business Insights
- Gather, analyze, and interpret large datasets from ERP systems to support business decision-making and process optimization.
- Translate complex data into actionable insights that improve system performance and operational efficiency.
- Identify risks, dependencies, and process gaps through data analysis and recommend practical solutions.
- Evaluate system outputs to ensure alignment with defined data requirements and quality standards.
Data Modeling & Requirements Definition
- Break down complex business and functional requirements into detailed data models, user stories, and development-ready tasks.
- Translate business needs into clear, testable data requirements and acceptance criteria.
- Ensure solutions meet data quality standards and support broader digital transformation initiatives.
- Develop and execute data validation and testing scripts in collaboration with QA and development teams.
Collaboration & Agile Delivery
- Partner closely with Product Managers, Product Owners, developers, and cross-functional teams to define and refine data-driven features.
- Collaborate with third-party vendors and IT teams to support integrations, technical changes, and certification processes.
- Actively participate in Agile ceremonies (stand-ups, sprint planning, backlog grooming, retrospectives).
- Track milestones and progress of data-related deliverables to ensure on-time, high-quality execution.
What You’ll Need to Have:
Technical Expertise
- Strong experience working with large datasets and complex data structures.
- Advanced SQL skills (required) with the ability to write, optimize, and troubleshoot complex queries.
- Snowflake experience preferred.
- Solid understanding of data modeling concepts, data validation, and quality assurance processes.
- Experience working with ERP systems in a functional or analytical capacity.
- Proficiency in Microsoft Excel and other Microsoft Office tools.
- Familiarity with collaboration and Agile tools such as Azure DevOps and Miro is a plus.
Experience
- Bachelor’s degree in Information Systems, Data Science, or a related discipline preferred.
- 4+ years of experience in a Data Analyst, Functional Analyst, or Business Analyst role within ERP, digital product, or software development environments.
- At least 1 year of hands-on experience working in Agile frameworks (Scrum, SAFe, or similar).
Professional Skills
- Strong analytical and critical thinking capabilities with a data-driven problem-solving mindset.
- Demonstrated ownership and accountability for delivering high-quality data outcomes.
- Ability to translate technical concepts for business stakeholders and vice versa.
- Highly organized and detail-oriented; able to manage multiple priorities under tight deadlines.
- Strong communication skills and the ability to influence and build alignment across cross-functional teams.
- Willingness to travel to Charlotte NC occasionally (<5%) as needed to support project initiatives.
Pay Range: $50-$55/hr
Questions about any of our jobs? Email us at recruiting@lhtservices.com
View all of our open jobs here: jobs.lhtservices.com