$118,776 - $144,384 yearlyEast Bay Municipal Utility District Oakland, CA, USA
May 28, 2019Full time
East Bay Municipal Utility District (EBMUD) invites qualified applicants to apply for an immediate Senior Software Engineer (Data Warehouse Architect) vacancy in the Applications Development Division of EBMUD's Information Systems Department (ISD). EBMUD is seeking a motivated professional with substantial experience in: employing data warehouse principles, business intelligence (BI) best practices, relational structures, dimensional data modeling, structured query language (SQL), and effective reporting techniques to work with various business users and internal information technology staff in designing data warehouse solutions best fit to support EBMUD's business needs. Typical duties include: • Architecting, building, testing and maintaining a high performing Enterprise Data Warehouse. • Designing and developing databases and data models. • Working with internal ISD staff to implement data warehouse concepts and designs. • Evaluating new data sources, optimizing existing data sources and investigating data related issues and reporting data status to leadership. • Consulting with and advising departmental representatives about business intelligence approaches and options available to address user needs; assisting users in defining problems, analyzing business practices and workflow and recommending changes consistent with user computerized needs; advising about effectiveness of modifying or developing new applications and systems. • Implementing change management activities to support changes to the data warehousing environment. • Managing the impact of data sources and content changes on applications and integrations. • Seeking out continuous improvement, process automation and risk mitigation. • Participating and contributing in cross-functional activities within ISD as well as business users throughout EBMUD. The successful candidate will be a data specialist with a solid understanding of software engineering, able to analyze EBMUD's current Data Warehouse environment and recommend/implement best practice solutions. The ideal candidate will have: • Ability to document and express data architectures and standards that can be easily understood and applied by both IT leadership and developers. • Expert-level ability writing complex queries in SQL. • Expertise in Data Warehouse concepts and methodologies. • Strong experience in solution design, integration architecture, and process improvement. • Experience in building and implementing OLAP databases; both multidimensional and tabular. • Excellent interpersonal skills and ability to work with all levels of personnel individually and within teams. Good communication skills, both verbal and written. In addition to sharing EBMUD's values of stewardship, integrity, respect, and teamwork in their commitment to public service, the most competitive candidates will possess substantial experience in: • Business Intelligence • Data warehousing • SQL • Oracle Databases and/or other RDBMS • Implementing Enterprise software systems • Software testing and QA Practices • Requirements gathering and documentation • All aspects of the software development cycle • Waterfall, Agile or other standard development models • Capability Maturity Model • Cooperating with software developers in a team environment while learning new software technologies • Oral and written communication • ITIL • Capability Maturity Mode The position offers a stable 40 hour work week with minimal overtime (paid) or travel required. The monthly salary range for the Senior Software Engineer (Data Warehouse Architect) starts at $9,536per month, increasing to $10,013, $10,514, $11,040, and $11,592 after 6, 18, 30, and 42 months, respectively. EBMUD is an Equal Opportunity Employer. All qualified candidates will receive consideration for employment without regard to race, color, religious creed, sex, gender, gender identity, gender expression, marital or registered domestic partnership status, age for individuals over forty years of age, national origin, ancestry, disability (mental or physical, including AIDS and HIV), medical condition (cancer and genetic characteristics), genetic information, sexual orientation, military and veterans status, family or medical leave status, pregnancy, pregnancy disability leave status, or any other status protected by federal, state and/or local laws. Requirements: Any combination of education and experience that has led to the acquisition of the knowledge and abilities indicated above. Typical means of acquiring the essential knowledge and abilities is a combination of training and experience equivalent to: 1. Completion of four years of college resulting in graduation, or its equivalent; and 2. Three years of systems analysis and programming experience developing business applications for computer systems including one year at a level comparable to or higher than EBMUD class of Software Engineer II. Experience may require demonstrated use and expertise in specific programming languages or IT specialties relevant to the position vacancy. Equivalent combinations of education and experience may be considered. To be considered under the "equivalent combination of education and experience" provision, it is your responsibility to include in your application materials written evidence of employment performed at the level of the typical duties of this position and/or coursework in subject areas directly related to this position. For more information, see our FAQ page at http://www.ebmud.com/jobs/job-resources/job-faqs-frequently-asked-questions/ .