Back to Job Search

T-SQL Data Analyst

Posted 19 days ago

Our client is the world’s leading provider of information and marketing solutions for the Commercial Real Estate industry. They provide cloud-based lease accounting and administration applications to the commercial real estate industry. They helps corporations, retailers, landlords, and commercial real estate service providers build world-class real estate operations by providing integrated solutions that eliminate information "silos" and consolidate information across business units. The company culture is highly interactive and fast paced and they operate as a small company within a large company. They have a great team culture, strong technical team, and excellent leadership team. The development team collaborates with the IC (implementation consultants who gather the client requirements and build out technical requirements.

Our client is seeking candidates who can work in the office 3 days/week and require all employees and consultants to be fully vaccinated.

Job Description:
Primary duties of the data migration specialist will be completing technical design documentation with client data sources, selecting, translating, and loading data (databases, spreadsheets, etc.) from client data sources into the company system and validating the accuracy of data conversions. Other duties include troubleshooting migrated data, resolving technical issues, training customers on the use of the ETL product and updating loaded data. The Data Migration Specialist will be expected to work independently and manage multiple critical tasks simultaneously to meet project delivery dates.
Once proficient in the data migration role, the specialist will also be trained to support our SQL development resources in building and updating client integrations using IBM App Connect studio.
Engage internal development team and clients to complete data mapping requirements
Build data queries on Client’s data and manage load process through company ETL tool
Facilitates and communicates best practices and expectations on processes and standards
Provides quality customer service, including interacting with customers, answering customer inquiries, and effectively handling customer complaints

BASIC QUALIFICATIONS:
Bachelor’s degree required
SQL experience in both creating and maintaining queries, views, and stored procedures in a multi-database environment required
Experience with relational database, data analysis, and data conversions
Experience in consulting and involvement with data related projects

PREFERRED QUALIFICATIONS AND SKILLS:
Proven capacity to effectively interface with customer and internal consulting teams
Self-motivated with a strong work ethic and a passion for problem solving and quality
Must be detail-oriented and possess strong organizational, written and verbal skills
Passion for improving processes and use of technology to perform tasks more efficiently and at higher standards of quality
Experience in databases (relational/document/etc.) including SQL databases
Experience in creating SQL Server database objects such as tables, views, procedures and functions
Experience with Powershell and Azure DevOps to enhance migration activities.
means you'll enjoy a culture of collaboration and innovation that attracts the best and brightest across a broad range of disciplines. In addition to generous compensation and performance-based incentives, you'll be supported in both your professional and academic growth with internal training, tuition reimbursement, and an inter-office exchange program.

Benefits package includes (but is not limited to):
Comprehensive healthcare coverage: Medical / Vision / Dental / Prescription Drug
Life, legal, and supplementary insurance
Commuter and parking benefits
401(K) retirement plan with matching contributions
Employee stock purchase plan
Paid time off
Tuition reimbursement
On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes, as well as Segways and bikes available for use during the day
Complimentary gourmet coffee, tea, hot chocolate, prepared foods, fresh fruit, and other healthy snacks

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer and provides reasonable accommodations for qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.