This site uses cookies. To find out more, see our Cookies Policy

Data Engineer in Burbank, CA at ConsultNet

Date Posted: 3/21/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Burbank, CA
  • Job Type:
  • Experience:
    At least 5 year(s)
  • Date Posted:
    3/21/2019
  • Job ID:
    19-00371

Job Description




Data Engineer
Los Angeles
We are looking for a Data Engineer working closely with the Analytics Team, you will engage with business teams to understand requirements, design conceptual, logical and physical data models, and perform root-cause analysis and recommend solutions. This will be a hands-on role utilizing Extract, Transfer & Load – ETL tools to deliver source to target mappings, physical and logical data models and related scripts to automate the data transformation and loading processes
Essential Job Functions:
Work closely with data experts to build and maintain KPI data dictionary, metadata, data standards, and ensure adherence to the Plans Analytics Method and data standards.
Engage business teams to understand requirements, document them and deliver robust and scalable solutions in the form of data models that can be leveraged for self-service analytics.
Build a data confidence model by establish and maintaining provenance, integrity and security of data used for self-service reporting, ad-hoc analysis or other levels of analysis.
Explore ways of modeling the Plans unstrcutured voice and text data into frameworks fit for analysis.
Design conceptual, logical and physical data models, maintain data dictionary and capture metadata.
Perform gap analysis as needed for purposes of maintaining, continuously enhancing data models and integrating KPI's into the analytics platform as and when new KPI and business metrics are adapted by the organization.
Work with application developement team to deploy analytics data products through such ways as embeding analysis models into business applications and mobile solutions.
Utilize ETL tools and other data pipeline automation techniques to develop and maintain source to target mapping that includes extract requirements, derived field logic, domain values and data lineage.
Ensure developed data models are easy to use and efficient to access data thus enable transaparency of data lineage to business teams and all stakeholders
Knowledge, Skills, & Abilities:
Proficient in leading business and internal team discussions to gather requirements, brain-storm and propose robust and scalable solutions; leverage business partner/unit input to enhance data models.
Expert knowledge of relational DBMS, specifically Oracle.
Expert knowledge in areas of advanced data techniques including unstructured and spatial data.

Competencies:
Customer focus - Gains insight into customer needs; identifies opportunities that benefit the customer; builds and delivers solutions that meet customer expectations; establishes and maintains effective customer relationships.
Decision quality – Makes sound decisions, even in the absence of complete information; relies on a mixture of analysis, wisdom, experience, and judgment when making decisions; considers all relevant factors and uses appropriate decision-making criteria and principles; recognizes when a quick 80% solution will suffice.
Communicates effectively – Is effective in a variety of communication settings: one-on-one, small and large groups, or among diverse styles and position levels; attentively listens to others; adjusts to fit the audience and the message; provides timely and helpful information to others across the organization; encourages the open expression of diverse ideas and opinions.
Ensures accountability – follows through on commitments and makes sure others do the same; acts with a clear sense of ownership; takes personal responsibility for decisions, actions, and failures; establishes clear responsibilities and processes for monitoring work and measuring results; designs feedback loops into work.
Instills trust – follows through on commitments; is seen as direct and truthful; keeps confidences; practices what he/she preaches; shows consistency between words and actions.
Manages Ambiguity- Operating effectively, even when things are not certain or the way forward is not clear.
Minimum Qualifications:
Bachelor's Degree in Computer Science, Information Systems, or other related field as well as equivalent work experience.
Minimum 5 years of data engineering, data modeling or data architecture experience with a focus on multidimensional data modeling for both structured and unstructured data.
Experience designing conceptual, logical and physical data models and maintaining data dictionary and capturing metadata.
Experience creating and maintaining automated data pipelines, data standards, and best practices to maintain integrity and security of the data; ensure adherence to developed standards.
Experience in developing and maintaining source to target mapping that includes extract requirements, derived field logic, domain values and data lineage.
Experience in relevant technical languages and tools such as SQL, Python, NoSQL, Airflow, Quartz, ERWIN or equivalent.

Preferred Goal Completion: Inspired to perform well by the completion of tasks Self-Starter: Inspired to perform without outside help Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization
Education
Required
Bachelors or better in Computer Science or related field.

Experience
Required
Relevant technical languages and tools such as SQL, Python, NoSQL, Airflow, Quartz, ERWIN or equivalent. Preferred qualifications
Developing and maintaining source to target mapping that includes extract requirements, derived field logic, domain values and data lineage.
Creating and maintaining automated data pipelines, data standards, and best practices to maintain integrity and security of the data; ensure adherence to developed standards.
Designing conceptual, logical and physical data models and maintaining data dictionary and capturing metadata.
5 years: Data engineering, data modeling or data architecture experience with a focus on multidimensional data modeling for both structured and unstructured data.
Preferred
Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at www.consultnet.com.