Data Warehouse / Business Intelligence Developer

Los Angeles, CA posted on February 15

More Jenkins, Gales & Martinez, Inc. jobs


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.  


Job Description

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.


Job Requirements

  • Bachelor's Degree from an accredited college or university.
  • Experienced SQL stack user is required: Very proficient in MS Visual Studio 2012 (or later), especially SSRS and SSIS, Cognos, Crystal Reports.
  • Excellent math skills (statistics, etc.).
  • Exceptional problem solver and possesses a strong attention to detail. The candidate must be able to not only point out what may not be working, but also the cause, and recommendation to rectify.
  • Strong organizational skills; ability to manage multiple projects with competing demands for resources; ability to adapt and change.
  • Have strong and effective written and verbal communication skills and be able to explain the logic behind their analysis and ideas clearly and concisely.
  • Possess a friendly and professional demeanor and ability to excel in a team environment where transparency is the standard.
  • Strong analytical and detail-oriented aptitude; a high degree of accuracy is required.
  • Ability to independently manage time effectively to ensure priorities and deadlines are met.
  • Experience with data cubes, database design, and data modeling.
  • Experience with Cognos and Crystal Reports is highly desirable.
  • Experience with Primavera P6 is highly desirable.



  • Large selection of medical plans and with a generous employer base plan--HMO, PPO, HSA/EPO options available; Dental, Vision, and Chiropractic/Acupuncture benefits, as well as, additional supplemental insurance offered.
  • Flexible Spending Account
  • Life Insurance (paid by JGM)
  • 401K matching
  • Education Assistance


JGM is a Drug-free Workplace and an Equal Opportunity Employer