Data Analyst, Sr. (SQL Server)

About The Company Cynet Systems Inc., established in 2010 and headquartered in the Washington, DC metro area, is a premier technology staffing and workforce solutions provider. Serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada, Cynet Systems specializes in delivering agile and scalable talent solutions across various domains including IT, engineering, life sciences, clinical, and professional staffing. Driven by a high-performing recruitment engine operating across North America and Asia, the company is committed to fostering high-quality talent matches that support organizational growth and innovation. As a certified Minority Business Enterprise (MBE), Cynet Systems emphasizes diversity, quality, and operational excellence, maintaining certifications such as ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II, which underscore its dedication to security, quality, and customer success. About The Role We are seeking a highly skilled Data Analyst to join our Data Services Reporting team. This role is pivotal in designing, developing, and maintaining complex data solutions that support critical business operations. The ideal candidate will possess expertise in SQL Server T-SQL development, report creation using SQL Server Reporting Services (SSRS), and business intelligence tools. You will be responsible for developing efficient stored procedures, ad hoc scripts, and interactive reports that enable data-driven decision-making. The successful candidate will collaborate with business stakeholders to understand their reporting needs, analyze complex datasets, and deliver actionable insights. This role offers an excellent opportunity to work with large-scale datasets, optimize query performance, and contribute to the organization’s data strategy in a fast-paced, dynamic environment. Qualifications Bachelor's degree in Computer Science, Information Systems, or a related field (preferred)5+ years of professional experience in SQL Server development and reportingProven experience in developing complex stored procedures, functions, and T-SQL queriesStrong expertise in SSRS report development, including RDL reports, parameters, and data sourcesFamiliarity with Visual Studio and Team Foundation Server (TFS) for source control and collaborative developmentExcellent data analysis, profiling, and cleansing skillsStrong problem-solving and troubleshooting capabilitiesKnowledge of relational database design, normalization, and data modelingEffective communication skills with the ability to work with technical and non-technical stakeholdersExperience with healthcare or insurance industry data systems is a plusUnderstanding of ETL processes and data warehousing concepts is advantageous Responsibilities Design, develop, and optimize complex stored procedures for data extraction, transformation, and reportingWrite efficient T-SQL queries, including multi-table joins, subqueries, window functions, and conditional logicCreate and maintain ad hoc scripts for data analysis, troubleshooting, and specific reporting needsDevelop and implement data validation, quality assurance, and cleansing proceduresDesign and develop interactive SSRS reports, dashboards, and visualizations with complex parameters and data sourcesImplement drill-through and nested report structures to enhance report interactivityOptimize report performance and manage report deployment processesAnalyze complex datasets to identify trends, patterns, and business insightsTranslate business requirements into technical specifications and data solutionsCollaborate with business users to understand their reporting needs and deliver actionable insightsPerform data profiling, validation, and cleansing activities to ensure data accuracyMaintain comprehensive documentation for data models, procedures, and reportsManage source code using Visual Studio and TFS, participate in code reviews, and adhere to development standardsContribute to team knowledge sharing and continuous improvement initiatives Benefits Medical, Dental, and Vision Insurance401(k) Retirement PlanHealth Savings Account (HSA)Disability Insurance (Short-Term and Long-Term)Life and AD&D InsurancePaid Sick Leave (as per applicable state or local law)Supplemental Insurance PlansIdentity Theft ProtectionPet InsuranceEmployee Wellness ProgramsEmployee Assistance Program (EAP)Opportunities for Professional Development and Career Growth Equal Opportunity Cynet Systems Inc. is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment decisions are made without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We believe in fostering a workplace where every individual can thrive and contribute to our collective success.