Sr. MS SQL Server TSQL Developer

SENIOR TSQL DEVELOPER - REMOTE ARC Group has an immediate opportunity for a Senior TSQL Developer with strong experience working with SSIS, SSAS, and PowerBI! This position is 100% remote working eastern time zone business hours. This is starting out as a contract position running through July 2025 with strong potential to extend longer or convert to FTE. This is a fantastic opportunity to join a well-respected organization offering tremendous career growth potential. At ARC Group, we are committed to fostering a diverse and inclusive workplace where everyone feels valued and respected. We believe that diverse perspectives lead to better innovation and problem-solving. As an organization, we embrace diversity in all its forms and encourage individuals from underrepresented groups to apply. 100% REMOTE! Candidates must currently have PERMANENT US work authorization. This position can only be worked on W2. No other payment term, visa transfers or sponsorship allowed. Essential Functions:

• Will work as a part of the SQL Development team by designing schema, tables, views, indexed views, developing stored procedures
• Create complex queries, SSIS jobs and SSRS / Power BI Reports.
• Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data.

Qualifications

• Solid knowledge and experience with developing complex, hi-performance data cleansing SSIS Packages.
• Must possess expert programming and troubleshooting skills
• Must possess expert performance tuning skills and dynamic SQL skills
• Must be willing to jump into anyone’s code at any time to solve the problem
• Must be able to reverse engineer anyone else’s code and be able to modify it to solve the problem in a better or more efficient way
• Application programming experience in .NET .NET, C#, ASP.NET, MVC 5, JavaScript, JSON, JQuery
• Demonstrated knowledge in XML and web services
• Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures
• Proficiency using versioning tools like Git.
• Ability to communicate technical information clearly and articulately
• Experience mentoring / or leading other development staff
• Proven leadership abilities including effective knowledge sharing, conflict resolution, facilitation of open discussions, fairness and displaying appropriate levels of assertiveness
• 24x7 Production support experience supporting a large scale
• Experience with complex indexing strategies including column store indexing
• Experience with handling PHI data
• Experience with SSAS (MDX or DAX)
• Experience in developing Web services

Musts:

• Exp with SSIS, tabular cubes, and extracts
• Specialized tools to focus on: SSAS Tabular Cube, SSIS Parallelism, Extracts, SFTP, Power BI Service, SharePoint, Tableau, Azure Synapse, Transact-SQL, TOAD, Snowflake schemas

Required Work Experience: 5+ years related work experience, Professional experience with technical design and coding in the IT industry Required Education: Related Bachelor’s degree or related work experience Would you like to know more about our new opportunity? For immediate consideration, please apply online and view all our open positions at www.arcgonline.com. ARC Group is a Forbes-ranked a top 20 recruiting and executive search firm working with clients nationwide to recruit the highest quality technical resources. We have achieved this by understanding both our candidate's and client's needs and goals and serving both with integrity and a shared desire to succeed. At ARC Group, we are committed to providing equal employment opportunities and fostering an inclusive work environment. We encourage applications from all qualified individuals regardless of race, ethnicity, religion, gender identity, sexual orientation, age, disability, or any other protected status. If you require accommodations during the recruitment process, please let us know. Position is offered with no fee to candidate. Remote Skills: Change Management, Communication Skills, Conflict Resolution, Database Design, Diversity, Documentation, Equal Employment Opportunity (EEO), Executive Recruiting, Git, Identify Issues, Information Technology & Information Systems, JSON, JavaScript, Leadership, MDX (MultiDimensional eXpression Language), Mentoring, Microsoft .NET, Microsoft ASP.NET (Active Server Page), Microsoft C# (C Sharp), Microsoft SQL Server, Microsoft SharePoint, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Model View Controller, OLAP Cubes, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Procedure Development, Production Support, Protocol Design, Quest Software TOAD, Reverse Engineering, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Secure/SSH File Transfer Protocol (SFTP), Server Programming/Applications, Snowflake Schema, Software Engineering, Stored Procedures, Tableau, Technical/Engineering Design, Unit Test, Web Programming, Web Services, jQuery About the Company: ARC Group Apply To This Job