DATA ENGINEER - Data and Vendor Integrations

Summary

Messerli & Kramer, P.A. is an industry-leading consumer collection firm representing numerous national creditors. The Collections Division located in Plymouth, MN is seeking an experienced Data Engineer who will excel in a challenging, fast-paced environment. This hands-on position requires candidates to be both technically proficient and astute on a business level.

The Data Engineer is responsible for working directly with the Data Operations team to maintain our multiple vendor software data environments / integrations while ensuring sustained data exchange between the firm and its clients. The position is a blend of challenging and intellectual duties including data analysis/reporting, data modeling, vendor communication, multi system integration, documentation, and heavy data centric development. The position requires the ability to be technically adept and agile in approaching complex and changing demands. This position also involves working with senior leadership to ensure the quality of our reporting and operational processes are efficient, streamlined, and automated wherever optimal.

Applicants must be authorized to work for any employer in the United States. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Hybrid Remote Schedule Potential (up to 2 days per week) after successfully completing 90 Days of Employment & Meeting Eligibility Criteria

Primary responsibilities:

• Daily file exception handling protocols.
• SQL/Python/PowerShell development of customized jobs or Vendor API integrations.
• Overall job and workflow maintenance in the database.
• Building Analytic & Data-Warehouse systems.
• Client reconciliations for inventory and financials.
• Code mapping validation and remediation.
• Collaboration with operations staff to enhance reporting capacities. This includes building of dashboards and laying the groundwork for a business intelligence system.
• Project development in support of operations initiatives.
• Create, maintain and prioritize backlog items accordance to the Agile processes.
• Maintain team operating procedures with all new or changing procedures.
• Daily transfer of placement, financial transaction and maintenance files to/from numerous clients in a backup role.

Benefits & Perks Include:

• Medical, Dental, & Vision Insurance
• HSA & FSA Accounts
• 401K, with 4% company contribution (after 1 year of service)
• Paid time off (17 days per year)
• Paid holidays off (7 days per year + a floating holiday)
• Company Paid Life Insurance
• Employee Assistance Program
• Eligibility in Annual Discretionary Bonus
• Building amenities include: Free parking, onsite restaurant, & onsite free gym 

Negotiable Salary Based on Experience

Qualifications:

• Minimum 4 year college degree.
• Minimum 8 years of experience in a Data Engineering role. 

Competencies:

• Proficiency of two or more of the following: Java, .NET, Power BI and Python.
• Proficiency in SQL Server 2022, SQL Management Studio, SSIS, SSRS, Crystal Reports, PowerShell, Microsoft Office, and Adobe.
• Proficiency with mature Development and Agile methodologies and best practices. 
• Proficiency with maintaining a blend of On-Premise and Azure Cloud infrastructure best practices and Security Architecture. 
• Excellent verbal and written communication skills, exhibited leadership abilities, solid organization skills.
• Ability to communicate effectively with technical and non-technical personnel.
• The ability to manage multiple deadlines and demonstrated experience identifying and implementing automation to enhance organizational efficiency.
• Proficiency with data integrity QA processes.
• Familiarity with compliance requirements and the remediation process.
• Possess a basic understanding of accounting principles and data transfer practices.

Work Environment & Physical Demands:

This role operates in a professional office setting, routinely working with standard office equipment. Generally, due to the nature of this office position, the person in this role would be required to talk and hear, sit or stand for long period of time, and use their hands and fingers, to handle and feel. Occasionally required to walk, reach with arms and hand, climb or balance, and to stoop, kneel, or crouch. Regularly required to lift and/or move up to 10 pounds, occasionally lift and/or move up to 25 pounds. Vision abilities required by the job include close vision.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions and to meet job requirements.

All applicants must pass a criminal background and drug screening before commencing employment with Messerli & Kramer, P.A.

Wage Disclaimer: The starting wage for this position is $90,000-$125,000/year. The wage range for this position is $90,000-$140,000/year.