Job Role: SQL Server & Report Developer (471167)
Location: Little Rock AR
Duration: 4+Months
Not-To-Exceed rate is $40/hr on C2C
The Applications Systems Analyst/SQL Server Reporting Developer will be responsible for building repeatable reporting solutions from analytic database systems.
the client is currently working on gaining approvals for additional funding in order extend this engagement. No commitments can be made at this time.
Local candidates preferred but not required. No more than one subcontractor between the candidate and the presenting vendor.
Complete Description
The SQL Server Report Developer will work as part of the Arkansas Center for Health Improvement (ACHI) Data Team reporting to the Director of Information Services Architecture. They will be primarily responsible for developing predefined SQL Server 2014 Reporting Services (SSRS) reports for the Arkansas All Payer Claims Database. The list of required reports includes but is not limited to:
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
| Skill | Required / Desired | Amount of years experience | Last Used |
| RDBMS on SQL Server 2014 | Required | ||
| Query Analyzer, Profiler, SQL MAIL, SQL Agent | Required | ||
| Warehouse/Reporting (SSAS, SSRS, Cubes, Data Marts, Fact and Dimension, ETL) | Required | ||
| Data Modeling Using Visio | Required | ||
| MDX, T-SQL,C# | Required | ||
| BI Studio/Visual Studio 2013+, TFS | Required | ||
| XML, ASP.NET,VB.NET, Testing, Data warehouse, SSAS, DBA, SFTP | Highly desired |
Feel free to contact me if you require further information or assistance.
Best Regards
Ryan Yog Sharma| ASK IT Consulting Inc.
33 Peachtree St., Suite 100 |Holtsville, NY 11742 |Phone: +1 631-649-1313 Ext- 4391|Fax: +1 631-803-4488
we are "Certified Minority Owned Business/Women Owned Business"
Ask IT Consulting is an equal opportunity employer. All qualified applicants, who are eligible for employment are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.
--
All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google Groups "Job Junction" group.
If you are a job seeker please join the group using the link http://groups.google.com/group/jobjunction/subscribe or you can join group or add Job Junction as your friend in Facebook (Search for Job Junction) or you can also follow my blog http://jobjunctionglobal.blogspot.com/
If you have any requirement to share please send the same with all job details, email ID to which the resume has to be sent to jobjunction@googlegroups.com and jobjunctionglobal@groups.facebook.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
---
You received this message because you are subscribed to the Google Groups "Job Junction" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobjunction+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/jobjunction.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment