WSP USA Sr. Lead Consultant, Data Scientist in Worcester, Massachusetts
Sr. Lead Consultant, Data Scientist
Req ID 8164
Sr. Lead Consultant, Data Scientist
Who We Are
At WSP, we are driven by inspiring future-ready pioneers to innovate. We’re looking to grow our teams with people who are ready to collaborate in building communities and expanding our skylines. To do this, we hire candidates of all experiences, skillsets, backgrounds and walks of life. We actively foster a work environment and culture where inclusion and diversity is part of our fundamental structure. This is delivered behaviorally, through our policies, trainings, local partnerships with professional diverse organizations, internal networks and most importantly with the support and sponsorship of our leaders who help drive our commitment to an inclusive, diverse, welcoming and equitable work environment. Anything is within our reach and yours as a WSP employee. Come join us and help shape the future!
WSP is currently initiating a search for a Sr. Lead Consultant, Data Scientist for our Sacramento , CA office. Must be willing to relocate for the role. Be involved in projects with our Technology Team and be a part of a growing organization that meets our client’s objectives and solves their challenges.
This position will ensure the timely creation of reports to meet various business needs, as well as assist in defining processes, standards, and best practices in reports development. This position is also responsible for helping clients establish an enterprise reporting framework that aligns with other areas of the overall enterprise architecture.
Review business requirements documentation to understand reporting needs/requirements with respect to business goals and objectives.
Collaborate with both business and IT SMEs to collect, verify, develop, and document applicable reports requirements.
Analyze, evaluate, make changes, and keep up to date all reports requirements and reports specifications.
Collaborate with other team members and designated SMEs to suggest and make improvements to enterprise reporting framework and platform architecture and properly document/refine all applicable technical specification.
Lead and/or assist in developing a set of standards, processes, and best practices in the use of SQL-based Reports for reports creation
Provide guidance and support to other CalSTRS teams; explain reporting standards, processes, and best practices to various stakeholders.
Who You Are
Minimum 10 years of experience working as a reports developer creating and fine-tuning SQL reports from data stored in various relational databases.
Minimum 10 years of experience designing, developing, debugging and supporting complex data integration interfaces and processes using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology.
Minimum 10 years of experience demonstrating understanding of SDLC methodologies specific to requirements elicitation and analysis, analyzing business processes, business process modeling, preparing business use cases, logical data modeling, and user interface design for reports.
Bachelor's degree in Computer Science, Business Information Systems or related technical degree
Strong system analysis skills – data interpretation and explanation of condition, trends etc.
Excellent oral, written and communication skills
Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities.
Ability to work independently and with others
Must possess a BS in Computer Science or related technical degree
Master’s Degree in Computer Science, Business Information Systems or related technical degree
Previous experience with CalSTRS specific Pension Solution System and in-depth knowledge of the Pension Product that is currently being configured and customized for CalSTRS is highly desired.
Experience developing SQL Reports as part of the data integration solution for a Pension Administration System.
Strong understanding of SQL Server Replication Services and experienced in setting up replication between a single source and multiple targets.
Experience developing and designing a business intelligence solution involving a data warehouse utilizing Microsoft tools and technologies available on premise as well as platform as a service in the public cloud
Compensation and Benefits:
WSP provides a comprehensive suite of benefits including medical, dental, vision, disability, life, and retirement savings focused on a providing health and financial stability throughout the employee’s career.
Expected Salary: $99,900 - $203,900
WSP USA is providing the compensation range and general description of other compensation and benefits that the company in good faith believes it might pay and/or offer for this position based on the successful applicant’s education, experience, knowledge, skills, and abilities in addition to internal equity and geographic location. WSP USA reserves the right to ultimately pay more or less than the posted range and offer additional benefits and other compensation, depending on circumstances not related to an applicant’s sex or other status protected by local, state, or federal law.
- To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions.
Travel Required: N/A - No travel required
Job Status: Regular
Employee Type: Full
Primary Location: SACRAMENTO - RIVER PLAZA
All locations: US-AK-Anchorage, US-AZ-Phoenix, US-AZ-Tempe, US-CA-Los Angeles, US-CA-Oakland, US-CA-Sacramento, US-CA-San Bernardino, US-CA-San Diego, US-CA-San Francisco, US-CO-Aurora, US-CO-Boulder, US-CO-Colorado Springs, US-CO-Denver, US-CO-Greenwood Village, US-CO-Lakewood, US-CT-Glastonbury, US-CT-Shelton, US-DC-Washington, US-FL-Fort Lauderdale, US-FL-Indiantown, US-FL-Jacksonville, US-FL-Lakeland, US-FL-Miami, US-FL-Orlando, US-FL-Pompano Beach, US-FL-Tallahassee, US-FL-Tampa, US-GA-Augusta, US-GA-College Park, US-GA-Gainesville, US-GA-Savannah, US-ID-Boise, US-IL-Chicago, US-IL-Springfield, US-IN-Indianapolis, US-KS-Wichita, US-KY-Louisville, US-LA-New Orleans, US-MA-Boston, US-MA-Worcester, US-MD-Baltimore, US-MD-Columbia, US-ME-Portland, US-MI-Detroit, US-MI-Lansing, US-MN-Minneapolis, US-MO-Kansas City, US-MO-St Louis, US-NC-Charlotte, US-NC-Fayetteville, US-NC-Greensboro, US-NC-Raleigh, US-NE-Lincoln, US-NJ-Jersey City, US-NJ-Lawrenceville, US-NJ-Morris Township, US-NJ-Newark, US-NM-Albuquerque, US-NM-Santa Fe, US-NV-Las Vegas, US-NV-Reno, US-NY-Albany, US-NY-New York, US-NY-Valhalla, US-OH-Cincinnati, US-OH-Cleveland, US-OH-Columbus, US-OR-Portland, US-PA-Ephrata, US-PA-Philadelphia, US-PA-Pittsburgh, US-SC-Columbia, US-SC-Greenville, US-TN-Memphis, US-TN-Nashville, US-TX-Austin, US-TX-Dallas, US-TX-El Paso, US-TX-Houston, US-TX-San Antonio, US-UT-Salt Lake City, US-VA-Lawrenceville, US-VA-Virginia Beach, US-WA-Federal Way, US-WA-Redmond, US-WA-Seattle, US-WA-Spokane, US-WI-Green Bay, US-WI-Madison, US-WI-Milwaukee, US-WY-Buffalo
WSP USA is the U.S. operating company of WSP, one of the world's leading engineering and professional services firms. Dedicated to serving local communities, we are engineers, planners, technical experts, strategic advisors and construction management professionals. WSP USA designs lasting solutions in the buildings, transportation, energy, water and environment markets. With more than 12,000 employees in over 200 offices across the U.S., we partner with our clients to help communities prosper. www.wsp.com
WSP provides a flexible, agile and hybrid workplace model while meeting client needs. Employees are also afforded a comprehensive suite of benefits including medical, dental, vision, disability, life, and retirement savings focused on providing health and financial stability throughout the employee’s career.
At WSP, we want to give our employees the challenges they seek to grow their careers and knowledge base. Your daily contributions to your team will be essential in meeting client objectives, goals and challenges. Are you ready to get started?
WSP USA (and all of its U.S. companies) is an Equal Opportunity Employer Race/Age/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Disability or Protected Veteran Status.
The selected candidate must be authorized to work in the United States.
- WSP USA Jobs