|
Search Jobvertise Jobs
| |
Jobvertise
|
ACHI SQL Database Administrator
Location: US-TX-Dallas
Email this job to a friend
Report this Job
The Applications Systems Analyst/SQL Server Reporting Developer will be responsible for building repeatable reporting solutions from analytic database systems.
ON-SITE WORK ONLY
CANDIDATES MUST BE LOCAL TO START THE JOB DAY 1.
They will partner with business analysts and developers in the definition, development, maintenance, and documentation of dashboards, scorecards, new customer reports, and oversee the maintenance and enhancement of existing reports. They will contribute to all system and client documentation. They will develop, deploy, and maintain ACHI reporting and analytic output using other tools including SSIS and business intelligence tools.
Qualifications:
Bachelor's Degree in Information Technology, Computer Science, Social Science or related field
5+ years technical experience with Microsoft SQL Server Reporting Services, Analysis Services and Integration Service in building SQL Server data warehouse business intelligence reports, writing, debugging, maintaining, testing and documenting complex T-SQL and MDX queries.
5+ years of experience working with and developing vb.net/C# projects.
5+ years of experience in data warehouse architecting/data modeling, creating, maintaining and testing Microsoft SQL Server data marts and cubes, facts and dimensional tables
Responsibilities:
Builds and maintains the reporting infrastructure, documentation, unit testing, artifacts and objects for the Arkansas All Payer Claims Database.
Daily activities include the creation, debugging and customization of ACHI s reporting products, detailed development and documentation of integration services packages
Builds, maintains and debugs reporting infrastructure
Provides regular status reports on assigned tasks. Unit tests own and other developers work.
Assists QA in creating and validating reporting artifacts and deliverables.
Researches and resolves code defects of varying complexity.
Designs, builds and tests complex SSIS data transformation packages as needed
Writes and updates reporting infrastructure documentation, including the development of technical documents pertaining to ACHI s reports, SSIS packages and client facing materials.
Maintains and updates all documentation related to assigned products.
Develops test plans and test cases specific to reporting services products and works with QA in debugging and testing reporting services products.
Ensures that deployed reporting services products and deliveries are functionally and operationally correct.
Other duties as assigned
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| RDBMS on SQL Server 2014 | Required | 5 | Years | | Query Analyzer, Profiler, SQL MAIL, SQL Agent | Required | 5 | Years | | Warehouse/Reporting (SSAS, SSRS, Cubes, Data Marts, Fact and Dimension, ETL) | Required | 4 | Years | | Data Modeling Using Visio | Required | 4 | Years | | MDX, T-SQL,C# | Required | 5 | Years | | BI Studio/Visual Studio 2013+, TFS | Required | 4 | Years | | XML, ASP.NET,vb.net, Testing, Data warehouse, SSAS, DBA, SFTP | Highly desired | 0 | |
Questions | No. | Question |
|---|
| Question1 | NA NA. Do you accept this requirement? | | Question2 | This requirement falls under the E-RTR process. The candidate MUST follow the process and submit their Right to Represent electronically to be considered. Do you accept this requirement? | | Question3 | Please list candidate s email address. | | Question4 | This position is on-site work only beginning Day 1. Do you and your candidate accept this requirement? | | Question5 | Did you PROVIDE THE FULL Job Description and Job Title to the candidate? |
RICEFW Technologies Inc
|
