Sr. MS SQL Server TSQL Developer
Senior TSQL Developer 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