Kansas Works Jobs

Kansas Works Logo

Job Information

WSP USA Sr. Lead Consultant, Data Scientist in Wichita, Kansas

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!

This Opportunity

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.

Your Impact

  • 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

Required Qualifications

  • 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

Preferred Qualifications

  • 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.

Additional Requirements

  • 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.

Additional Details

  • 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

About WSP

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.