7 days old
2018-07-092018-08-06
  • Job Code
    628168
job summary:

Job Description

Our client has a mission to bring compelling content to customers anytime and anywhere; data has and will continue to play an incredibly important role in our mission. The Architecture & Design team is responsible for architecting cutting-edge products and solutions to support the mission.

Their clients, internal and external, need clear, consistent, and capable technologies to report, visualize, and understand data; that is why we are looking for a first-class Data Modeler. This is a great opportunity for a talented and creative person who is passionate about data to join a great company competing in the next generation of media, entertainment, and technology.

Responsibilities

- Responsible for defining the vision, strategy, and principles for the entire Sales data pipeline from ingestion to presentation.

- Perform data profiling and modeling across multiple Sales related data sources and various platforms (traditional relational and evolving denormalized environments)

- Own an end-to-end design process from conception to implementation and maintenance

- Lead the design process of logical schemas and structures and translation to physical objects and processes

- Create Data Dictionaries for the engineering and business users

- Responsible for defining and maintaining the naming conventions and standards

- Responsible for guiding Data Migration plans and implementation

- Responsible for leading the efforts for data validation and clean-up

- Create and develop data mining, discovery, and analytics capabilities with custom and third-party software solutions

- Participate in data analysis, mapping, dimensional modeling, and troubleshooting if necessary in order to maintain high quality, well structured, and robust data

- Lead the design, implementation, and maintenance of MDM efforts;

- Lead data analysis investigations focused on data quality, availability, or reliability

- Lead model walk-thoughts with the engineering team and business clients

- Perform exploratory and quantitative analytics when required

- Actively participate in the team's software development lifecycle (agile-based)

- Assist with transitioning projects into production and troubleshooting of problems

- Keep your eyes open for new technologies, ways of doing things, risks, and opportunities so the team can stay at the leading edge of the possible

If you are wondering whether you are a fit for this role, ask yourself these questions. If you answer yes, we hope to hear from you soon.

- Do you like to leverage your technical skills to tell stories with data and make it meaningful to many different groups of people?

- Are you highly collaborative and enjoy working on teams that solve challenging problems by working together?

- Is the thought of competing with toe-to-toe with cutting-edge media and technology companies through the use of data and information exciting?

Basic Qualifications

To meet the challenges of our mission, you will need the following basic qualifications for this role.

Technical

- 10+ years of mixed experience in relational and denormalized data modeling and architecture in the business intelligence or data warehousing domains. Experience with Sales systems is required.

- Expert knowledge of SalesForce Data Schemas/Objects, SalesCloud, and other SF related products such as Wave and Einstein.

- Expert knowledge working with Sales Systems and concepts such as Accounts, and Opportunities in SalesCloud.

- Expert level experience with data modeling tools such as Erwin or ER Studio to deliver logical and physical data models

- Expert knowledge of standard ANSI SQL (heavy usage of analytic funcions)

- Intermediate knowledge of No-SQL systems such as HBase, MongoDB, or Cassandra

- Intermediate level experience with the Hadoop stack components (MR, Hive, Pig, Spark, etc.)

- Exposure to cloud technologies such as AWS (preferred), or Google Cloud

- Hands-on involvement analyzing and modeling complex data sets

- Experience working with structured and unstructured datasets and ability to integrate both to a congruent system

- Knowledge of Extract Transform and Load (ETL) and Extract Load and Transform (ELT) development process

- Proven SQL tuning experience and understanding of database optimizer plans

- Proficiency in at least one scripting language, Python preferred

- Strong Linux/Unix shell scripting hands-in experience

- Expertise in distributed systems, scalability, availability, and/or application development frameworks

- Experience designing REST API services on open source technologies

- Experience using scripting languages, such as Python, Ruby, or Perl, to manipulate data, develop tools and automate process in UNIX environments

- Familiar with challenges of large data sets and systems

- Practice working in an agile software development lifecycle environment

Non-Technical

- See the big picture between several requirements to engineer solutions which are elegant, robust, and effective in many different use cases

- Brings intellectual curiosity and creativeness to work everyday

- Top-notch analytical skills

- Interested in applying new solutions or products, technical and non-technical, to existing problems

- Passionate about using data to solve pressing and/or difficult questions

- Excellent communication abilities with the ability to communicate clearly and effectively based on the audience

- Ability to translate business requirements into practical, efficient, and sustainable technical solutions

- Demonstrated ability to deliver on commitments to themselves, the team, and their customers

- Desire to work in a highly collaborative environment

- Comfortable pushing for more information or detail when prudent

Preferred Qualifications

If you do not have these skills don't worry because they are not required. If you do have any of these skills, make sure to let us know.

- Experience using data visualization tools such as Tableau

- Familiarity with data analytics tools, such as R, SAS, and SPSS

- Personal or professional experience with open source software

- Experience in entertainment space.

BS or MS in CS, Mgmt Info Systems, Stats, or related

 
location: Burbank, California
job type: Contract

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Modeler

Randstad Technologies
Burbank, CA 91505

Share this job

Data Modeler

Randstad Technologies
Burbank, CA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast