IT Senior Data Engineer (SAP, Data Warehousing and Modeling Focus)

Job description

**Description**

**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 BD+C, 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:**

Our growing Data & Analytics team is seeking a highly skilled Senior Data Engineer with extensive experience in using Azure and SAP technologies to build, maintain, and scale large enterprise datasets.

The ideal candidate will have a strong background in data modeling, integration, and migration techniques, and will be adept at handling complex data environments.

**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 architecture, enterprise architecture tools, data mining, large-scale data modeling, data mapping tools, data profiling tools, data governance 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.
+ SAP S/4 HANA
+ SAP Analytic Cloud
+ SAP Datasphere
+ SAP Mater Data Governance
+ Azure Cloud
+ Power Bi
+ DevOps
+ Synapse, BigQuery, Databricks
+ Data Vault
+ Python
+ SQL
+ Dax
+ 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 migration, data integration, and 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.

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

**Compensation Range (Colorado only):**

$84,930 - $93,870 annual salary

**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).

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

**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 contractor’s legal duty to furnish information.

41 CFR 60-1.35(c)

#LI-DG1

#LI-DG1

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.

Required Skill Profession

Other General