DescriptionCompensation Range (Colorado only):$85,000.00 - $90,000.00Any 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 #12 overall general contractor in 2021 by EPosition 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.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.
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.
Essential Duties:
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
Benefits:Hensel Phelps provides generous benefits for our salaried employees. This position is eligible for company paid medical insurance, life insurance, accidental death & dismemberment, long-term 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’ policies. Based 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 and affirmative action employer. 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 contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe 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 contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)