Simi Valley, CA-HO Commercial-Lead BI SQL Developer

Job ID: 7456Location: Simi Valley, CADepartment: 460Relocation Provided: YesEducation Required: Bachelors DegreeExperience Required: 5 - 7 YearsPosition Description: Designs and develops computer programs and monitors the work of junior staff to ensure accuracy and efficiency; performs evaluation of packaged software; conducts system studies to analyze and evaluate manual and computerized processes to improve efficiency, develops techniques for automating processes as appropriate; conducts Rough Order of Magnitude for development of new applications and reviews work of others; determines the need for system security, backup/recovery, data conversion, plans and controls development, testing, and implementation of systems and manages technical activities; works with business and responds to Production Support issues as necessary.Position Requirements:Key Tasks for Position Level I: Codes instructions for computer programs/objects/components; configures packaged software; tests and implements all changes to ensure they meet specifications. Documents and implements programs according to installation standards and conventions. Quality checks program code, related objects and documentation. Responds to Production Support issues. Works with business as required.Key Tasks for Position Level-II, in Addition to the Above: Analyzes programs to ensure that they efficiently use computer and storage resources; recommends appropriate changes as necessary. Conducts preliminary estimates / Rough Order of Magnitude for the level of effort of new/change to application functionality. Analyzes and makes recommendations for the need for system backup, security, restart/recovery, balancing & controls; recommends approaches for meeting such needs. Analyzes and documents the requirements and approaches to data conversion and data modeling.Key Tasks for Position Level-III, in Addition to the Above: Conducts system studies, analyzes existing computerized and manual processes to improve efficiency; researches and develops techniques for automatation, as approved. Monitors the work of junior staff to ensure efficiency, and compliance with specification. Designs and develops documentation of proposed procedures and systems. Performs preliminary evaluation of packaged software. Manages and controls system development projects. Supports implementation/training activities; troubleshoots system environmental issues, as required.Key Tasks for Position Level-IV, in Addition to the Above: Plans and controls development, testing, and implementation of systems; manages technical activities. Completes review of estimates / Rough Order of Magnitude for the level of effort/cost of new application functionality. Performs final evaluation of packaged software. Additional tasks not reflected in the position profiles can be integrated in the performance management.Position Attributes:Key Responsibilities:• Translate user requirements into data flows, data mapping etc • Design, develop, and/or test complex SQL processes and architecture• Design, develop, and/or test complex technical architecture components (e.g. scheduling, backup / recovery, etc)• Design, develop, and/or test complex data architecture components (e.g. database, metadata, etc)• Develop and design technical specs, test plans, and other documentation for the above components• Driving portions of business discussions to define user requirements, technical requirements, etc• Becoming familiar with common, relevant architecture frameworks and being able to use them in diagnosing and assessing architectures as well as enhancing portions of those frameworks• Drive portions of the high level design of a robust technology solution, taking into account the user requirements, technical requirements, etc.• Participating in troubleshooting and debugging complex technology integration problems• Conduct data profiling activities to assess data quality• Team lead or project management of developers, onshore/offshore, and analysts as requiredSkills & Abilities: Technical Skills:- DBMS (DB2 / UDB, MS SQL Server)- Data Management, including capabilities such as data quality, data cleansing, metadata, master data management, data modeling, etc- Hands-on experience with SQL- UNIX ScriptingPreferred Skills:• Minimum 5 years Data warehousing/BI experience • Software development and testing experience• Hands on experience with multiple phases of project life cycle development.