Data Systems Analyst

General Excavating is an award-winning contractor serving public and private owners throughout Nebraska, South Dakota and Wyoming. General Excavating specializes in the construction of underground utilities, natural gas distribution, environmental remediation, excavation shoring, directional drilling, hydro-excavation, and heavy civil including bridge and concrete structures.

The Data Systems Analyst bridges business needs with technology by designing, implementing, and optimizing data systems and applications. Based in the Lincoln office, this role collaborates with teams across the organization to identify opportunities for automation and enhanced reporting while managing and optimizing key business systems such as Sage 300 CRE, HCSS Heavy Bid, HCSS Heavy Job, T3 and hh2. Analyzes complex data structures, builds dashboards and reports, develops automation workflows using tools such as Power Automate and Power Shell, supports data integration across multiple platforms, troubleshoots system performance, and maintains databases.

Responsibilities also include gathering user requirements, ensuring data integrity, identifying opportunities to leverage AI and leading its implementation across the business, and maintaining and continuously improving existing tools and systems to support business decision-making and efficiency.

include the following. Other duties may be assigned:

• Manage the design, implementation, testing, and maintenance of system integrations and automated workflows.
• Develop and maintain reporting solutions, dashboards, and analytics tools to support operational and strategic decision making.
• Collaborate with business stakeholders to gather reporting, integration, and data requirements.
• Analyze business and system data to identify trends, opportunities, exceptions, and process improvement recommendations.
• Create and maintain data mapping, transformation, and validation documentation.
• Monitor data quality and integrity across enterprise systems.
• Troubleshoot integration issues, data discrepancies, and reporting errors.
• Assist with enterprise reporting initiatives using tools such as Power BI, SQL, Excel, and business application reporting tools.
• Partner with application owners to improve data visibility and process efficiency.
• Support data conversions and migrations associated with implementations and system enhancements.
• Maintain documentation related to integrations, data structures, reporting processes, and system workflows.
• Assist with establishing and maintaining data governance standards and best practices.
• Provide end-user support and training related to reporting and analytics tools.
• Collaborate with internal and external technology partners on integration and reporting initiatives.
• Participate in process improvement and automation projects that reduce manual effort and improve accuracy.
• Identify and implement opportunities to leverage AI technologies to further enhance analysis and productivity to drive better business decisions.

• Experience working with business applications and databases (preferably experience with construction applications such as Sage 300 CRE, HCSS Heavy Bid, HCSS Heavy Job, T3 and hh2)
• Experience with Power BI, Power Automate, SQL, Microsoft Fabric, or other business intelligence tools
• Hands‑on scripting experience, including Power Shell, and a solid understanding of database relationships
• Experience creating reports, dashboards, and data visualizations
• Proficient in Excel
• Knowledge of data mapping, data validation, and data quality practices
• Strong analytical and problem‑solving skills
• Excellent organizational skills and attention to detail
• Knowledge of construction industry processes preferred