IT Data Analyst II
About Hensel Phelps
At Hensel Phelps, we don’t just build projects—we build careers, communities, and a culture of excellence. As an employee-owned company, every person here plays a vital role in shaping our success and future. Guided by our core values of Ownership, Integrity, Builder mindset, Diversity, and Community, we combine cutting-edge technology with hands-on expertise to deliver landmark projects across the nation. When you join Hensel Phelps, you join a team that values your growth, empowers your ideas, and invests in your journey. Together, we create an environment where innovation thrives, safety is paramount, and every individual has the opportunity to make a lasting impact.
Job Description
The Data Analyst II’s role is to strategically design and implement BI software and systems, including integration with databases and data warehouses. This individual is also responsible for assisting in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation.
Key Responsibilities
- Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders
- Assist in the development of data management policies and procedures
- Identify research questions, problem solve using data analysis, and communicate the results to various stakeholders
- Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts
- Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data management applications with existing systems
- Provide and apply quality assurance best practices for data analysis services across the organization
- Develop, implement, and maintain change control and testing processes for modifications to data models
- Create data definitions for new database file/table development and/or changes to existing ones
- Determine required network components to ensure data access, as well as data consistency and integrity
- Develop routines for end users to facilitate best-practice use of data management tools
- Monitor data management system details within the database, including stored procedures and execution time, and implement efficiency improvements
- Responsible for creating/maintaining custom business reports and dashboards
Qualifications
- College diploma or university degree in the field of computer science or statistics, and/or 4+ years of equivalent work experience
- Certifications in BI solutions are a plus
- Strong understanding of data models, structures, theories, principles, and practices
- Excellent knowledge of data modeling tools such as Strong familiarity with data preparation, processing, classification, and forecasting
- Working technical experience with relational database servers, including
- Direct experience with data management techniques
- Hands-on database tuning and troubleshooting experience
- Project management experience
- Good understanding of the organization’s goals and objectives
- Involvement in inter-departmental projects and experience communicating with various stakeholders Good written and oral communication skills
- Strong technical documentation skills
- Good interpersonal skills
- Ability to conduct research into data management issues, practices, and products as required
- Ability to present ideas in a user-friendly language
- Highly self-motivated and directed
- Keen attention to detail
- Proven analytical and problem-solving abilities
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Strong customer service orientation
- Experience working in a team-oriented, collaborative environment.
Physical Requirements
Light Work. Exerting up to 25 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects.
- The individual in this position will periodically walk, kneel, sit, crouch, reach, stoop, read/see, speak, push, pull, lift, stand, and finger/type. The frequency of each action varies by workflow and office activity.
- Walking - The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, boxes, cabinets, etc.
- Constantly operates a computer and other office machinery, such as a calculator, copy machine, phone, computer, and computer printer.
- The person in this position frequently communicates with employees and external stakeholders regarding a variety of topics related to office administration.
- Constantly computes, analyzes, and conceptualizes mathematical calculations and formulas.
- Constantly reads written communications and views email submissions.
- The person in this position regularly sits in a stationary position in front of a computer screen.
- Visual acuity and ability to operate a vehicle as certified and appropriate.
- Rarely exposed to high and low temperatures
- Rarely exposed to noisy environments and outdoor elements such as precipitation and wind.
Education
College diploma or university degree in the field of computer science or statistics, and/or 4+ years of equivalent work experience.
Compensation Data
Direct Compensation:
- Annual Base Salary: $79,230.00 - $87,570.00 USD
- Anticipated Cost Of Living Adjustment: $0 - $19,200.00 USD (Depending on Location)
- Cell Phone Reimbursement: $900.00 USD
- Total Annual Direct Compensation: $80,130.00 - $107,670.00 USD
Indirect Compensation:
-
Retirement Account Contribution: 15% of base salary after one year of employment
Benefits
At Hensel Phelps, we invest in our people—professionally, personally, and financially. Employees are eligible for a comprehensive benefits package designed to support long-term well-being and career growth. Benefits offerings include medical, vision, and dental insurance; life insurance; accidental death and dismemberment coverage; long-term disability; a 401(k)-retirement plan; and access to our Employee Assistance Program (EAP).
We believe time away from work is essential to doing your best work. Employees are eligible for paid time off beginning upon hire, supporting rest, flexibility, and work-life balance.
Equal Opportunity Employer Statement
Hensel Phelps is an equal opportunity employer. Hensel Phelps is committed to engaging in affirmative action to increase employment opportunities for protected veterans and individuals with disabilities. Hensel Phelps shall not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, age, national origin, sexual orientation, gender identity and expression, domestic partner status, pregnancy, disability, citizenship, genetic information, protected veteran status, or any other characteristic protected by federal, state, or local law.