Data Engineer

Benefits Offered
Work/life balance
100% health vision and dental coverage
Life insurance
401(k) with matching
Paternity/maternity leave
Continuous education
Casual dress code
Company outings
Unlimited PTO
Flexible hours
PAC-MAN arcade game
Pet friendly
Green office

Data Engineer

Zennify is looking for a qualified candidate to join their team as a Data Engineer! The Data Engineer will work directly with our customers to not only enable them to be successful but to also help guide them through high-quality data-driven practices and project scope. You will work with them and our delivery teams to develop, optimize and oversee our client’s conceptual and logical data systems.

The Data Engineer is responsible for, but not limited to the following: data modeling, data migration and data integration, ETL tooling, data best practices, data movement, building and optimizing “big data” data pipelines and architectures, and the building of end to end data solutions for our customers. Your duties may include preparing architect reports, monitoring the system, supervising system migrations, and performing root cause analysis on external and internal processes and data to identify opportunities for improvement.

These technologies include but are not limited to: products and APIs, the Salesforce data model, Amazon Web Services (AWS), Heroku, integration/ETL technologies. You will also maintain an ongoing comprehensive understanding of data migration/integration tools, patterns and best practices.

To succeed in this role, you should know how to examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.

Interested in this Position?

Primary Responsibilities

  • Work closely with Delivery Managers, Functional Solution Architects, Technical Architects and clients in order support the technology solution architecture through applying data architecture principles
  • Examine and identify database structural necessities by evaluating client operations, applications, and programming
  • Conduct data requirements working sessions focused on data object mapping, data transformation and planning directly with the functional architect, technical architect, and client stakeholders
  • Collaborate with functional and technical architect(s) to help finalize the Salesforce data model necessary for successful project delivery
  • Serve as a trusted advisor to the client and recommend solutions to improve new and existing database systems
  • Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.
  • Design and implement data migration and integration solutions and data models to store and retrieve data
  • Support the successful delivery of the proposed technical solution, including data migration/integration scripts used in one time migrations, performing migrations, ongoing integrations, etc.
  • Oversee the migration of data from legacy systems to new solutions
  • Assess database implementation procedures to ensure they comply with internal and external regulations
  • Prepare accurate database design and architectural design documentation
  • Monitor the system performance by performing regular tests, troubleshooting and integrating new features
  • Perform and/or lead necessary unit testing on all developed data scripts
  • Work directly with QA team to review UAT test cases in an effort to ensure accurate data is migrated and available for testing
  • Perform and/or lead project data consultants in dry run data load testing
  • Development and refinement of production deployment documentation related to data migrations and integrations
  • Lead and mentor the data team on the project
  • Enforce sound data migration and integration best practices in order to ensure the quality of deliverables and scalability
  • Identify and lead internal strategic initiatives to grow the Data Integration services offering; play an active role developing the knowledgebase and expertise of the Data team
  • Own and drive data architecture solutions, technology and web flows
  • Educate staff members through training and individual support
  • Mentor other ETL/Data team members and maintain best practices are followed within the team
  • Offer support by responding to system problems in a timely manner

Technical Requirements

  • Hands-on experience with data architecture tools, such as Talend, Jitterbit, Capstorm, Informatica; or others such as Hyperion, Erwin, SQL Server; etc. are helpful
  • Understanding translation between logical data structures & physical database objects
  • Experience with migrating data into Salesforce and understanding the Salesforce data model
  • Experience establishing data pipelines for large data sets.
  • Significant Java development experience
  • Significant experience with SOAP & REST API Integration, data, and security
  • Significant experience with writing unit tests
  • Significant experience with Git and standard branching strategies
  • Experience using JIRA or similar software to manage user stories and workload
  • Has experience with and is currently willing to be hands on contributing developer in addition to leadership responsibilities

Preferred Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or relevant field strongly preferred
  • 8+ years experience in developing technology solutions
  • 5+ years experience in managing external client projects from a data solution perspective
  • A data engineer certification, e.g. Google’s Certified Professional Data Engineer, IBM Certified Data Engineer, CCP Data Engineer for Cloudera, MCSE/MCSE: Data Management and Analytics, is a plus.
  • Ability to reverse engineer existing data models into a conceptual, logical data model constructs
  • Strong conceptual and logical data modeling skills
  • Possesses strong knowledge of data modeling principles and best practices
  • Expected to be able use various data modeling tools and processes as required
  • Open-minded to collaborate with various team members and able to give and handle constructive feedback
  • Specializes in gathering and analyzing information and designing comprehensive solutions that are flexible and adaptable to the client's needs
  • Ability to develop extensible and flexible data models based on long term strategy, and articulate benefit of reuse
  • Able to design integrated data model based on understanding of business, and use of abstract concepts
  • Experience overseeing team members
  • Highly detail-oriented individual with the ability to rapidly learn and take advantage of new concepts, business models, and technologies
  • Ability to work independently and be a self-starter
  • Cutting edge innovator who continually studies new technologies and functionality, and is involved in projects that push the capabilities of existing technologies

Leadership Skills:

  • Passionate about Customer Success
  • Always learning; approaches each interaction with open mind; great listener and hands-on
  • Self-aware and strategic thinker; proficient at building strong relationships
  • Speaks and writes with clarity, brevity, and purpose; explains area of expertise clearly and confidently to others; influences and engages C-Level with authority and confidence
  • Confidently and effectively facilitates and presents; ably defends point-of-view; keeps audiences engaged and delivers a clear and memorable message
  • Proficient at collaboration and working with members of a team
  • Ability to move fast and drive business value and results
  • Embodies Zennify culture; a team player that everyone enjoys working with
  • Lives the company’s core values; shows integrity, transparency, and reliability
  • Leads internal initiatives; actively contributes to the Community’s knowledge and resource base

Qualities of the Ideal Candidate

  • Thrives in a team-based, high energy and fast-paced environment
  • Service-oriented and innately driven to produce outstanding customer satisfaction and results
  • Enjoys discovering, learning about and implementing new technologies
  • Analytical and able to logically and methodically work through problems
  • Strong aptitude for prioritization and multitasking in a deadline-driven environment
  • Possess a sense of urgency with strong organizational and follow-up skills
  • Ability to meet travel requirements, when applicable (up to 25% travel projected)