Associate Data Developer

As an Associate Data Developer, you will be tasked with developing and maintaining SQL and .NET code for the extracting and loading of data from systems, external or internal, to Pearl’s primary software platforms. You will also be responsible for updating the required documentation for the data flows you modify. This is an entry-level position with individually tailored on-site training.

Your day-to-day responsibilities will include analyzing existing data structures and assisting with modifying the data flows primarily using T-SQL. You will spend time reviewing and modifying SQL database scripts/jobs, and ensuring you follow our department processes to keep our data, fine-tuned, and secure.

Your Impact:

• Build data migration processes within SQL SSIS and .NET using T-SQL and C#.
• Write queries and processes required for data migration and transformation.
• Create database objects such as views, stored procedures and functions as needed using T-SQL.
• Implement changes to databases at the direction of team leadership.
• Ensure the secure storage and movement of sensitive data (i.e., PII or PHI).
• Communicate with team members and business users to resolve technical issues as they arise.
• Monitor SQL jobs and processes health and debug/identify potential issues.
• Perform SQL development tasks as a function of development cycles and system releases.
• Analyze existing databases to document current functionality and data objects.
• Write and maintain documentation to describe database object design and data processes. 
• Analyze assigned SQL development tasks and provide feedback on feasibility and time.

Successful Candidates Will Have:

• Associate degree in computer science or related with the following minimum professional experience –
  • 1+ years of programming, relational database management systems
  • 1+ years of experience with SQL, XML, ETL tools, C#, and database object programming
  • Application programming experience is a plus

• Basic understanding of the following –
  • Database systems and SQL
  • Microsoft .NET Framework and C# language
  • Problem-solving abilities using critical thinking that applies logic
  • Application programming experience a plus.
• Demonstrated ability in all the following –
  • Learning technical and functionality concepts quickly with a high level of retention
  • Communicating technical and functionality concepts verbally and in writing.
  • Organizing and prioritizing workload with multiple projects and deadlines
  • Working effectively under pressure in a fast-paced environment
  • Managing frequent and random changes efficiently
  • Capability of consistently delivering a detail-oriented high level of accuracy

At One80 Intermediaries, base pay is one part of our total compensation package, which also includes a comprehensive suite of benefits, including medical, dental, vision, disability, life, and retirement savings, and 10 days of paid time off and 11 paid holidays for eligible employees. The total compensation for a position may also include other elements dependent on the position offered. The expected annual pay range for this position is $51,800 to $60,000 plus discretionary bonus. The actual base pay offered may vary depending on multiple individualized factors, including geographical location, education, job-related knowledge, skills, and experience.

One80 Intermediaries is a privately held firm with offices throughout the US and Canada. As a leading insurance wholesaler and program manager, One80 offers placement services and binding authority for property and casualty, life, travel/accident and health, affinity and administrative services, and warranty business. Launched just four years ago, One80 Intermediaries has grown to be one of the largest intermediaries in the United States. In 2024, we were ranked 14th largest broker in the U.S. by Business Insurance.

One80 Intermediaries is an equal opportunity workplace and is committed to ensuring equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics.

Learn more about working at One80 Intermediaries by visiting our careers page: www.one80.com/careers.