Summary
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 Omaha 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 PowerShell, 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.
Essential Duties and Responsibilities 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.
Knowledge, Skills and Abilities:
- 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 PowerShell, 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
- Strong communication skills
- Excellent organizational skills and attention to detail
- Knowledge of construction industry processes preferred
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals to perform the essential functions of a job.
Education and/or Experience
Bachelor’s or associate degree in Information Systems, Computer Science, Business Analytics, Data Analytics or related field, and a minimum of three (3) years of experience in data analysis, business systems analysis, reporting, integrations, business intelligence, or related fields.
Language Skills
Ability to read, analyze, and interpret business documents, technical procedures, and system documentation. Ability to write reports, documentation, and business correspondence. Ability to effectively present information and respond to questions from managers, employees, and outside technology partners.
Mathematical Skills
Ability to work with mathematical concepts such as percentages, ratios, and basic statistics. Ability to apply these concepts to data analysis and to financial and operational reporting.
Reasoning Ability
Ability to solve practical problems and deal with a variety of variables in situations where only limited standardization exists. Ability to interpret a variety of technical instructions furnished in written, oral, diagram, or schedule form.
Certificates, Licenses and Registrations
Relevant certifications in Business Intelligence, Data Analytics, SQL, Power BI, or related technologies are a plus.
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential function of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle or feel, talk and hear, and work at a computer for extended periods. The employee is occasionally required to stand, walk, and reach with hands and arms. The employee must occasionally lift and/or move up to twenty-five (25) pounds without assistance. Specific vision abilities required by this job include close vision and ability to adjust focus.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This position works primarily in an office environment. The noise level in the work environment is usually quiet to moderate.
Conditions of Employment
Candidate is required to meet the above qualifications and job duties, task frequency and PPE requirements. Approval of pre-employment reference & background checks, and post offer drug testing with fit for employment screening are required as conditions of employment.
AN EQUAL OPPORTUNITY, AFFIRMATIVE ACTION, DRUG-FREE WORKPLACE EMPLOYER.