Sr Data Analyst & Automation (Python & SQL)

Lorven Technologies Inc.; Omaha (NE); On-site; USD 90,000 - 140,000; Full time

Job summary

Lorven Technologies Inc. seeks a highly skilled data analyst with a strong technical foundation and a passion for data-driven problem solving.

The role emphasizes hands-on Python and SQL expertise, advanced Excel, and the ability to translate data into actionable insights to automate workflows. You will drive end-to-end analytics, build dashboards with BI tools, and support EMS platforms such as Leader and Trip Optimizer through data analysis and continuous improvement.

Qualifications

• Hands-on data analytics, automation, and scalable solutions using Python.
• Querying and validating data with SQL for performance.
• Excel depth: complex formulas, pivots, and data modeling.
• Analytical prowess to identify trends, root causes, and improvement opportunities.
• Strong written and verbal communication for technical and business audiences.
• Experience working in cross-functional teams.
• Ability to identify and implement automation opportunities to reduce manual effort.

Responsibilities

• Transform data into actionable insights to drive automation across operational workflows.
• Develop and maintain dashboards using BI tools (e.g., Tableau) to monitor key metrics.
• Support EMS platforms (Leader and Trip Optimizer) through data analysis and monitoring.
• Collaborate with cross-functional teams to deliver end-to-end analytics solutions.

Skills

Analytical mindset

Problem solving

Communication skills

Cross-functional teamwork

Automation opportunities

Tools

Python

SQL

Excel

Tableau

PTC EMS

Job description

• Seeking a highly skilled data analyst with a strong technical foundation and a passion for data-driven problem solving.
• This role requires hands-on expertise in Python, SQL, and Advanced Analytics, with the ability to translate complex data into actionable insights and drive automation across operational Workflows.

REQUIRED SKILLS & QUALIFICATIONS:

• Strong scripting and programming expertise in python for data analysis, automation, and scalable solutions
• Advanced proficiency in Sql for querying, data validation, and performance optimization
• Expert-level experience with excel, including complex formulas, Pivots, and Data Modeling
• Exceptional analytical and problemsolving skills, with the ability to identify trends, root causes, and improvement opportunities
• Strong verbal and written communication skills, capable of clearly presenting technical findings to both technical and business audiences
• Proven ability to work effectively in cross functional team environments
• Demonstrated capability to identify and implement automation opportunities to reduce manual effort and improve data quality
• PREFERRED / NICE-TO-HAVE SKILLS:
• Experience building dashboards and analytics using tableau or similar bi tools
• Prior experience with PTC systems and energy management systems (ems), including leader and trip optimizer

EXPERIENCE LEVEL:

• 10-12 Years of Hands-On Experience Developing Solutions In Python With A Strong Focus On Data Analytics And Automation

DESIRED PROFILE:

• Extensive Experience Delivering EndToEnd Data Analytics Solutions, From Data Extraction Through Insights And Production Deployment
• Ability To Support, Enhance, And Troubleshoot Ems Platforms (Leader And Trip Optimizer) Through Data Analysis, Monitoring, And Continuous Improvement
• Self Driven, Detail Oriented Professional With A Strong Ownership Mindset And Commitment To Operational