We have an exciting career opportunity as a Business Intelligence Architect supporting a large public educational facility construction program. This role will oversee all business intelligence development activities for the Los Angeles Community College District (LACCD) and will be based in Monterey Park, CA.

At Cumming Group, you will work on some of the world's most exciting projects in a dynamic environment where your success is measured by the impact you make. We are one of the fastest-growing project and cost management consultancies in the United States, as reflected in our top 20 ranking in ENR. With over 50 offices globally, an extremely diverse project portfolio, and double-digit year-over-year revenue growth, the opportunities to make your mark are limitless!

• The Business Intelligence (BI) Architect is responsible for overseeing all business intelligence development activities for assigned projects. In addition, the candidate will drive all architectural strategies for BI efforts and ensure these strategies are being applied to solutions built.
• The BI Architect may be required to act as Technical Lead on BI-centric projects. Additionally, it will be necessary for this position to participate in development as well as architecture and design.
• The successful candidate is expected to have deep knowledge of the Microsoft BI stack (SSIS, SQL Server, SSAS, SSRS, PerformancePoint, Excel Services, and SharePoint) and may work with one or a range of these tools depending on project deliverables and team resourcing.
• The BI Architect must also have expert level skills in Data Warehousing and BI architecture such as the ETL process, dimensional modeling, OLAP, and Dashboards.
• Responsibilities range from architecting, designing and planning business intelligence solutions, configuring BI services, aggregating data from multiple sources into a data warehouse, creating and deploying reports, enhancements and providing solutions.
• Translates business requirements into a full end-to-end Business Intelligence Solution.
• Architects all BI solutions for assigned projects.
• Creates (ensures creation of) all solution documentation.
• Achieves and maintains relevant technical competencies and helps to foster an environment of continued growth and learning among colleagues on existing and emerging technologies.
• Effectively prioritizes responsibilities and communicates status of efforts to the project team.
• Other duties as assigned.

• A Bachelor's Degree in Computer Science or related field is required. A high school diploma, GED and/or equivalent combination of education and work experience may be substituted.
• A minimum of 10 years' of relevant experience with relational and multidimensional database design, implementation, strong T-SQL and knowledge of MDX.
• Proficient in Power BI.
• Experience with reporting systems and data warehouse requirements gathering, analysis and design of ETL processes using SQL Server Integration Services (SSIS).
• Expert knowledge of Data Warehousing and Business Intelligence design principles.
• Strong knowledge of BI tools, including the Microsoft BI Stack: SSIS, SSAS, and SSRS.
• Experience with delivering OLAP data to end users through Excel or other analytics products.
• SharePoint implementation experience a plus.
• Possess strong business acumen and consistently demonstrates forward thinking.
• Is able to effectively work with ambiguous or incomplete information.
• Has have a working knowledge and understanding of architectural frameworks and best practices.
• Must have a strong working knowledge of technical infrastructure, protocols and networks.
• Must have experience on multiple hardware and software environments and be comfortable in heterogeneous systems.
• Must possess a deep working knowledge of multiple platforms, operating systems, databases and mobile technology.
• Excellent organizational, communication and interpersonal skills are required.
• Must be able to routinely work with little or no supervision.
• Must be able to effectively and efficiently handle multiple and shifting priorities.
• Must remain calm while working in a high pressure environment with many short deadlines.

Have more questions? Chat with a Recruiter on our careers website! It takes five minutes to apply to this job and we will provide feedback within five business days.

#LI-NH1

Cumming provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.