SQL Data Integration Analyst

Technical Stack & Environment

• Database: SQL Server (Expert-level T-SQL scripting, stored procedures, and complex query optimization).
• Development: .NET Framework, WCF/RESTful API services.
• Testing & Validation: Postman (API testing/troubleshooting) and industry-standard data comparison/profiling tools.

Key Responsibilities
This role serves as a primary gatekeeper for data quality across the transaction lifecycle. You will focus on the technical intersection of database architecture, API integration, and business rule enforcement.

1. Data Quality & Integrity Management: Design, implement, and maintain rigorous data validation rules. Monitor data quality through profiling, comparison, and automated alerting to ensure system-wide integrity.
2. Database Development & Optimization: Architect, build, and maintain database-driven solutions within the Microsoft ecosystem. Focus on SQL scripting, data mapping, and relational database schema design to support high-volume transaction flows.
3. API Integration & Interoperability: Develop and maintain RESTful APIs and WCF services. Ensure seamless communication between internal systems and third-party vendors by building robust integration points.
4. Investigative Problem Solving: Act as a technical detective. Analyze transaction life cycles, investigate data anomalies, and troubleshoot discrepancies between incoming data and system requirements.
5. Quality Assurance & Testing: Utilize tools like Postman to validate API endpoints and perform integration testing. Conduct thorough code reviews to ensure all data movements and service calls adhere to organizational best practices.
6. Strategic Collaboration: Partner with cross-functional teams to translate business requirements into technical specifications, ensuring that data solutions are scalable, efficient, and aligned with long-term strategy.

Requirements

• Education: Bachelor's degree in Computer Science, Software Engineering, or related analytical field (or equivalent professional experience).
• Experience: 5+ years of hands-on experience in software development with a heavy emphasis on SQL programming, complex database design, and data lifecycle management.
• Technical Proficiency:
  
  
  • SQL Mastery: Proven ability to write complex scripts, perform data profiling, and build automated data quality rules.
  • Integration Expertise: Demonstrated success in building and consuming RESTful APIs and WCF services.
  • Development Frameworks: Strong proficiency in .NET development.
  • Testing/Troubleshooting: Demonstrated ability to use API testing tools (Postman) to troubleshoot and validate data flow in real-time.
• Mindset: A natural investigator with strong organizational skills, high attention to detail, and a proactive approach to identifying and filling "data gaps" before they impact business operations.

Key Details:

• Compensation: $65.00-70.00 per hour
• Benefits: LaSalle Network consultants are eligible to enroll in benefits. For details, visit

#LI-EB1


LaSalle Network is an Equal Opportunity Employer m/f/d/v.


LaSalle Network is the leading provider of direct hire and temporary staffing services. For over two decades, LaSalle has helped organizations hire faster and connect top talent with opportunities, from entry-level positions to the C-suite. With units specializing in Accounting and Finance, Administrative, Engineering, Marketing, Technology, Supply Chain, Revenue Cycle, Call Center, Human Resources and Executive Search, LaSalle offers staffing and recruiting solutions to companies of all sizes and across all industries.


LaSalle Network is the premier staffing and recruiting firm, earning over 100 culture, revenue and industry-based awards from major publications and having its company experts regularly contribute insights on retention strategies, hiring trends, hiring challenges, and more to national news outlets. LaSalle Network offers temporary Field Employees benefit plans including medical, dental and vision coverage. Family Medical Leave, Worker's Compensation, Paid Leave and Sick Leave are also provided. View a full list of our benefits here


All assignments are at-will and their duration is subject to change.