Dear Candidate,
We have an urgent opening for *Junior SQL Developer /Report Developer *and I have sent you a job description ,Please go through it and let me know if you are comfortable with it and also send me your consultant’s updated resume ASAP. *Title: Junior SQL Developer /Report Developer* *Location: Cleveland, OH* *Duration: 6 Months * *Start : ASAP* *Job Description :* · The Report Developer works with customers and peers to design, develop, modify and test data marts and data models that meet the customer's needs. · This role collaborates with a small team of report writers and report developers to create and enhance clinical intelligence and business intelligence solutions. · The current report development platform includes Sunrise Clinical Analytics and SQL Server Reporting Services. · Develop requirements and specifications in coordination with Database Administration team and Architects for data marts and data warehouses to support clinical and business analytics. · Gather appropriate specifications for data collection and transformation requirements and build report prototypes rapidly and accurately. · Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources throughout the organization to support ad hoc reporting. · Designs, develops and supports "self-service" reporting options (i.e. building tabular data models). · Create functional and technical documentation including "as-built" documents, dashboard design specifications, operating manuals, release notes and security requirements for reports created and maintained. · Update documentation on an annual basis or when changes occur. · Writes stored procedures and indexes, and completes code reviews in conjunction with OBA and/or development team and provides guidance to reporting team members on their code development. · Perform quality assurance testing of reports and dashboards, and facilitate user acceptance testing (UAT) sessions. · Ensure quality of the reports prior to releasing to production. · Provides technical support in retrieving data from a variety of database types and languages utilizing T-SQL as may be required. · Perform quality assurance testing of reports and facilitates user acceptance testing (UAT). · Ensure quality of the reports prior to releasing to production. · Develops and maintains documentation templates and standards for documentation of data extraction and output specifications, reports and other requirements. · Proactively identifies and addresses scalability and performance bottlenecks to support data volumes. · Where appropriate, evaluate and recommend new tools in clinical intelligence, reporting, and analysis. · Bachelor's degree, in Computer Science, Computer Engineering, Business, Mathematics or related field, preferred. Clinical Informatics degree preferred · Requires a thorough understanding of complex large scale data models for healthcare clinical and business systems and the underlying associated processes. · Data warehouse experience with MS and IBM Bl stacks preferred. *Years of Experience*: · Minimum 3 years report development and analytics experience using Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) required. · 1+ years' experience in IT Healthcare desired. · Experience with data cube development and reporting is required. · Experience with Microsoft SSIS is required. · Knowledge and understanding of standardized Data Warehousing Concepts required. · Thorough understanding of stored procedures, T-SQL, functions, and SQL Queries required. · Must demonstrate ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports required. · Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. · Knowledge of programming languages MS SQL, .Net Framework and other related systems required. · Strong written and verbal communication skills are required. · Must have strong analytical skills with an ability to organize and communicate thoughts clearly. · Experience pulling data from many different types of databases for analysis including Microsoft SQL Server, Oracle, Sybase, and Microsoft Access is desired. · Experience with clinical analytic systems is desired. Experience with Sunrise Clinical Analytics desired. *Special Skills & Equipment Knowledge*: · Knowledge of MS Access · Data warehouse tools and database administration · Tableau · Cognos · Hadoop · Netezza Watson are a plus · Experience in Meditech and AllScript's EMRs very desirable, but not required. *Anupam Amita |* *Technical Recruiter* | *Apetan Consulting LLC* Tel: 201-285-8031 <201-448-3198> * 107 | Fax: 201-526-6869 | 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 [email protected] | www.apetan.com <http://www.facebook.com/Apetanconsulting> <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> <http://twitter.com/ApetanLLC> *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.
