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
Click
here to apply!
|