Sign in

Data Modeler/ Architect - RT

Company:
Absolute Opportunities
Location:
San Francisco, California, United States
Posted:
March 16, 2019

Description:

Data Modeler/ Architect - RT

San Francisco, CA 94199

The Data Modeler/ Architect in our organization designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively

Serves as a primary contributor in the department's vision and implementation of the Business Intelligence program.

Partners with Data Engineers, DBAs, Data Operations and customers to guide development for enterprise Data Warehouse/Hadoop solutions.

Maintains and supports a culture of compliance, ethics and integrity.

Responsible for ensuring ongoing compliance with development practices in the data & analytics program.

Maintains knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to data and analytics

You Will:

Leads business information modeling for large, complex projects and ensures that project information conforms to corporate information architecture standards.

Collaborates with business partners, data engineers, DBAs and analytics staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects.

Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions. Identifies researches and recommends new methods for supporting information management as it relates to data management.

Develops high-level database architectures and ensures that database designs are consistent with information architecture and information management standards as well as industry standards.

Works with data engineers to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas. Performs other duties as assigned.

You Bring:

Understanding of Oracle, Hive Tables, Hadoop partitioning

Data integration tools (Informatica, etc.), and metadata repository processes and tools.

Proven track record coordinating with project managers, participating in project planning and coordinating with development teams using agile methodologies delivering successful business intelligence solutions with complex data sources.

Strong oral, written and interpersonal skills for interacting and collaborating with analysts, data engineers, and business staff throughout all levels of the organization;

Ability to clearly communicate complex business problems and technical solutions.

Designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively and efficiently manage business operations.

You Have:

Bachelor's degree in computer information systems, computer science, business or related field.

Eight (8) years of information technology experience including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence.

Extensive experience integrating disparate systems into conformed dimensions.

Strong hands-on ER-Studio data modeling tool experience.

Experience with a range of relational database management systems (RDBMS) (Oracle, SQL, MySQL, etc.) and RDBMS tuning.

Experience with Big-data (Hadoop) a Plus

Experience deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle).

Benefits

Full

Bachelor's degree in computer information systems, computer science, business or related field

Eight (8) years of information technology experience including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence

Strong hands-on ER-Studio data modeling tool experience

Extensive experience integrating disparate systems into conformed dimensions.

Relocation Assistance Available

Required Knowledge, Skills, and Abilities: (Submission Summary)

1. Enterprise Data Warehouse experience

2. 4+ yrs designing, deploying and maintaining Conceptual, Physical and Logical models.

3. ER Studio Experience

4. Oracle is our preferred RDBMSv + tuning expertise

5. Hadoop experience

6. Salary Expectation?

7. Authorized to work in the US without sponsorship

8. Complete Current Address?