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

Hensel Phelps•Greeley, CO

63d•$84,930 - $93,870

About The Position

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.

Requirements

College diploma or university degree in the field of computer science or statistics, and/or 5+ years of equivalent work experience.
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.
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

Nice To Haves

Certifications in BI solutions
Construction industry knowledge

Responsibilities

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.

Benefits

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)
employee assistance program (EAP)
employee paid enrollment in vision and dental insurance
paid time off beginning upon hire
annual bonus plan, subject to company and employee performance
company cell phone or cell phone allowance in accordance with company policy
vehicle or vehicle allowance in accordance with Hensel Phelps' policies
cost-of-living adjustment (COLA) may also be included (subject to periodic review and adjustment)