Senior SQL Server specialist to develop, debug, and optimize T-SQL, analyze and standardize large datasets, collaborate with architects and stakeholders, and lead technical solution development for legal-services data projects (1-year contract, fully remote within approved US states).
This is a remote position.
Paradigm is seeking a SQL Server Data and Analytics Specialist to support our client with complex Legal Services data projects. This role is ideal for a senior SQL professional with advanced T-SQL development, strong analytical problem-solving skills, experience working with large data sets, and the ability to communicate technical solutions clearly to business stakeholders.
Type: 1 year contract
Location: Fully Remote, USA in approved states
Approved States:
Alabama, Arizona, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Kansas, Kentucky, Louisiana, Maryland, Massachusetts, Michigan, Minnesota, Missouri, Nevada, New Jersey, New York, North Carolina, Ohio, Oklahoma, Oregon, Pennsylvania, South Carolina, Tennessee, Texas, Utah, Virginia, Washington, Washington DC, Wisconsin
Benefits: Paradigm offers medical, dental, vision, life, 401K, PTO, and sick days.
Job No.: Para_1448
Job No.: Para_1448
As a SQL Server Data and Analytics Specialist you will:
- Develop, debug, and test T-SQL code to address a wide range of technical and analytical problems
- Determine and implement effective strategies to explore, analyze, interpret, standardize, and conform complex datasets
- Collaborate with team members to determine the sufficiency of data and ensure alignment in requirements
- Assist Solutions Architects in the development of data processing plans that address the custom needs of each project
- Interface with business stakeholders to identify new and/or clarify existing requirements
- Manage and prioritize assigned tasks, ensuring deadlines are achieved, communicating appropriately about progress and obstacles
Requirements
Our skills and experience wish list includes:
- 10+ years of experience with SQL Server and/or other relational databases
- Advanced or expert-level experience developing T-SQL code
- Strong experience tuning T-SQL queries and optimizing database server performance
- Experience performing complex data analysis on large data sets
- 5+ years of experience leading the development of technical solutions
- Strong problem-solving skills and the ability to work through under-defined problems
- Ability to understand complex business processes and adapt solutions to meet business needs
- Excellent communication skills with peers, managers, and business stakeholders
- Comfortable in consultative conversations and able to explain technical challenges and solutions to non-technical teams
- Bachelor’s degree in Computer Science, Engineering, or a related field preferred
Benefits
Paradigm offers a competitive benefits package that includes medical, dental, vision, life, 401K, PTO, and sick days.
About Us, Paradigm
Want to love Mondays? It's possible when you love what you do. Paradigm is a staffing solutions firm dedicated to finding the perfect job for candidates. We're connected with some of the most innovative tech companies around, giving our employees that competitive edge needed in today's job market.
Paradigm Information Services does not discriminate based on race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design, develop, test, and maintain large-scale healthcare data pipelines and AWS data warehouse solutions. Build Redshift and EMR ETL processes, monitor pipeline performance, resolve data discrepancies, support deployments, conduct code reviews, and document database designs and testing. Collaborate with engineers, analysts, consultants, and cross-functional teams to improve data quality, scalability, and processing efficiency.
Top Skills:
Amazon EmrAmazon RedshiftAmazon S3Automated Testing FrameworksAWSCi/CdETLOraclePythonSQLSQL Server
Fintech • Financial Services
Leads a client’s migration from SQL Server, SSIS, and SSRS to Snowflake and Sigma while maintaining legacy reporting operations. Designs data models, ETL pipelines, reports, dashboards, source-to-target mappings, and migration plans; validates reporting parity and coordinates phased cutovers. The role also provides client-facing technical leadership, troubleshooting, documentation, peer reviews, and ongoing support for banking data and reporting systems.
Top Skills:
AltovaC#ErwinLucidExcelMicrosoft PowerpointMicrosoft VisioMicrosoft WordOracle Sql Data ModelerOxygenPower BIPowershellSigmaSnowflakeSparxSql DeveloperSQL ServerSsasSsisSsrsT-SqlTableauTcpUdpVisual BasicVisual StudioWebapi
Information Technology • Consulting
Administer and optimize Oracle databases hosted in Amazon RDS for federal web applications within an Agile Scrum team. Responsibilities include completing sprint user stories, writing and tuning SQL queries, developing stored procedures, scripts, triggers, and batch jobs, managing users, roles, and database instances, and troubleshooting performance issues with development teams. The role requires strong database administration, security, analytical, communication, and organizational skills, along with the ability to obtain and maintain DHS suitability.
Top Skills:
Agile ScrumAmazon RdsDatabase ScriptsDatabase TriggersOracleRdbmsSQLSql DeveloperStored ProceduresToad
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
