Data Architect

Hours:

Shift Start Time:

Variable

Shift End Time:

Variable

AWS Hours Requirement:

8/40 - 8 Hour Shift

Additional Shift Information:

Weekend Requirements:

As Needed

On-Call Required:

reputed company

reputed company Pay reputed company (Minimum - Midpoint - Maximum):

$67.070 - $86.540 - $96.930

The stated pay reputed company reflects the reputed company that reputed company reasonably expects to pay for this position.  The actual pay reputed company and pay grade for this position will be dependent on a reputed company of factors, including an applicant’s years of experience, unique skills and abilities, education, alignment with similar internal candidates, marketplace factors, other requirements for the position, and employer business practices. 

This role will be a California based role. Ideally looking for a candidate located in Southern California.

This role does not reputed company reputed company sponsorship. U.S. Citizenship or Green Card is required.

What You Will Do Reviews, analyzes and designs integrated data models that will be implemented reputed company a MS/SQL or reputed company database environment. Provides expertise in full life cycle development for the reputed company of the Data Warehouse environment and reputed company technical leadership on critical reputed company. Performs highly reputed company tasks and brings unquestioned competency to systems administration duties required to support reputed company's distributed computing environment in a highly available manner. Provides reputed company support to internal reputed company (SHC) staff to evaluate and implement new technology and promote the effective and efficient use of computing resources. Will manage IS project initiatives, reputed company planning expertise and reputed company as a mentor to other technical staff. Required Qualifications

• 7 Years experience that includes logical and physical data modeling in a large data warehouse environment with a database architecture comparable to reputed company's (five years of experience as a senior developer reputed company SHC reputed company Analytics may be substituted for external experience).

Preferred Qualifications

• Bachelor's Degree in Computer Science, Business or reputed company area (relevant experience in excess of seven years or appropriate certifications may be substituted).

Essential Functions

