Founded in 1912, STV is a leading national infrastructure-focused professional services firm, providing engineering, architectural, planning, environmental, program management and construction management services for transportation systems, buildings, water, energy and other facilities. Headquartered in New York City, the company has more than 55 offices across North America. The firm is ranked 37th in Engineering News-Record's Top 500 Design Firms survey and is 11th in its transportation category. In 2022, STV signed the Equity in Infrastructure Project (EIP) Pledge, becoming one of the first architecture, engineering, and construction (AEC) firms to commit to advancing equity in infrastructure. Learn more at stvinc.com.

Grow at STV

Life is an ongoing learning experience, and we want you to continue to grow here at STV. We offer several programs and benefits, from professional development seminars, tuition reimbursement program, a career development program, online education initiatives, and much more to help you expand your knowledge and develop your skills, so you can take your career to the next level with STV.

Position Summary:

The IT Program Manager I is responsible for overseeing all business intelligence development activities for assigned projects. In addition, the candidate will drive all architectural strategies for BI efforts and ensure these strategies are being applied to solutions built. The IT Program Manager I may be required to act as Technical Lead on BI-centric projects. Additionally, it will be necessary for this position to participate in development as well as architecture and design. He/she is expected to have deep knowledge of the Microsoft BI stack (SSIS, SQL Server, SSAS, SSRS, PerformancePoint, Excel Services, and SharePoint, PowerBI) and may work with one or a range of these tools depending on project deliverables and team resourcing. The IT Program Manager I must have expert level skills in Data Warehousing and BI architecture such as the ETL process, dimensional modeling, OLAP, and Dashboards. Candidates must be interested in working in a collaborative environment and possess

good client interfacing skills, good communication skills and able to work in both a team environment as well as individually. Responsibilities range from architecting, designing and planning business intelligence solutions, configuring BI services, aggregating data from multiple sources into a data warehouse, creating and deploying reports, enhancements and providing solutions.

The IT Program Manager I position reports directly to the Director of Information Technology, and has no supervisory responsibility.

Position Description:

• Translates business requirements into a full end-to-end Business Intelligence Solution.

• Architects all BI solutions for assigned projects.

• Creates (ensures creation of) all solution documentation.

• Achieves and maintains relevant technical competencies and helps to foster an environment of continued growth and learning among colleagues on existing and emerging technologies.

• Effectively prioritizes responsibilities and communicates status of efforts to the project team.

• Other duties as assigned.

• Possess strong business acumen and consistently demonstrates forward thinking.

• Is able to effectively work with ambiguous or incomplete information.

• Must have a working knowledge and understanding of architectural frameworks and best practices.

• Must have a strong working knowledge of technical infrastructure, protocols and networks.

• Must have experience on multiple hardware and software environments and be comfortable in

• heterogeneous systems.

• Must possess a deep working knowledge of multiple platforms, operating systems, databases technology.

• Excellent organizational, communication and interpersonal skills are required.

• Must be able to routinely work with little or no supervision.

• Must be able to effectively and efficiently handle multiple and shifting priorities.

• Must remain calm while working in a high-pressure environment with many short deadlines.

Minimum Required Qualifications:

• A Bachelor's Degree in Computer Science or related field is required. A high school diploma, GED and/or equivalent combination of education and work experience may be substituted.

• A minimum of 10 years relevant experience with relational and multidimensional database design, implementation, strong T-SQL and knowledge of MDX.

• Proficient in Power BI.

• Experience with reporting systems and data warehouse requirements gathering, analysis and design of ETL processes using SQL Server Integration Services (SSIS).

• Expert knowledge of Data Warehousing and Business Intelligence design principles.

• Strong knowledge of BI tools, including the Microsoft BI Stack: SSIS, SSAS, and SSRS.

• Experience with delivering OLAP data to end users through Excel or other analytics products.

• Knowledge Trimble PMIS Systems

• Knowledge of UII System

Compensation Range:

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At STV, we are fully committed to expanding our culture of diversity and inclusion, one that will reflect the clients we serve and the communities we work in, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description we encourage you to apply anyways. You may be just the right candidate for this or other roles.

STV offers the following benefits * Health insurance, including an option with a Health Savings Account * Dental insurance * Vision insurance * Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable) * Disability insurance * Life Insurance and Accidental Death & Dismemberment * 401(k) Plan * Retirement Counseling * Employee Assistance Program * Paid Time Off (16 days) * Paid Holidays (8 days) * Back-Up Dependent Care (up to 10 days per year) * Parental Leave (up to 80 hours) * Continuing Education Program * Professional Licensure and Society Memberships

STV is committed to paying all of its employees in a fair, equitable, and transparent manner. The listed pay range is STV's good-faith salary estimate for this position. Please note that the final salary offered for this position may be outside of this published range based on many factors, including but not limited to geography, education, experience, and/or certifications.