Job summary:

SQL Server Data Conversion Lead/Architect

Washington, DC, United States

Length and terms:
Long term - w2 or c2c or 1099

Position created on 11/05/2021 01:32 am

Job description:

**** W2 or 1099 or  c2c ***webcam interview *****Long term  project;  usually the project goes for multiple years with this customer. Candidate must work couple of days per week onsite and remaining remote. *** Proof of vaccination required before starting the project***

This position is responsible for managing the conversion activities from a legacy system (VSAM and SQL) to a new cloud bases solution using SQL.  This will entail overseeing the development of a legacy data dictionary and mapping the legacy data to the new solution and developing extracts and procedures to prepare the data for migration.


Qualifications & Expertise:


  • Provides vision and strategy for all data management initiatives as part data strategist and advisor, part steward for data quality, part advocate for data sharing, and part developer of new data products.
  •  Ensures data is available, reliable, consistent, accessible, secure, and timely to support the mission and activities of the agency. 
  • Establishes and maintains data policies and standards to improve how the agency collects, uses, secures, and publishes data. 
  • Works with executives, IT developers, and data users to achieve data accuracy and process requirement goals for all internal and external customers.
  •  Through supervision of business intelligence analyst(s): 
  • develops dashboards and reporting capabilities that measure agency performance (via targets and metrics) and support day-to-day monitoring of business processes;  
  • monitors, identifies, and prioritizes operational risk factors; and 
  • recommends data-driven strategies to improve organizational efficiency and effectiveness. 
  •  Participates in business process management activities that create, modify, and retire data. 
  •  Represents the agency on citywide data management efforts and vendor relationships.
  •  Establishes data archiving strategies across the agency.
  •  Establishes an internal data council group that provides guidelines and recommendations on business requirements, practices, and compliance to ensure organization business strategy, regulatory compliance, and other requirements are met.
  •  Educates agency members on data management concepts, appropriate usage of data, data quality concepts, agency decision-support concepts, data vendor capabilities, definition and appropriateness of data management, rules on data access, and other data-related matters.
  •  Establishes and maintains optimal coordination, communication, and liaison structure among key system offices, institutions, and external stakeholders. 



Required Skills

  • 16 years experience
  • BS degree or additional 4 years experience.
  • 12 yrs. Experience in documenting business process, requirements, and test scripts.
  • 5 yrs. Experience with SQL Server, data warehouses, and statistical data presentation
  • 16 yrs. Overall IT experience
  • 5 yrs. Experience with SQL Server, data warehouses, and statistical data presentation
  • 8 yrs. Experience and technical knowledge in latest information technology tools that collect, track, secure, and display data, including commercially
  • 8 yrs. Strong project management skills to effectively meet strategic and tactical goals including planning and decision-making
  • 13 + yrs. Experience architecting, designing, and building enterprise-class relational and dimensional data models.
  • 8 yrs. of advanced knowledge of SQL and related programming languages (PL/SQL, T-SQL, etc.)
  • 8 yrs. Experience designing conceptual and logical data models and flowcharts
  • 12 + yrs. deliver detailed design to development organization on enhancements to data architecture
  • Data conversion experience
  • Mainframe/VSAM experience preferred

Contact the recruiter working on this position:

The recruiter working on this position is Rajendra Reddy
His/her contact number is +(1) (202) 4706751
His/her contact email is

Our recruiters will be more than happy to help you to get this contract.