Jenkins/Gales & Martinez, Inc. (JGM) has offered a comprehensive array of design and construction - related services to public and private sector clients since its founding in 1981.
Today JGM consists of more than 50 professionals who specialize in program, project and construction management, urban planning and architectural design in the fields of transportation infrastructure, civic, educational, institutional, residential and commercial facilities. ﾠAll of JGM's professional staff is committed to the common goal of providing high-quality services and expertise to our public and private sector clients.
With current projects such as the Crenshaw/LAX Transit Corridor, Westside Subway Extension, LAX-Delta Airlines Terminal Redevelopment, and various others, being a part of the JGM Family allows you the ability to work on some of the most iconic and influential programs in the region.
This position fills a critical role in a team responsible for developing BI & Analytics solutions for a variety of areas within the organization. Successful candidates will have the ability to design, develop, implement, Cognos Reporting, Crystal Reports and support SQL products including SSRS reports, SSIS packages, Agent jobs, RDLC solutions and more. Applicant must have a strong working knowledge of the SQL stack and will be assessed on their proficiency in SSRS, SSIS, and SSAS. Experience with multiple data marts such as Oracle and other data visualization tools such as Tableau preferred. Daily duties will include complex SQL development (Cognos, Crystal Reports, T-SQL, SSIS packages, RDLC solutions, Agent Jobs, etc.), maintenance and troubleshooting of existing products and reports, analytics, trend analysis, root cause analysis, and more. As such, applicants are expected to hold a wide range of proficiencies including scripting, coding, design, QA, optimization, writing (for proposals and presentations), and end-to-end management of projects (requirements, development, QA, and deployment). In order to understand the complex and dynamic needs of the business, frequent interaction and effective communication are also needed.
JGM is a Drug-free Workplace and an Equal Opportunity Employer