Data Engineer

SUMMARY: 

Principal Data Engineer will be responsible for best practices related to data architecture, ETL and documentation of data flow within AssistRx source systems and client implementations. Additionally, support existing systems/processes and develop new features and functionality, along with reviewing, presenting and implementing enhancements.

DUTIES AND RESPONSIBILITIES:

• Design ETL (extract, transform, and loading) processes within Azure, dbt, Snowflake and Salesforce for client migrations
• Build processes for data matching and clean-up prior to loading of migration data.    
• Responsible for all data flow documentation from a client implementation perspective.
• Assist with the database design, the build out and documentation of internal processes as it relates to Salesforce multi-tenant solutions to ensure it meets customer requirements for downstream data products.  
• Assess current and future data transformation needs to recommend, develop, and train new data integration tool technologies
• Discover efficiencies with shared data processes and batch schedules to help ensure no redundancy and smooth operations

• Hands-on experience in developing and implementing large-scale data warehouses, Business Intelligence and MDM solutions, including Data Lakes/Data Vaults.

SUPERVISORY RESPONSIBILITIES:

QUALIFICATIONS:

• Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 6 years experience in business analytics, data science, software development, data modeling or data engineering work
• 3-5 year’s experience with a strong proficiency with SQL query/development skills
• Develop ETL routines that manipulate and transfer large volumes of data and perform quality checks
• Hands-on experience with ETL tools (e.g Informatica, Talend, dbt, Azure Data Factory)
• Experience working in the healthcare industry with PHI/PII
• Creative, lateral, and critical thinker
• Excellent communicator
• Well-developed interpersonal skills
• Good at prioritizing tasks and time management
• Ability to describe, create and implement new solutions
• Experience with related or complementary open source software platforms and languages (e.g. Java, Linux, Apache, Perl/Python/PHP, Chef) 
• Knowledge / Hands-on experience with BI tools and reporting software (e.g. Cognos, Power BI, Tableau) 
• Big Data stack (e.g.Snowflake(Snowpark), SPARK, MapReduce, Hadoop, Sqoop, Pig, HBase, Hive, Flume)

COMPETENCIES:

• Diversity - Demonstrates knowledge of EEO policy; Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce.
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events.
• Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs workflows and procedures.
• Change Management - Develops workable implementation plans; Communicates changes effectively; Builds commitment and overcomes resistance; Prepares and supports those affected by change; Monitors transition and evaluates results.
• Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan.
• Design - Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail.
• Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.
• Innovation - Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention.
• Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
• Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Benefits organization through outside activities; Supports affirmative action and respects diversity.
• Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks; Develops realistic action plans.
• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Project Management - Develops project plans; Coordinates projects; Communicates changes and progress; Completes projects on time and budget; Manages project team activities.
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
• Technical Skills - Assesses own strengths and weaknesses; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others.
• Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.

PHYSICAL DEMANDS AND WORK ENVIRONMENT:

• Continually required to sit.
• Continually required to utilize hand and finger dexterity.
• Continually required to talk or hear.
• Occasionally exposure to wet and/or humid conditions (non-weather).
• While performing the duties of this job, the noise level in the work environment is usually moderate.
• While performing the duties of this job, the noise level in server rooms is usually loud.
• While performing the duties of this job, employee may need to travel within the U.S.
• Specific vision abilities required by this job include depth perception and ability to adjust focus.

• Tight deadlines must be met with limited staff to support projects.
• Occasional evening and weekend work may be required.
• Work is performed in a traditional commercial office setting with standard office lighting and white noise.
• Additional remarks regarding work environment:
• This job operates in a professional office environment. 

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

ACKNOWLEDGEMENT 

I have read the foregoing job description and understand the responsibilities of the job.   I agree that I am able to perform the essential duties of this position.