Position Summary
Reporting directly to the Director of Information Technology, the IT Program Manager will oversee all business intelligence development activities for assigned projects. Responsibilities include driving architectural strategies for BI efforts, ensuring their application to solutions, and potentially acting as Technical Lead on BI-centric projects. Additionally, participation in development, architecture, and design is required. Expertise in the Microsoft BI stack, including SSIS, SQL Server, SSAS, SSRS, PerformancePoint, Excel Services, SharePoint, and Power BI, is essential, with the possibility of working with various tools depending on project requirements and team resources. The IT Program Manager must possess advanced data warehousing and BI architecture skills, encompassing the ETL process, dimensional modeling, OLAP, and dashboards. Responsibilities span architecting, designing, and planning business intelligence solutions, configuring BI services, aggregating data from multiple sources into data warehouses, deploying reports and enhancements, and providing solutions. Candidates should thrive in collaborative environments, possess strong client interfacing and communication skills, and be capable of working both independently and within teams. This position does not entail supervisory responsibilities.
Duties include but are not limited to:
- Translates business requirements into comprehensive end-to-end business intelligence solutions.
- Designs all BI solutions for designated projects.
- Ensures creation of all necessary solution documentation.
- Attains and sustains relevant technical proficiencies and promotes a culture of continuous learning among colleagues in both established and emerging technologies.
- Prioritizes tasks effectively and provides clear updates on progress to the project team.
- Performs other assigned duties as necessary.
- Demonstrates strong business insight and consistently exhibits forward thinking.
- Capably navigates situations with ambiguous or incomplete information.
- Possesses a solid understanding of architectural frameworks and adheres to best practices.
- Demonstrates a robust understanding of technical infrastructure, protocols, and networks.
- Holds experience with various hardware and software environments, adapting well to diverse systems.
- Exhibits deep familiarity with multiple platforms, operating systems, and database technologies.
- Exhibits excellent organizational, communication, and interpersonal skills.
- Works proficiently with minimal supervision.
- Manages multiple priorities effectively and efficiently.
- Maintains composure in high-pressure environments with tight deadlines.
Position Qualifications
- A bachelor’s degree in computer science or a 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 and implementation, strong T-SQL, and knowledge of MDX.
- Proficient in Power BI.
- Experience with reporting systems and data warehouse requirements gathering, analyzing, and designing 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 delivering OLAP data to end users through Excel or other analytics products.
- Knowledge of Trimble PMIS Systems · Knowledge of UII System
Additional Requirements
Physical: Standing or sitting for long periods; must be able to lift up to 15 pounds at times and spend extended hours in front of a computer screen.
Cognitive: Problem-solving, written, and verbal communication skills; computer and software skills; and ability to read and interpret text online or in printed form.
About PMA
At PMA, employee well-being is a daily priority. We offer a combination of workplace options that include a PMA office location; work-from-home; or a client site. Wherever we work, we openly share knowledge as we believe that collaboration with peers improves our work product and that pursuing subject matter expertise is a lifelong endeavor.
We are committed to a culture of equity, diversity, and inclusion. We affirm and respect diverse backgrounds and opinions because we believe they yield the best solutions for our clients. We promote emotional intelligence and trust by nurturing these values within our new hires.
We encourage staff to develop rewarding, long-term careers at PMA, and we implement formal leadership development programs that help you attain your goals. At PMA, shared success is a core value. Every employee who contributes is recognized, celebrated, and rewarded. We look for self-driven candidates eager to assume responsibility and join a community of respect founded on collaboration and accountability, not titles. If you aim to transform the project management practice toward continuous improvement of project outcomes, the profession, and yourself, PMA looks forward to warmly welcoming you to our team.
We offer competitive pay and benefits, wellness programs for you and your family, and career development opportunities to advance your professional goals.
As a PMA professional, you will be empowered to make timely and effective decisions and significant daily contributions to complex facets of project delivery. Join a team that has achieved a world-class reputation in the construction industry and has been voted a “Best Place to Work.”
PMA offers competitive wages and comprehensive benefits, including medical, prescription, dental, vision, time off with pay, 401(k) with company match, life, disability, and professional development reimbursement for qualifying employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, gender identity, or gender expression), disability, national origin, or any other characteristic protected by applicable laws, regulations, and ordinances. Qualified female and minority applicants are encouraged to apply.
EOE, including persons with disabilities and veterans.
VEVRAA federal contractor.
