About

Data Engineer (MSSQL) Contract Compensation: $125 / hour for 1-3 month project (could lead to ongoing work) Job Description Flexihire is partnering with AR Proactive to recruit for this position. We are managing the recruitment process on behalf of AR Proactive and will handle all candidate communications. Company Overview AR Proactive is a 10-year-old B2B SaaS company in healthcare/fintech (HQ: Chicago) with a global, 19-person product/engineering team (CTO, Engineers, PM, QA). We’re fully remote, equip engineers with premium AI developer tools to do high-impact work, move fast with low bureaucracy, and value clear communication. Summary We’re looking for a Data Engineer (MSSQL) for a 1–3 month contract to re-architect our data model and pipelines to be extensible, maintainable, and fast. You’ll reverse-engineer the current setup (scraped + client DB dumps), design a clean target model, and build robust transformations from raw MSSQL sources. Project Goal Re-architect data model and pipelines for speed and maintainability Reverse-engineer the current setup and design a clean target model Build robust ETL/ELT pipelines from raw MSSQL sources Responsibilities Two Phases of the Project Scoping and Understanding: (1–2 weeks) Execution: (depends on the plan, 1–3 months) Key Tasks Audit and reverse-engineer current databases, schemas, and pipelines (raw + converted) Design a target data model (OLTP/OLAP), including naming, normalization/denormalization, and data contracts Build reliable ETL/ELT pipelines from raw MSSQL dumps to the new model; automate and orchestrate them Optimize performance (indexing, partitioning, query plans) and reduce query latency Implement data quality checks, validation, and monitoring Document architecture, lineage, and operating procedures; transfer knowledge to the team Expected Deliverables Current-state assessment and data lineage map Target data model & standards (ERD + data contracts) Migration plan with risks, cutover strategy, and rollbacks Production-ready pipelines with tests, monitoring, and SLAs Performance benchmarks and documentation We’re Looking For 5+ years in Data Engineering with strong MSSQL/T-SQL expertise (query tuning, indexing, execution plans) Proven experience in reverse-engineering legacy databases and executing data migrations Solid data modeling skills (3NF, star/snowflake), and designing schemas for analytics & operations Hands-on building ETL/ELT with SQL and a general-purpose language (e.g., Python) Experience with orchestration/versioning/testing (e.g., Airflow/Dagster/SSIS, Git, CI) Proactive, ownership-driven, and comfortable working with ambiguous legacy data Nice to Have Experience with dbt or similar transformation frameworks Background with web-scraped data normalization Familiarity with columnar storage, warehousing, or Azure/Microsoft data stack Reporting Structure Project Manager, Scrum Team/Master + CTO. Current team — 6 Devs, Team Lead, and DevOps. Recruitment Process Screening → Interview → Endorsement (Company ATS) → Tech Interview 1 → Tech Interview 2 → Offer→Reference Check→ Acceptance → Start Date Hiring Process at a Glance Deep-dive technical interview → Team fit (communication, collaboration, culture) How to Apply Share a brief note on relevant projects (reverse-engineering + MSSQL), sample ERD or migration plan if available, and links to code or case studies.