IT Data Analyst I

Compensation Range (Colorado only):

$72000$80000

Any Employment Offers are Contingent Upon Successful Completion of the Following:

• Verification of Work Authorization and Employment Eligibility
• Substance Abuse Screening
• Physical Exam (if applicable)
• Background Checks for Badging/Security Clearances (if applicable)

About Hensel Phelps:

Founded in 1937 Hensel Phelps specializes in building development construction and facility services in markets ranging from aviation to government commercial transportation critical facilities healthcare and transportation. Ranked #1 in aviation and #6 overall general contractor in 2024 by BDC Hensel Phelps is one of the largest employeeowned general contractors in the country. Driven to deliver EXCELLENCE in all we do and supported by our core values of Ownership Integrity Builder Diversity and Community Hensel Phelps brings our clients visions to life with a comprehensive approach that begins with innovative planning and extends throughout the life of the property.

Position Description:

The IT Data Analyst I will implement BI software and systems including integration services 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.

Position 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.
• Basic understanding of data models structures theories principles and practices.
• Knowledge of MS/Azure solution suite including MS SQL SSRS SSIS Event Hub Synapse DataVault etc.
• Familiarity with data preparation processing classification and forecasting.
• Working knowledge of relational database servers including MS SQL
• Exposure to data management techniques.
• 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 userfriendly language.
• Highly selfmotivated and directed.
• Keen attention to detail and strong organizational skills.
• Proven analytical and problemsolving abilities.
• Ability to effectively prioritize and execute tasks in a highpressure environment.
• Strong customer service orientation.
• Experience working in a teamoriented collaborative environment.

Essential Duties:

• Assist data leadership in establishing longterm strategic goals for business intelligent platforms and toolsets.
• 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.
• Creation and management of data queries based on business requirements as directed by data services team members / manager.
• Integrate data management applications with existing systems.
• 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 and update data definitions for new database file/table development and/or changes to existing ones.
• Assist management in determining required network components to ensure data access as well as data consistency and integrity.
• Develop routines for end users to facilitate bestpractice use of data management tools.
• Collaborate with database and disaster recovery administrators to ensure effective protection and integrity of data assets.
• Monitor data management system details within the database including stored procedures and execution time and implement efficiency improvements.

Physical Work Classification & Demands:

• 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.

Benefits:

Hensel Phelps provides generous benefits for our salaried employees. This position is eligible for company paid medical insurance life insurance accidental death & dismemberment longterm disability 401(K) retirement plan health savings account (HSA) (HSA not available in Hawaii) and our employee assistance program (EAP). It also is eligible for employee paid enrollment in vision and dental insurance. Hensel Phelps also believes in the importance of taking time to recharge. As a result salaried employees are eligible for paid time off beginning upon hire. Salaried positions (project engineers and above) participate in an annual bonus plan subject to company and employee performance. Salaried employees (this is all salaried employees) are also eligible for a company cell phone or cell phone allowance in accordance with company policy. Further salaried employees (project engineers and above) also receive either a vehicle or vehicle allowance in accordance with Hensel Phelps on position location a cost of living adjustment (COLA) may also be included (subject to periodic review and adjustment).

Equal Opportunity and Affirmative Action Employer:

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.

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about discussed or disclosed their own pay or the pay of another employee or applicant. However employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information unless the disclosure is (a) in response to a formal complaint or charge (b) in furtherance of an investigation proceeding hearing or action including an investigation conducted by the employer or (c) consistent with the contractors legal duty to furnish information. 41 CFR 601.35(c)

Required Experience:

IC