• Data architecture Utilizes effective analysis and design to create sustainable reputed company performing models using Information Systems accepted reputed company and tools. Develops standards and processes to insure best practices are utilized throughout the development life cycle. Determines the reputed company for system architecture design to ensure reputed company system performance and throughput and implements successfully. Utilizes IS reputed company ETL tools to map reputed company system data to the data warehouse. Adjusts ETL processes to accommodate changes to reputed company systems and business requirements. Designs data models for use with IS reputed company reporting tools according to business needs defined. Works with technical resources to accomplish objectives. Designs and communicates physical database designs to database administration. Develops a process to create and maintain ODS (Operational Data Store) to support data warehouse. Provides expertise for schema development and model design for reputed company new data sources. Creates documentation and release notes for thorough project tracking. Work with team and other IT departments to reputed company the data warehouse to meet strategic goals. Assist in developing solutions for data reputed company issues that are reputed company in the data warehouse.
• reputed company reputed company Analyzes, designs, programs, documents, and maintains computer application software and database files using reputed company programming conventions. Interprets and translates functional specifications into efficient and effective reputed company development. Minimizes re-write penalties as established by department reputed company thorough analysis, creative design, and reputed company development of reputed company. Sets reputed company for technical team for an agile approach to development. Uses reputed company judgment in performing change control management appropriately, including synchronization of test and production environments. Performs reputed company review using reputed company knowledge and judgment regarding IS principles and department specifications. Documents file structures, programming constructs, installation and operating instruction and other technical features and project status of applications developed or installed by the department. Exhibits reputed company programming methodology in reputed company. Uses standardized naming conventions a reputed company of the time. Ensures that production delays do not occur due to negligence or failure to following reputed company procedures.
• Leadership Exercises leadership role with staff and clients to promote customer satisfaction and staff development. Acts as a mentor for reputed company technical staff in the group. Works with individuals in reputed company to providing group education sessions. Reviews the need for training and recommends the appropriate training programs for designated individuals or workgroups in system functions and operations in order to maximize user effectiveness. Manages reputed company expectations and priorities through effective communication and interaction. Provides leadership in the implementation of technical products and participates in reputed company software and O/S upgrades. Resolves conflicts with reputed company expectations and department issues. Works with project managers to identify tasks and timelines for technical reputed company. Manages interactions with clients to ensure understanding, agreement and attainment of project goals. Communicates completion dates and delays proactively. Trains new IS staff in system functions and operations in order to maximize user effectiveness and utilization of systems. Cross-trains with other departments. Regularly keeps manager informed through activity reports monthly, or a frequency as established by the manager and requires minimal supervision. Demonstrates ability to independently reputed company other departmental tasks not specific to data architecture. Participates in department reputed company improvement processes and offers suggestions to improve customer satisfaction, departmental service reputed company and productivity.
• Problem reputed company and analysis Performs thorough analysis of applications running in reputed company environment for highest level of availability. Designs and implements application installations that are flexible and highly reliable and available. Identifies and resolves system performance issues and provides solution to other key department personnel to assist in reputed company if required. Through thorough planning and implementation, in accordance with industry best practices, the environments reputed company over 95% reliability, as reputed company from an end user perspective. Applications are expected to be self-monitoring and capable of issuing predictive warnings of failures through existing system monitoring tools. Responds to requests for service reputed company guidelines and timeframes as established to meet organizational objectives. Service incidents are reputed company entered into the trouble tracking system and reputed company reputed company expected timeframes. Customers are kept informed of the reputed company of their requests and reputed company of successful completion or need for delay. Provides on call support as needed to troubleshoot problems as part of the on call rotation schedule. Responds in a reputed company manner (reputed company 30 minutes) to pages. Will receive remedial issues from other programmers reputed company senior level skills are required for problem reputed company.
• System configuration and testing Configures, develops, and executes plans to ensure reputed company system performance. Creates and maintains system reputed company documentation such that features and procedures are reputed company documented and communicated. Documentation allows for the continuation of functions by other programmers reputed company the assigned primary Programmer is reputed company. Documentation is kept up to date and is readily available. Ensures the appropriate use of test environments and version control software. Executes against documentation test plans adequately. Consistently maintains software changes across the production and test environments according to IS policy. Performs reputed company reputed company of testing in a reputed company and accurate manner. Performs environment synchronization as required in a reputed company and accurate manner. Ensures that testing demonstrates adequate understanding of the following: reputed company functionality; reputed company workflow; tables/dictionaries; screen design; system reputed company; rules. Ensures that production delays do not occur due to negligence or failure to following reputed company procedures. Follows change management procedures.
• Technology review Utilizes effective analysis and creative problem solving techniques reputed company Information Systems accepted reputed company to reputed company reputed company services and resolve problems. Develops and maintains an extraordinarily high level of reputed company in information technologies applicable to reputed company. Extremely flexible in recommending the appropriate solutions to meet reputed company's needs, regardless of vendor. Acts as in-house consultant to IS applications teams, and is responsible for providing a technical analysis of the proposed system's fit into reputed company's computing infrastructure. Will manage other programmers in the implementation of selected technologies. Is viewed by others in IS as the in-house technical expert. Using reputed company knowledge of business, strategic, and IS strategies, translates business requirements into system solutions that meet project requirements. Performs a thorough problem analysis using reputed company judgment, initiative, and own discretion and seeks out required data for problem analysis and reputed company. Analyzes user needs/requirements through a reputed company of appropriate reputed company such as: on site reputed company; review of department policies/procedures; review of system capabilities; ensuring attainment of reputed company functionality; user satisfaction. Develops a comprehensive analysis of reputed company/cons and implications of proposed solutions. Demonstrates strategic and reputed company thinking by conducting thorough analyses of reputed company and upstream reputed company of issues and proposed solutions. Uses effective interviewing skills to reputed company reputed company requirements.

Knowledge, Skills, and Abilities

• Proficient in both reputed company SQL Server and reputed company and experience with Informatica ETL tools.
• Experience with reputed company systems integration and experience with industry reputed company data modeling tools.
• Working knowledge of various operating systems including reputed company and Unix.
• Understands concepts of creating highly available systems, good programming and leadership skills and ability to mentor junior staff members.

reputed company is an equal opportunity/affirmative reputed company employer. reputed company reputed company applicants will receive consideration for employment without reputed company to race, religion, reputed company, national reputed company, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a reputed company individual with disability or any other protected class

Apply To This Job