[Close] 

SQL Data Analyst

Data Analyst with Strong SQL ability and a reporting background

XXXXXX has about 30 million records in Microsoft SQL Server 2012 for internal use. This is the primary database and contains confidential data we process for our client contracts. We also populate and host a client s Tableau Server. Tableau knowledge is not required as we use Microsoft SQL to feed data to Tableau.

There is another Microsoft SQL Server 2012 server with a similar amount of records but a limited dataset for clients who access this data via a customized. NET web application. Delimited data is imported into SQL Tables using other applications. Ultimately, we will fully populate the SQL Server with all datasets and data elements.

We receive data in a variety of fixed format files from our editing. A Grouping process from 3M produces data in multiple fixed formats. We have two. NET developers with 25+ years' experience and enough Transact SQL and DBA to get by. We are Microsoft Partners and use Microsoft Server 2012 and Visual Studio 2008.

The optimal candidate is a self-motivated and disciplined problem solver with an impeccable work ethic for responsiveness and timely task completion. They are responsible for understanding, respecting, and safeguarding XXXXXX s collection of data. This candidate can give examples of overcoming adversity. They will be asked to provide quality examples of previous projects and their outcomes. Maintaining a safe, organized, and clean work environment is also required.

As a DBA, the candidate should provide structure and security for customized business applications in order to receive, edit, and prepare database information and create output reports. The candidate will design and maintain database, focused applications.

Regular phone/email/in person communication with management, colleagues, and clients regarding all stages of program designing and testing are critical. A strong working command of the English language is a must. The company holds an all-company status update conference call on the first Thursday of every month, followed by an in-person status meeting and lunch on the third Thursday of every month.

The company culture is one of mutual respect and cooperation. We believe the balance between work and life is important. We see our colleagues as professionals and expect them to behave and produce as such. A candidate may find themselves working on a project during normal business hours or at non-business hours; depending on the project. As such, the candidate should have enough flexibility and accountability to work until the job is complete -

RESPONSIBILITIES/DUTIES:

Design/Build/Maintain Microsoft SQL Server Database containing millions of healthcare related records (Design in and out and data manipulation)Uses coding methods for specific programing language to enhance or initiate efficient program execution and performance to reach optimum reporting utilizationCreates SQL data reporting information in preparation for client delivery

Monitors production environment for expected performance and responds to errors and emergency problemsWorks within specifications provided to meet assignment goals and objectives in a timely and accurate mannerTakes independent action to correct problems encountered during systems operations within authority level granted by Management and communicates actions takenMaintains integrity of program logic and coding; and establishes required checks and balances for operational controlsMaintains up-to-date knowledge of computer operating procedures and standards

9. Be prepared to attend and potentially lead company/client related meeting

Import Fixed and delimited Data into SQL Tables. These tables will based on State Specifications for current medical datasets we are required to create. Leverage this data in some type of reporting services and/or custom development using SQL development tools

Create Patient Level Detail data for client consumption

Create Summary Data for client consumption

Administrate the SQL Database at all levels. We have only two databases and one site to manage, so we do not need Super Duper dba skills here. Just enough to back up the database and do regular maintenance. Some programmers have very customized needs, will need to work with programmers and provide data to exact specifications

14. Sits and maintains focus for extended periods

Meets expectations for attendance and punctuality



Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Dynamics AX Functional Analyst - Rockville MD-...
Rockville, MD Nigel Frank International US
Expert SME Support Analyst
Bethesda, MD Perspecta
Data Center SME (Network and Storage Systems E...
Laurel, MD Perspecta
Computer Network Analyst - Entry to Experience...
Fort George G Meade, MD National Security Agency
Public Relations Analyst
Silver Spring, MD Leidos
BEHAVIORAL ANALYST - MONTGOMERY COUNTY CAMPUS
Silver Spring, MD Kennedy Krieger Institute