Information Systems Specialist II – Business Intelligence
4/29/2020 10:33:14 PM 800
Salary$50.94 - $62.99 Hourly $4,075.20 - $5,039.20 Biweekly $8,829.60 - $10,918.27 Monthly $105,955.20 - $131,019.20 Annually
$105,955.20 - $131,019.20 Annually
Location Housing Authority of the City of Los Angeles (HACLA), 2600 Wilshire Blvd., Los Angeles, CA
Los Angeles, CA
Job Type
At-Will Exempt
Department
Information Technology
Job Number
20-24
Closing date and time
Continuous
Please go to http://www.hacla.org/careers for details of this position and to apply.
DEFINITION: Under administrative direction, the Business Intelligence (BI)/Application Developer is responsible for the BI configuration, management, analysis, design, development, implementation, maintenance, and support of reporting and analytics applications and business applications.
CHARACTERISTICS OF THE CLASS: The incumbent in this position will be responsible for the following areas: BI Solution Development and Testing, which includes assisting customers with the analysis, design, development, and testing of business intelligence query and reporting applications; Data Design and Extraction, which includes design, develop, and deployment of query parameters, layout, filters, and analytics for customer business solutions; BI Solution Deployment, which consist of design, development, and deployment of new and/or revised reports; Data Quality Assurance, ensuring data collection is within required quality standards and maintaining the quality of Metadata Repository; and Strategic Alignment, working with clients to understand and identify the need for new products and services.
CHARACTERISTICS OF THE CLASS: The incumbent in this position will be responsible for the following areas: BI Solution Development and Testing, which includes assisting customers with the analysis, design, development, and testing of business intelligence query and reporting applications; Data Design and Extraction, which includes design, develop, and deployment of query parameters, layout, filters, and analytics for customer business solutions; BI Solution Deployment, which consist of design, development, and deployment of new and/or revised reports; Data Quality Assurance, ensuring data collection is within required quality standards and maintaining the quality of Metadata Repository; and Strategic Alignment, working with clients to understand and identify the need for new products and services.
- Participation and development in assembling reports and meeting dashboard requirements from multiple data sources
- Create, enhance and maintain business model metadata to support business requirements; design, code, test, debug, maintain, implement and document applications and systems as assigned.
- Serve as Subject Matter Expert on Operational Data Stores, Data Warehouse, and Data Marts development; guide the development design activities with input and data
- dependencies.
- Perform in-depth development by writing complex ETL/ELT jobs, PL/SQL queries, APIs on various source systems, data marts and data warehouse support of the requirements for various strategic and/or tactical projects
- Perform data analysis related to process performance and data integrity issues; makes recommendations for improvements
- Utilize statistics and data modeling to develop insights and dashboards
- Develop tools to measure and track processes and system performance KPIs.
- Provide support in quantitative and qualitative analytics from requirements, test design to analysis as well as supporting various business groups with reports, dashboards and executive presentations that drive various business Key Performance Indicators
- Performs other related duties as required.
- Minimum qualifications & Requirements
- KNOWLEDGE, SKILLS, ABILITIES AND EXPERTISE:
Knowledge- Knowledge of management information systems, design, and programming principles; and data processing and reporting concepts.
- Knowledge of Software Development Life Cycle (SDLC) and Information Technology Infrastructure Library (ITIL) concepts.
- Knowledge of release, change, configuration, and incident management.
- Knowledge of relational and other data modeling techniques.
- Knowledge of standard industry reporting technologies as well as reporting data elements such as data definitions.
- Knowledge of industry standard ERP technologies such as ORACLE EBS.Skills
- Skill in identifying and solving system and application problems, and underwriting work status reports.
- Skill in coordinating work projects, providing technical assistance, working with persons of varying technical abilities in a team environment, and training others on reporting standards.
- Skill in preparing data structures, flowcharts, logic flow diagrams, documenting system design, programming, and reporting procedures.
- Skill in determining the reporting tools best suited for a given project, analyzing user data processing needs and develop/enhance appropriate reporting systems; and applying migration procedures.
Abilities- Ability to create universe, design data model, build data loaders and ETLs.
- Ability to pick up specific and industry standard reporting tool sets.
- Ability to build computing systems from a variety of components to provide a business solution, including the ability to integrate application components and databases across computing platforms
- Ability to explain complex technical information in business terms.
- Ability to establish and maintain effective working relationships with various levels of agency personnel, clienteles, and the public
- Ability to participate in functional unit testing, integration testing, stress testing, systems testing, and user acceptance testing.
Expertise- Expertise in industry standard database systems such as MS, SQL, and Oracle.
- Expertise and proficiency in Microsoft Excel, Pivot Tables, Analysis techniques and VBA.
- Expertise in multiple industry standard reporting tools such as Crystal and Business Objects.MINIMUM REQUIREMENTS:A combination of education, training, and experience which demonstrates the ability to perform the duties of the position which includes:
Education: Bachelor's or Master's degree from an accredited college or University with major coursework related to Management Information Systems, Information Technology, Computer Science or a closely related field.
Training and Experience: Three of more year's progressive experience in Business Intelligence and application development.
DESIRED QUALIFICATIONS:
Experience in the following is desired: Developing and implementing enterprise-scale reports and dashboards using BI suite of tools; Business Intelligence configuration, administration, and environment troubleshooting; developing and publishing packages/multidimensional models from multiple data sources; programming and knowledge of the software development life cycle. Knowledge and working experience with ORACLE EBS is a plus but not required; expertise with in-depth analysis of SQL queries and query optimization is preferred.
SPECIAL REQUIREMENT: Must possess a valid Class 'C' California driver's license.- Supplemental information
EXAMINATION:
Applications will be reviewed for relevant experience, education, and training. Applications must be detailed and complete for proper evaluation. Resumes may be included but may not be submitted in lieu of application content. Only the MOST QUALIFIED APPLICANTS will be invited to the interview process. Applicants must passeach phase of the interview process with a rating of 80% or higher to continue in the selection process. Only the most qualified applicants will be referred for interview and considered for the position; however, only the best-qualified applicant(s) may be selected.SELECTION PROCEDURE:
Applications will be reviewed for relevant experience, education and training. The application must be detailed and complete for proper evaluation prior to examination.
HIRING INFORMATION:
All job offers are contingent upon successful completion of a pre-employment evaluation, which includes: a post-offer medical examination (includes drug and alcohol screening), criminal records check, employment history and education verification, and documentation of the right to work in the United States.
Candidates will start at STEP 1 of an eight step salary range unless there are special exceptions in accordance with the Personnel Rules.
DISABILITY ACCOMMODATION:
If you require special testing accommodations due to a physical, mental or learning disability, please call (213) 252-5400 for special assistance. Special testing accommodations may be arranged if verification of the disability is provided by a physician, rehabilitation counselor, or other authority.
We are an Equal Opportunity/Affirmative Action Employer.
Candidates who require a reasonable accommodation in any portion of the selection process should state their need in writing when submitting an application.- Agency
- Housing Authority of the City of Los Angeles
- Phone
- 213/252-5400
- Website
- http://www.hacla.org
- Address
- 2600 Wilshire Blvd., 3rd Floor
Los Angeles, California, 90057
图片翻摄自网路，版权归原作者所有。如有侵权请联系我们，我们将及时处理。