IT Data Analyst I

Description

Compensation Range (Colorado only):

$68,970 – $76,230 annually

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 #12 overall general contractor in 2021 by ENR, Hensel Phelps is one of the largest employee-owned 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 and/or a combination of education and 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 user-friendly language.

Highly self-motivated and directed.

Keen attention to detail and strong organizational skills.

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:

Assist data leadership in establishing long-term 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 best-practice 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.

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)

Qualifications

Skills

Preferred

Critical Thinking: Intermediate

Software Development: Some Knowledge

Behaviors

Preferred

Innovative: Consistently introduces new ideas and demonstrates original thinking

Team Player: Works well as a member of a group

Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well

Motivations

Preferred

Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization

Job Security: Inspired to perform well by the knowledge that your job is safe

Entrepreneurial Spirit: Inspired to perform well by an ability to drive new ventures within the business

Education

Preferred

Bachelors or better in Information Technology

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

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)