Data Specialist

Company: SmartSource
Location: Carrollton
Posted on: May 9, 2022

Job Description:

Job Description SmartSource--, an ABCOM Technology Group company, has more than 35 years of experience serving clients' business technology needs in the events, staffing, legal, government, finance, education, entertainment, and meeting production industries. The company provides service throughout North America through its fully staffed and equipped offices in major metropolitan markets. SmartSource draws from its extensive inventory of IT, AV, and interactive technologies to deliver solutions as varied as computers for contract staff, office equipment for temporary spaces, or multi-story video walls for trade shows and events. The SmartSource team is passionate about leveraging its expertise to empower clients to excel. SmartSource will afford you an exciting career opportunity. We offer a fast-paced and dynamic work environment. Most importantly, you will be provided the support and environment to excel and succeed with an industry leading company. If you are enthusiastic, highly motivated and looking for a great opportunity, we encourage you to apply today. Job Summary: The primary responsibility of the Data Specialist will be to create and modify MS SQL queries and build source to destination SSIS packages from backend of data warehouse. Scope of work would include building integrations with and maintaining the data warehouse, designing, and developing stored procedures, functions, SQL scripts, and database packages that will help in creating meaningful analysis. The candidate will also be responsible for updating and maintaining existing reports. The ideal candidate would be a confident problem solver who challenges traditional solutions and whose work style adheres to software development best practices. This position will report to our Director of IT. Responsibilities: Creating MS SQL queries that ultimately feed reports and actionable BI insights using SQL skills Maintain automated reporting Create integration to and maintain data integrity of data warehouse. Code, test, debug, implement and document reports and processes. Gather requirements for report development projects and devise, develop and deliver report solutions. Recognize, evaluate, and present opportunities for improvement in operational performance and efficiency. Provide operational support to ensure that the highest level of service availability and data quality. Able to read, interpret, and verify data from multiple sources Backup and restore databases Qualifications: Bachelor's degree in computer science, analytics, or information management. One year experience in ETL specifically MS SQL and tools like SSIS, SSRS, SSMS. Experience in writing complex SQL queries, including Stored Procedures, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Views, Performance Tuning and Query Optimization. Expertise in Data Integration/Migration from various sources like SQL Server, JSON, Flat Files, and XML files. Advanced knowledge of MS Excel (get and transform data, and queries and connections) Proven ability to manage multiple tasks while working independently and in a team Self-motivated with a strong aptitude for learning new technology and tools. Strong organizational and documentation skills. Excellent communication skills, both written and verbal, with people at all levels of an organization. Experience with Power BI, Cognos, XML transformations, C#, ASP.NET, HTML, JavaScript, Web Services a plus

Keywords: SmartSource, Carrollton , Data Specialist, Other , Carrollton, Texas