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