Job Title: Business Process Analyst Business Unit: Terra Technologies LLC, a Congruex Company Department: Operations Reports To: Project Controls Manager Employment Status: Full-Time, Non-Exempt Hourly Primary Location: Work from Home (Pacific or Mountain Time Zone only) Salary Range:$50k-$70k based on experience
Company Profile: Congruex
Congruex was formed in 2017 to take advantage of historic demand for digital connectivity. The digital networks we design and build for our clients enable everything in the modern world to operate, from healthcare and energy to transportation and social interactions.
Few companies in our industry can operate at scale and self-perform services like our multinational team. Our clients choose Congruex to deliver turn-key digital networks under a single platform. Our unified vision is to become the best end-to-end provider of network design and build services in the U.S.
We are the One Congruex Family. We are building tomorrow, together.
Why Work at Congruex
Opportunities We offer opportunities at all levels across the nation – from students to industry veterans – in areas of engineering, construction, and professional services. Wellbeing We value the wellbeing of our people and offer competitive compensation, health benefits, wellness resources, 401(k) retirement planning, and employee recognition and leadership development programs. Options may vary by geographic location.
Culture The pillars of Congruex culture are GRIT, safety, inclusion, and family.
GRIT: Our GRIT values are part of our company DNA and the touchstone for our multinational workforce.
Guts - having the guts to do the right thing
Reliability - being reliable to deliver what we promise
Innovation - innovating every day
Teamwork - embracing teamwork together as One Congruex
Safety: We are committed to 24/7 safety practices on our jobsites, within our offices, and all the places our team exists in between.
Inclusion: Congruex embraces our team’s diversity and promotes an inclusive workplace for all.
Family: We are a family-oriented company committed to the long-term health and development of our people.
Terra Technologies LLC, a Congruex Company Terra Technologies LLC is a rapidly expanding nationwide engineering and construction company. Terra Technologies LLC is unique in the fact that it blends civil engineering with utility engineering to provide design support for roadway projects impacting facilities of some of the largest utility companies in the nation.
Job Summary: This position will be responsible for maintaining and modifying data used to centralize information in a data warehouse. Employee will help develop warehouse reporting using basic ETL (extract, transform, load) methodologies in a Microsoft stack. The candidate will work with large and varied datasets to create business reporting. The candidate will effectively communicate the results of data analysis in written, statistical, and verbal form to managers.
Job Responsibilities (Including, but not limited to):
Develop and maintain ETL scripts to curate warehouse data
Develop and maintain Power BI reporting
Support Executive Leadership and Project Controls in database maintenance and modification. Tasks include:
Develop reports from various complex data sources
Document business processes
Train end-users on reports and dashboards
Support various workflow management systems
Engage with and support business stakeholders
Updates necessary tracking system(s) to ensure that project and/or program status is maintained with complete accuracy, including third party management systems
Creates and distributes correspondences relevant to the data analysis request
Communicates all issues to management prior to reaching critical status
Develops and maintains accurate and complete records; continues to monitor for applications and databases for failure
Required Skills & Qualifications:
High school diploma or GED equivalent
Extensive experience with SQL and SSMS and standard ETL practices
Extensive knowledge of Microsoft Office Suite
Experience with Microsoft Power Platform
Experience with Microsoft SharePoint
Ability to analyze and interpret large and varying sets of data
Proven track record of solving technical problems
Requires strong math and analytical skills
Good interpersonal skills as well as oral and written communications skills required to coordinate with reporting hierarchy
Critical thinking skills: make assessments and provide solutions to problems
Ability to be flexible, take direction and feedback with ease, including changes to process, workflow, schedule, and priorities
Handle large volume workload with a high frequency of repetition. Follow templates, process flows and standard operating procedures with complete accuracy and requiring minimal, if any, rework.
Skill and ability to perform moderately complex professional tasks under general supervision and guidance
Ability to independently organize own work to meet established objectives, using discretion in performing duties
Deadline driven, self-motivated, and technically savvy
Superior time management skills
Ability to work in a fast pace and changing telecom engineering and construction environment
Strong attention to detail
Desired Skills & Qualifications:
Bachelor’s degree or substitute relevant industry work experience (5 years).
May be required to travel at times for training purposes.
Able to sit for long periods.
Able to look at a computer screen for long periods.
All requirements are subject to possible modification to reasonably accommodate individuals with disabilities.
This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform other job-related duties requested by their supervisor.
Requirements are representative of minimum levels of knowledge, skills, and/or abilities. To perform this job successfully, the incumbent will possess the abilities or aptitudes to perform each duty proficiently.
This document does not create an employment contract, implied or otherwise, other than an “at-will” employment relationship.