IT Data Analyst

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.

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.

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

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

• 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,…