Data Engineer/ SQL Sync Specialist

Praescient Analytics is in search of a Data Engineer/SQL Sync Specialist to join our team to support the IRS's Information Technology Control Tool (ITCT). This position requires US Citizenship and an MBI clearance.

This position will be remote but must be able to be onsite for any required meetings.

Key Responsibilities:

• Design and implement secure, automated data synchronization workflows between Dataverse and on-prem SQL Server using Microsoft On-Premises Data Gateway
• Build and maintain error-handling, retry logic, and logging mechanisms to support near real-time data transfer
• Develop and optimize relational data schemas in Dataverse to support normalized storage and reporting
• Coordinate closely with Power Platform developers to align business rules and data model integrity
• Support reporting integration with Power BI and Tableau by ensuring timely and complete data delivery
• Conduct data quality checks and enforce validation logic to ensure accuracy across systems
• Document data flow architecture, sync logic, and transformation rules for transition to government personnel

Required Qualifications:

• US Citizenship and an MBI Clearance.
• 4 years of experience in data engineering or ETL development
• Experience with Microsoft Dataverse or CDS (Common Data Service)
• Strong SQL Server development skills (T-SQL, stored procedures, indexing)
• Hands-on experience using Microsoft On-Premises Data Gateway
• Knowledge of Power Platform data architecture (Power Apps, Power Automate)
• Experience implementing error-handling and data reconciliation workflows
• Familiarity with Agile development methodologies and version control (Azure DevOps preferred)

Preferred Qualifications:

• Prior experience supporting IRS or other federal agencies
• Experience working in a Microsoft 365 GCC or FedRAMP environment
• Exposure to Power BI dataset modeling and refresh schedules
• Familiarity with FISMA/NIST 800-53 data handling and security standards

If you are a self-starter who is passionate about data analysis and eager to make a meaningful impact, we invite you to apply for this exciting opportunity with Praescient Analytics!

• Very competitive salary based on qualifications and experience.
• Comprehensive, Company paid healthcare for you (We pay your premiums and deductibles)
• 401(k) with company matching
• Travel & performance incentives
• 26 days of paid time off annually
• $5K annual training allowance
• $500 book allowance
• Tuition reimbursement program

Praescient Analytics is committed to providing equal employment opportunities for all. Employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment.

This covers all terms and conditions of employment including (but not limited to):

• Hiring, placement, promotion, transfer, or demotion of all job classifications;
• Recruiting, advertising, or solicitation for employment;
• Treatment during employment;
• Rates of pay or other forms of compensation;
• Benefits;
• Selection for training;
• Company sponsored social and recreational activities; and
• Layoff or termination

Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.
US Citizenship Required
Praescient Analytics is an Equal Opportunity Employer.
Interested Candidates: Please forward your resume to recruiting@praescientanalytics.com and please visit our website to apply online at www.praescientanalytics.applicantstack.com/x/openings.

Salary : $5,000