Data Engineer (Sr.) – Los Angeles, CA (by LAX) or Tulsa, Oklahoma Direct Hire/ Full Time Employee

TITLE: Senior Data Engineer

LOCATION:  Tulsa, Oklahoma or Los Angeles, CA

HIERARCHY: Reports to Director BI/Data that DKKD Staffed

SIZE OF STAFF: none

SALARY: to be discussed

NOT open to Corp to Corp

Those authorized to work in the US are encouraged to apply.

DKKD Staffing does not sponsor and cannot support H1, EAD, TN, etc. No outside agencies, please.

Job Description

What are we looking for?

• Data Engineers with skill and experience connecting to diverse data sources and transforming data to prepare it for multiple businesses uses. Essential skills and technologies are:
  • T-SQL programming
  • IICS
  • DOMO
  • SQL Server and PostgreSQL a plus
  • Looking for seasoned professionals

What will they be working on?

• We have a wealth of data in our existing DW and modeled in DOMO for business use, but we are always working to enhance performance as well as deliver new capabilities for our business users who constantly need new metrics and access to additional data sources.
• We will be creating certified datasets, dashboards, and cards in DOMO to support business users and self-service BI and Analytics
• We will be improving the performance and functionality of existing data management practices.

Primary Purpose of job:

• • This position is responsible for programming, testing, implementing, supporting, and maintaining data pipelines, data platforms, and business intelligence models. This position relies on instructions and pre-established guidelines to perform the functions of the job.

The duties and responsibilities for this position:

Development – 50%

• Write, modify, extend and debug data pipelines. Specific duties will include:
  • Data Extraction and Analysis: Connect to diverse data sources and perform data analysis to determine if data is suitable for needs.
  • Development of automated data pipelines to extract, cleanse, and transform data for intended business use.
  • Development of automated processes to consolidate diverse sources of similar data into a single source of truth (e.g., reservations, rentals, NPS, etc.).
  • Development of automated data quality monitoring and alert processes
  • Model and publish data sets for users to access through reporting and business intelligence technologies.
• Possesses and apply working knowledge of multiple languages and tools utilized r during development process. Common tools and languages: ETL, T-SQL, Data Profiling and MDM tools, BI Modeling Tools (DOMO), and Programming Languages
• Adhere to standards and best practices.
• Have extensive knowledge of development tools and environments utilized
• May act as a Product Technical Owner of a software product on occasion:
• Accountable for the technological performance of the product:
  • Software
  • Hardware
  • Virtual Ware
• Tech Teams – Development, Data, Infrastructure, Contractors, and Professional Services
• Responsible for adherence to strategic plan while remaining focused on the teams handling the product.
• Responsible for the technical requirements.
• Responsible for Technical User Story acceptance.
• Manages the technical debt of the product.
• Manages conflicts of interest within the development team.
• Coordinates coding efforts across one or more development teams.
• Holds Development, Technical, Professional Services, Data, and other IT teams accountable within the framework of the product.
• Accepts input and guidance from our Architecture, Infrastructure, and Development teams and acts as the one voice back to Professional Services on technology-related items when decisions need to be made.
• Leads troubleshooting efforts by getting the right expertise involved and calling “war rooms” together when necessary.
• Acts as Scrum Master when the development team and PTO agree this is appropriate.
• Data Platform / Database Engineering
  • Install and set up new data platforms and databases (e.g. SQL Server, AWS, etc.) in accordance with requirements for data security, storage, file management, CPU, memory, availability, recovery, monitoring, backup, and retention.
• Document Operations needs of the data platform: e.g., Outage windows, Tier, Business owner(s), User Groups, and Peak Usage Times.

Technical Support – 35%

• Resolve technical issues utilizing excellent customer service skills, problem-solving skills, and technical thinking/reasoning skills following established support process and metrics guidelines.
• Measure and analyze incoming issues to determine root cause and develop technical and training solutions to minimize reoccurrences and severity; report results to management.
• Accurately document all customer issues, resolution steps, and gather feedback in support tracking software to enhance identifying and reporting trends leading to recurring technical problems.
• Develop and publish support documentation for internal users for troubleshooting, training, and other areas as needed.
• Gather and forward customer feedback and suggestions for product improvement.
• Position requires 24×7 support.

Training – 10%

• Seek input from team members and supervisors on areas to improve skillset.
• Actively applies feedback received into day-to-day work and strives to improve performance
• Actively train with senior-level developers to improve development skills and system knowledge.
• Actively utilize training outlets as necessary to improve development skills. This could take the form of multiple items, including but not limited to self-study, in-house classes, seminars, or online training.
• Maintain professional and technical knowledge by attending ongoing training workshops, reviewing professional publications, reviewing industry best practices/procedures, and reviewing new technologies to determine fit within the organization.
• Assist in the development of junior data engineers on skills or system knowledge through mentoring, knowledge transfer, code review, and shadowing.

Administration and Communication – 5 %

• Listen to others and accept input from team members.
• Articulate ideas and thoughts both in verbal and written formats.
• Accurately prepares written business correspondence that is coherent, grammatically correct, effective, and professional.
• Timely communicate status updates with the project manager or lead, the project team, and/or key customers and supervisor regarding specific assignments and overall scheduling/coordination needs.
• Accurately record project and trouble call work assignment updates within timeframes determined by departmental standards or individual supervisors.

Action Required: Please complete the Application & Job-related questions below. For fastest response, please answers to Di@DKKDstaffing.com

APPLICATION QUESTIONS (Please answer all questions)

• Name:
• Best Contact Info:
• Your Linked In:
• Where do you live and your desired geographical location:
• Why looking for a new job:
• Availability for interviews and a new job:
• Are you open to relocation if required:
• Do you have an active Passport:
• Are you open to travel if needed:
• Are you authorized to work in US (Please indicate US, Green Card, Other):  Do you require sponsorship at any time or will you in the future?
• Salary Expectations: (I need a range) $
• Sizes of staff overseen and their titles: (include # of direct reports)
• Budgetary Responsibility: $
• Education/Certs/Degrees: (also indicate which certs are active)
• Who Referred You/ How Did You Hear About Job/ DKKD Staffing:

JOB-RELATED SCREENING QUESTIONS/ JOB REQUIREMENTS:

NOTE: Please provide your # of years of experience (per bullet/colon) and last year used. Elaborate if needed. If no experience, please indicate NA or none. 

• Having worked as a DBA:
• Experience in Transportation and/or Finance industries
• Vendor management experience
• Experience in data modeling and business intelligence solutions:
• Architecting business intelligence, ETL, application, and database solutions:
• Hands-on SQL development and data modeling:
• Experience in Database Management, setting up databases, standby, reporting database:
• Skills and experience with relevant software solutions such as MS Access, OLAP, SQL Server, Postgres, IICS, DOMO, XML, JSON, Mongo, SSRS, SSIS, Oracle, and MS Excel – and/or related technologies:
• Database Replication, Standby database management, and highly available database architecture with 99.99% availability:
• Tuning of database queries, views, SQL optimization, and maintenance of overall database health:
• Project management:
• Ability to take rudimentary requirements or concepts, and research/collaborate to generate actionable requirements, then deliver on the requirements:
• Ability to quickly learn and use new software tools:
• Keen attention to detail and ability to document information accurately:
• Ability to develop and present training materials to varied audiences:
• Troubleshooting skills, especially tracing and solving data issues:

Connect with us on Linked In: www.LinkedIn.com/in/DianeKrehbiel 

ALL DKKD JOBS: www.DKKDstaffing.com

We get 100’s of applicants applying to us. Please see the instructions above on how to apply to help us.

IND123