Senior ETL Developer

Description The Senior ETL Developer is responsible to design, build, test and coordinate all activities related to the integration of data across various sources into an organized and unified view. This individual is also responsible for the monitoring of data flow between databases, servers, and cloud services to identify and implement the most suitable data integration architecture for the organization’s needs. This individual must have proven communication skills, problem-solving abilities, and knowledge of data integration best practices as these skills are critical to the successful performance of this role. This position requires in-office attendance two days per week in our Minnetonka, MN office. Essential Duties and Responsibilities Architect, Design and implement ETL processes. Develop and maintain integration tools and utilities. Proficient in writing SQL queries and troubleshooting issues. Support existing applications. Provide guidance and support to Junior/Mid-level developers. Instruct, direct, and check the work of others. Lead, design, code, test and debug complex development efforts. Document, enforce and model best standards and practices to others. Oversee project completions and ensure user satisfaction. Complies with Company policies, procedures, regulatory requirements, and complete mandatory company compliance training by prescribed deadlines. Ability to accept guidance and supervision from management. Other duties that may be reasonably assigned. Knowledge and Skills Required Experience in enterprise-level ETL using Informatica Intelligent Cloud Services (IICS). Experience with cloud data integration architectures (Azure, Snowflake). Experience working with a Data Lake or Data Warehouse. Fluent in SQL. Understanding of network protocols and standards as they pertain to data integration. Knowledge of R, Java, C# or Python a plus. Ability to work in fast paced environment while successfully performing under extreme time constraints. Ability to act independently with sound judgment and take initiative. Communication and Interpersonal skills Excellent professional written, verbal, listening and communication skills. Must be a personable, positive, and professional representative of the company. Ability to foster, develop and maintain professional and collaborative working relationships. Must be able to get along with others, i.e., peers, employees, supervisors, outside customers, and vendors. Lead by positive example. Ability to collaborate and interact effectively and professionally with all levels of management, employees and customers by email, phone, video conferences and in person. Actively listens. Is mindful of how body language, gestures and nonverbal communications are perceived. Physical/Mental Demands The ability to work with confidential information. The ability to perform under pressure and be flexible with disruptions throughout the workday. Repetitive and continual keyboard activity and interaction with display monitors is required. Overnight business travel by air and/or automobile, may be required. The estimated pay range stated represents the typical pay range for this position or similarly employed employees or employees performing substantially similar work. Factors which may be used to determine the actual pay rate may include, but are not limited to, education, training or experience; seniority; merit and work performance; quantity or quality of production; regional differences in compensation; differences in local minimum wages, or ability and effort. Position's Pay Range $125,000 - $135,000/annually Benefits may include Comprehensive medical, prescriptions, dental and vision plans 401(k) plan with a discretionary company match Shareholder Purchase and Reinvestment Plan Basic life and accidental death and dismemberment insurance premium paid by the company Voluntary supplemental life insurance for employees, spouses and dependent children Fertility and Family Building Benefits Paid Disability benefits Paid time off programs 11 Company paid holidays per year Flexible spending account Health savings account (available to High Deductible Health Plan participants only) Employee Assistance Program Educational Assistance Program Voluntary benefits, such as Critical Illness, Hospital Indemnity, Pet Insurance and Accident Insurance Title insurance policies and certain escrow services for the employee’s primary personal residence at no charge Transportation benefit plan for mass transit, parking and vanpool, in several markets #J-18808-Ljbffr Old Republic Title