Associate Project Manager - Data Analytics
for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title. No Job ID etc. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning, duplicated lines, application instructions. Also remove "Transparency Statement", "Equal Opportunity" etc. Keep substantive info.
We need to parse the posting.
Let's extract sections:
- Hybrid arrangement mention: "This position allows for a hybrid arrangement with a mix of work from home and in the office." That's about work arrangement; could be part of "About the role" or maybe "Schedule"? Not exactly schedule. Could be part of "About the role". We'll include in About the role.
- Responsibilities: The paragraph after "Requirements" actually seems like responsibilities list. The heading "Requirements" appears but then content is responsibilities. Actually the posting: "Requirements This position will interface..." So they mislabel. We need to treat content as responsibilities. So we will create a Responsibilities
with list items from that block.
Let's extract responsibilities bullet points (they are sentences separated by line breaks). We'll convert each to
About the role
This position will interface with project team leadership and stakeholders to coordinate project management functions throughout the project life cycle in support of Grid work. The role will provide an opportunity to understand and develop solutions to meet Project Management needs and Client requirements for the successful execution of projects. Using a variety of industry and proprietary software tools, and under the direction of project leadership, you may perform the following tasks:
- ... ...
About the role
This position will interface with project team leadership and stakeholders to coordinate project management functions throughout the project life cycle in support of Grid work. The role will provide an opportunity to understand and develop solutions to meet Project Management needs and Client requirements for the successful execution of projects.
Responsibilities
- Understand S&L and client procedures and processes, and ensure project team deliverables are in compliance ...
We do not sponsor employees for work authorization in the U.S. for this position.
A high school diploma or GED is required.
Comfortable with approximately 10-25% domestic travel.
Now Skills: include Essential Skills And Experience list, Valued But Not Required list, Technology & Innovation paragraph. We'll combine into- maybe separate subheadings? But we cannot add extra headings beyond allowed; but we can still have paragraphs and lists.
We'll do:
- 3+ years of construction or engineering internship, co-op, or work experience which includes project controls, project planning, project scheduling, and earned value performance, preferably within the power industry
- Knowledge of field/site work sequencing including civil, structural, electrical, and other related trades in the power, heavy civil, or commercial construction industry
- Experience within the energy, power, or utility industry
- Demonstrated ability to organize and prioritize work and work under pressure to meet deadlines
- Working knowledge in MS Office tools, with emphasis on the advanced use of MS Excel in creating and maintaining detailed, interactive spreadsheets, workbooks, and databases
- Excellent written and verbal communication skills, with a proven ability to interact and multitask with project team members, clients, and vendors of varying position levels
- Eager to cultivate program and project knowledge to make a valuable impact to the PMO team operation; willing to engage with others to understand PMO team and client needs
- Committed to deliver high quality, accurate deliverables with attention to detail
- Experience analyzing, validating, and reporting project, operational, financial, or engineering data using advanced Excel, Power BI, SQL, or similar analytics tools.
- Familiarity with data visualization, dashboard development, and KPI reporting to support project performance monitoring and decision-making.
- Experience working with large datasets, data quality validation, data cleansing, and process automation using Python, R, SQL, Power Query, or comparable tools.
- Knowledge of database concepts, data pipelines, ETL processes, or business intelligence platforms such as Power BI, Databricks, Tableau, or similar technologies.
- Demonstrated ability to identify trends, anomalies, risks, and improvement opportunities through quantitative analysis and present findings to stakeholders.
- Experience documenting business processes, developing standard operating procedures (SOPs), and supporting continuous improvement initiatives.
- A BS in Construction Management, Business, Engineering, or similar degree
- Familiarity with scheduling software, preferably Primavera
- Familiarity with finance and accounting systems
- Engineering design experience is a plus
- PMP Certification is a plus
- Construction/field knowledge or experience is a plus
Skills
Essential Skills And Experience:
Valued But Not Required Skills And Experience:
Technology & Innovation: Sargent & Lundy values the appropriate use of technology to improve how work gets done and deliver high-quality outcomes for our clients. Depending on the role, employees may use data, automation, artificial intelligence, and other digital tools to support research, analysis, engineering and design activities, workflow improvement, or other aspects of their work. We value candidates who demonstrate an interest in learning and effectively using emerging technologies where relevant to their role. Employees remain accountable for their work and are expected to apply appropriate professional judgment and review when using technology-assisted tools. Experience with AI, automation, programming, or similar technologies is valued where relevant but is not required unless specifically identified elsewhere in the job description.
Now Benefits: extract list. From text: "Health & Wellness Financial Benefits Work-Life Balance Health Plans: Medical, Dental, Vision Life & Accident Insurance Disability Coverage Employee Assistance Program (EAP) Back-Up Daycare FSA & HSA 401(k) Pre-Tax Commuter Account Merit Scholarship Program Employee Discount Program Corporate Charitable Giving Program Tuition Assistance First Professional Licensure Bonus Employee Referral Bonus Paid Annual Personal/Sick Time (PST) Paid Vacation Paid Holidays Paid Parental Leave Paid Bereavement Leave Flexible Work Arrangements" We'll make a list. Now Pay: "Compensation Range $74,353 - $113,595". Also "Individuals may also be eligible to participate in our yearly discretionary bonus." We'll include. Now Schedule: hybrid arrangement and travel 10-25% domestic (though we already used travel in Qualifications; maybe better to move travel to Schedule). Let's decide: Travel is schedule aspect. We'll put hybrid arrangement and travel in Schedule. Then Qualifications will not include travel. Thus Qualifications: work authorization statement, high school diploma/GED. Schedule: hybrid arrangement and travel. Let's adjust. Qualifications:We do not sponsor