What are the responsibilities and job description for the Data Integration Engineer position at I and I Software Inc?
Job Details
Job Title: Data Integration Engineer
Summary Description:
Majority of the time will be spent designing, developing, automating and coding projects for improving efficiency within our systems. Developer will work with the business and vendors to understand customer needs and develop high value solutions. They are accountable for the design and implementation of solutions that meet software functional and non-functional requirements and adhere to established development standards. The deliverables are expected to meet customer s needs, be secure, high performing, scalable, maintainable, supportable, compliant with standards, and consistent with the architectural framework. Developer is expected to support products in use by diagnosing and resolving issues. Developer will also participate in initiatives to improve processes, standards, and practices.
Experience
- Experience with relational database design and writing efficient SQL queries or data transformation scripts.
- Experience working with multiple data sources to extract, transform, and load data.
- Process / Job Management
- Knowledge of transmission protocols: FTP, SFTP, FTPS, SSH, Telnet, API
- Knowledge of JSON blob storage and retrieval.
- Ability to manipulate and optimize data loads during transit with tools like Node.JS or Python.
- Encryption Technologies: PGP, GPG
- Develop solutions using TDD or event driven methodology.
- Automation mindset and experience
Required Skills
- Minimum 5-7 years of hands-on database development experience, using stored procedures, functions, triggers, and views on Microsoft SQL Server and PostgreSQL platforms.
- Proven Microsoft T-SQL skills as well as PostgreSQL to include optimizations through Explain/Analyze.
- Excellent Written and Verbal Skills
- Demonstrated strengths in organization, attention-to-detail, follow-through, reasoning, critical thinking, and problem-solving skills
- Work independently, ability to multi-task, and comfortable engaging with all levels of the organization, including leadership
- Ability to learn established code
- Ability to translate business needs into computer-oriented solutions
- Ability to document work
Desirable Knowledge and Skills
- Ability to analyze complex data to be proactive in business decisions
- HIPAA Compliance Knowledge
- Knowledge working in technical EDI role. 834, 837, 835
- Familiarity in working with Kubernetes / docker solutions.
- Experience in the Healthcare field
Measures of Performance: The ETL developer shall be performing in an acceptable manner when the following have been accomplished:
- 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. Self-driven to identify and correct problems or propose enhancement solutions.
- Customer Service Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
- 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; Tailors the content of speech to the level and experience of the audience; Uses appropriate grammar and choice of words in oral speech; Organizes ideas clearly in oral speech; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
- 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.
- 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; Listens and responds constructively to other team members ideas; Offers support for others ideas and proposals; Is open with other team members about his/her concerns; Expresses disagreement constructively.
- Quality Management Looks for ways to improve and promote quality; Demonstrates accuracy and thoroughness. Continually evaluates, cross-checks, and verifies own work before distribution.
- Ethics Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
- Judgment Displays willingness to make decisions; Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
- Quantity Meets productivity standards; Completes work in timely manner; Strives to increase productivity; Works quickly but accurately.
- Attendance/Punctuality Is consistently at work and on time; Ensures work responsibilities are covered when absent; Arrives at meetings and appointments on time.
- 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.