IT Data Analyst II
IT Data Analyst II
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 82000 - 95000
1 Vacancy
Job Description
Compensation Range (Colorado only):
$82000.00 $95000.00
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 #6 overall general contractor in 2024 by BDC Hensel Phelps is one of the largest employeeowned 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 Data Analyst IIs role is to strategically design and implement BI software and systems including integration 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.
Position Qualifications:
- 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.
Knowledge & Experience:
- Demonstrated expertise in extracting valuable business insights from raw data.
- Direct experience with building reports to support business operations and corporate functions.
- Proficiency using Power BI and / or SAP Analytics Cloud to develop interactive dashboards and data visualization.
- Proficiency in using SQL to generate data tables.
- Experience with semantic models development with strong knowledge in DAX Power Query Data Flows Row Level Security Visualization Best Practices.
- Experience with paginated reports.
- Knowledge of Microsoft Fabric with a vision for production and managed selfservice opportunities.
- Experience with mentoring citizen developers and junior team members on best practices.
- Strong understanding of data models structures theories principles and practices.
- Excellent knowledge of data modeling.
- Strong familiarity with data preparation processing classification and forecasting.
- Working technical experience with relational database servers including Databricks Azure Synapse SQL Server and SAP Datasphere.
- Direct experience with data management techniques.
- Handson database tuning and troubleshooting experience.
- Project management experience.
- Good understanding of the organizations goals and objectives.
- Involvement in interdepartmental projects and experience communicating with various stakeholders.
Personal Attributes:
- 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 userfriendly language.
- Highly selfmotivated and directed.
- Keen attention to detail.
- Proven analytical and problemsolving abilities.
- Ability to effectively prioritize and execute tasks in a highpressure environment.
- Strong customer service orientation.
- Experience working in a teamoriented collaborative environment.
Essential Duties:
- Assess and cultivate longterm strategic goals for BI development in conjunction with end users managers clients and other stakeholders.
- 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.
- Collaborate with unit managers end users development staff and other stakeholders to integrate data management applications with existing systems.
- Provide and 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 data definitions for new database file/table development and/or changes to existing ones.
- Determine required network components to ensure data access as well as data consistency and integrity.
- Develop routines for end users to facilitate bestpractice use of data management tools.
- Monitor data management system details within the database including stored procedures and time and implement efficiency improvements.
- Responsible for creating/maintaining custom business reports and dashboards
Benefits:
Hensel Phelps provides generous benefits for our salaried employees. This position is eligible for company paid medical insurance life insurance accidental death & dismemberment longterm 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 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 contractors legal duty to furnish information. 41 CFR 601.35(c)
Required Experience:
IC
Employment Type
Full-Time
