Data Scientist-CIP/Proj Controls & Performance (WRD Technical Services)

Job Overview

The Data Scientist is responsible for modeling and analyzing large, complex data stores using statistical, algorithmic, and analytical techniques, methods, and procedures. The Data Scientist may also lead large system and data integration projects, with varied datasets, engineering specialized database and computing environments. The Data Scientist works closely with department directors, managers and colleagues turning data into congruent, reliable intelligent information and knowledge for use in strategic decision making.  Assists in the creation and development of an Enterprise-wide data warehouse.

Salary

$75,129 - $137,696

Ideal Candidate

The ideal candidate will possess a strong foundation in engineering, mathematics, computer science, or a related analytical field, with at least five years of professional experience analyzing large datasets in support of enterprise, capital projects, or public utility programs. The ideal candidate will have the combination of education, professional experience, skills, and traits to effectively support the ongoing needs associated with project management and project control via Oracle Primavera Unifier and P6, as well as move towards data-driven forecasting and continual optimization of project schedule and cost. 

This individual will demonstrate expertise in extracting, transforming, and analyzing complex data using advanced statistical methods, expert use of data visualization tools to create dashboards and reports, and leadership in communicating findings to stakeholders to support organizational decision-making. Experience with automating data pipelines and building predictive models and algorithms to forecast future outcomes and solve complex problems is a plus. The ideal candidate will be highly proficient in business intelligence platforms—particularly Power BI—and strong programming skills (ex. Python, R), knowledge of SQL and cloud platforms (ex. Azure, Oracle), and experience with machine learning algorithms and artificial intelligence frameworks is a plus.

They should exhibit excellent problem-solving abilities, sound judgment, and the capability to work both independently and collaboratively across the organization, including with Department and Division Directors, Planning, Project Management, Fiscal, and Contracts teams. Effective communication with leadership and stakeholders is essential, as is the ability to explain technical information to non-technical audiences. A self-motivated, strategic thinker with a high level of initiative and a commitment to data integrity and innovation will thrive in this role. Experience in government or public-sector data environments is a strong plus.

Core Competencies

• Customer Commitment - Proactively seeks to understand the needs of the customers and provide the highest standards of service.
• Dedication to Professionalism and Integrity - Demonstrates and promotes fair, honest, professional and ethical behaviors that establishes trust throughout the organization and with the public we serve.
• Organizational Excellence - Takes ownership for excellence through one's personal effectiveness and dedication to the continuous improvement of our operations. 
• Success through Teamwork - Collaborates and builds partnerships through trust and the open exchange of diverse ideas and perspectives to achieve organizational goals.

Duties and Responsibilities

Note: The following duties are illustrative and not exhaustive. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. Depending on assigned area of responsibility, incumbents in the position may perform one or more of the activities described below.

• Develops, modifies, and maintains advanced, complex SQL queries using Common Table Expressions (CTE).
• Performs data manipulation and arithmetic on data source values.
• Develops, modifies, and maintains Database objects.
• Develops automated reports from multiple data sources.
• Creates, modifies, and consumes data from Representational State Transfer (REST) and Simple Object Access Protocol (SOAP).
• Develops, modifies, and maintains Program Functions, Classes, and Procedures.
• Develops, modifies, and maintains Database Functions, Procedures and Packages/Classes.
• Creates, modifies, and maintains Business Intelligence (BI) Reports.
• Creates BI reports from multiple data sources using relational linking.
• Performs analysis and recommendations pertaining to the data.
• Creates multi-layered reports with drill downs and granular views