Data Engineer/SQL Sync Specialist Job at Praescient Analytics, Remote

TVl5a1FPQnR1Y2ZEb1NSdXdybFhFZ2ZkY1E9PQ==
  • Praescient Analytics
  • Remote

Job Description

Position:

Undefined

Description:

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.

Requirements:

US Citizenship and an MBI Clearance required.
4+ years of experience in data engineering or ETL development.
Experience with Microsoft Dataverse or CDS (Common Data Service).
Strong SQL Server development skills including T-SQL, stored procedures, and indexing.
Hands-on experience using Microsoft On-Premises Data Gateway.
Knowledge of Power Platform data architecture, including Power Apps and Power Automate.
Familiarity with NIST 800-53 data handling and security standards.
Experience implementing error-handling and data reconciliation workflows.
Familiarity with Agile development methodologies and version control tools (Azure DevOps preferred).
Preferred: 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, and familiarity with FISMA.

Benefits:

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 and performance incentives.
26 days of paid time off annually.
$5K annual training allowance.
$500 book allowance.
Tuition reimbursement program.

Job Tags

Remote job, Temporary work,

Similar Jobs

Nestlé

Financial Analyst Co-Pilot Job at Nestlé

Foods you love. Brands you trust. And a career that empowers you to grow. At Nestl USA, were all working towards the same goal to delight and deliver for our consumers. With a rich portfolio of beloved brands, including DiGiorno, Toll House, and Coffee mate, in 9...

CCRES, Educational & Behavioral Health Services

Paraprofessional Job at CCRES, Educational & Behavioral Health Services

 ...Make a difference every day by joining CCRES as Special Education Paraprofessional through our partnership with West Shore School District...  ..., and Life Skills CURRENT SPECIAL ED PARAPROFESSIONAL NEEDS: ELEMENTARY: ~ Fairview Intermediate School ~(2) Autistic... 

Chick-fil-A

Team Member Job at Chick-fil-A

Minimum age requirement: 15 years old Chick-fil-A Team Member Are you looking for a fun working environment where teamwork and leadership...  ...are valued? Join Chick-fil-A as a Team Member and be part of a positive, people-focused team that offers flexible schedules... 

Lyra Health

Occupational Health and Well-being Consultant Job at Lyra Health

 ...the RoleLyra Health is seeking a Health and Safety consultant to help employers address occupational stress and improve employee well-being, productivity, and engagement.Ideal candidates should have a strong background in collecting and analyzing data to inform occupational... 

Zed Industries

Growth Product Manager Job at Zed Industries

 ...initiatives Establish growth frameworks and processes that can scale with the company Requirements ~5+ years of experience in product management or marketing with a focus on growth ~ Proven track record of driving significant user and revenue growth metrics ~ Strong...