Data Engineer (SQL)

FedTec • Brooklyn, NY, US • 3w ago

FedTec is seeking SQL Data Engineer

Location: 65 Court St, Ste 1, Brooklyn, NY 11201

Job Overview:

FedTec is seeking an experienced Senior SQL Developer / Data Engineer with a strong background in database design, data integration, and Microsoft technologies. The ideal candidate will have 8+ years of experience across all stages of the software development life cycle, including design, development, testing, deployment, and post-implementation support. Responsible for designing and developing database tables, stored procedures, and triggers, as well as managing daily data extraction and integration using ETL/ELT processes. The candidate will develop and maintain SSIS packages, and work with Azure Data Factory or Azure Synapse Pipelines to enable efficient data movement and transformation across systems. Proficiency in SQL Server, Visual Studio, .NET, and Active Directory is essential, along with familiarity in Azure Cloud, PaaS, DevOps tools, Power BI, and Team Foundation Server (TFS) for version control and collaboration. A Microsoft Certified Application Developer Associate certification (or equivalent) is required.

Responsibilities:

· Designs database tables, extract (import or export) data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed. Experience with ETL and ELT data integration

· Experience in Azure Data Factory or Azure Synapse Pipeline. Knowledge of Azure cloud and associated PaaS and DevOps tools. Knowledge of Power BI & data integration.

· Develops SQL Server Integration Services (SSIS) packages.

· Utilizes Microsoft Team Foundation Server (TFS) for source control, data collection, reporting and project tracking, testing and collaboration of project development.

· Conducts user acceptance review sessions and collaborates with other team members to perform debugging.

Required Skills And education:

· 8+ years of experience in all stages of system development life cycle, including conceptual design, software development, testing, deployment, and post-implementation enhancements of applications

· CERTIFICATIONS: Microsoft Certified Application Developer Associate or equivalent

· TECHNOLOGIES: utilizing Visual Studio, .NET with SQL Server for data management and Active Directory for identity management.

About FedTec: FedTec is a Woman Owned Small Business headquartered in Reston, VA, with additional locations in over 40 states. We are a dedicated team of visionary individuals committed to innovative technology and forward focused methods. Our mission is to modernize and redefine the future of public sector agencies and the people they serve, through innovative technology powered solutions and exceptional operational support. We provide worldclass digital consulting, infrastructure, and cyber security services. As an Equal Opportunity Employer, we consider all qualified applicants without regard to disability, protected veteran status, or any other status protected by law. We are committed to a fair and inclusive workplace where advancement is based on merit, skills, and contributions. When you join FedTec, you become part of a family. We prioritize your safety, health, and happiness through our FedTec Total Wellbeing program, which includes:

Health & Wellness: Medical, dental, and vision plans with Telehealth virtual care and resources for physical and mental wellbeing.
Time to Recharge: Generous paid time off to relax and rejuvenate.
Financial Security: 401(k), company paid short and long term disability, life insurance, and additional voluntary coverage.
Life & Family Support: Employee Assistance Program (EAP), Pet Insurance, and Prepaid Legal services.
Recognition & Growth: The FedTec Applause program rewards outstanding contributions, while our Learning & Development programs support your career growth.
Fitness & Wellness: The FedTec Fit Program includes an on staff Fitness Coach, personal and group training sessions, company fitness challenges, and ongoing wellness support.