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

Hensel Phelps • Greeley, CO

90d • $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.
• 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.
• 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.
• 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.

Nice To Haves

• Construction industry knowledge a plus.
• Experience with SAP S/4 HANA, SAP Analytic Cloud, SAP Datasphere, SAP Master Data Governance, Azure Cloud, Power BI, DevOps, Synapse, BigQuery, Databricks, Data Vault, Python, SQL, DAX, Docker.

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).
• Employee assistance program (EAP).
• Employee paid enrollment in vision and dental insurance.
• Paid time off beginning upon hire.
• Annual bonus plan for salaried positions (project engineers and above).
• Company cell phone or cell phone allowance.
• Vehicle or vehicle allowance for salaried positions (project engineers and above).
• Cost-of-living adjustment (COLA) based on position location.

What This Job Offers

• Career Level: Senior
• Industry: Construction of Buildings
• Education Level: Bachelor's degree