IT Senior Data Engineer - Greeley, United States - Hensel Phelps

Description

Compensation Range (Colorado Only)

$80,000 - $105,000 annually
This position will be remote.

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

Data Engineer's role is to design, implement and maintain the enterprise data warehouse and other data repositories for reporting and ensuring high levels of data availability and security for our business users.

This individual will be responsible for leading our data efforts including all aspects of data flow, data modeling, dimensions, etc.

through to the use of AI and predictive modeling.

This individual will provide hands on design and development including sourcing and modeling data from various sources into our Data Vault 2.0 / Azure Synapse warehouse.

Position Qualifications

College diploma or university degree in the field of computer science or statistics, and/or 5+ years of equivalent work experience.

Certifications in BI solutions are a plus.
Strong understanding of database structures, theories, principles, and practices including enterprise data warehouses.
Strong familiarity with metadata management and associated processes.
Excellent verbal, written and analytical skills with the ability to actively listen and effectively gather business requirements for analysis.

Demonstrated expertise with data architecting, enterprise repository tools, data mining, large-scale data modeling, data mapping tools, data profiling tools, and data life cycle methodologies.

Direct experience in implementing enterprise data management processes, procedures, and decision support.
Construction industry knowledge a plus.
Hands-on database tuning and troubleshooting experience.
Excellent customer service skills combined with the ability to solve problems.
Attention to detail and strong analytical skills.
Ability to prioritize issues and monitor progress.
Ability to work in a team environment.
Azure
DevOps
Synapse
Data Vault
Python

SQL
Docker
Experience pulling data from APIs.
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 global maintenance schedules for BI and data warehousing systems.
Lead system feasibility studies, proof of concepts, pilot projects and testing.
Assist with data security best practices and documentation.

Lead the deployment, monitoring, maintenance, development, upgrade, and support of BI/EDW systems, including data architecture, data integration, high availability, security, and data privacy.

Analyze existing operations and make recommendations for the improvement and growth of the BI/EDW architecture.

Conduct research and remain current with the latest data technologies and solutions in support of future data management procurement efforts.

Develop, deploy, support, and optimize tools for data extraction, queries, and data manipulation in accordance with business processes utilizing the MS solution suite including Azure
SQL DB, Synapse, metadata automation.

Data modeling, data architecting and systems architecture development in collaboration with our solutions architecture team to ensure cross-application consistency and business value is realized.

Ensure the reliability of data access and data quality across the organization via ongoing database/enterprise data warehouse support and maintenance.

Develop, implement, and maintain change control and testing processes for modifications to enterprise data warehouse.
Document business and security requirements, test plans, database dictionaries, etc.
Identify inefficiencies and gaps in current data warehouse and leverage solutions to ensure data standards.
Documentation via automated data discovery and data maps.
Implement data security best practices and perform testing/remediation.

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 c)

#J-18808-Ljbffr