Job Description :
Role: MS SQL Server IT Data Analyst/Developer
Location: Hartford, CT
Duration: 12-18+ Months
Job Description:
Purpose: This section should contain a brief statement of the basic purpose of the position. (Consider position objectives and expected end results
Performs requirements and data analysis to develop Experian Data Archive process. Interacts with the customer to develop business rules. Understands and applies ETL methodology in creating processes to develop data marts, dimensional models, data integrations. Creates reports, cubes, and data extracts using various databases and reporting tools.
Functions: In the order of importance, please list the major tasks or duties performed regularly to fulfill the basic function of the position. Begin each accountability with an action verb (e.g., manages, implements, develops, evaluates, negotiates, determines In most circumstances, there should not be more than 8 major accountabilities.
Performs complex and thorough analysis of key metrics, identifies all source data, and develops efficient 3rd party data processing and analytic solutions
Understands ETL and Warehousing concepts and architectures. Designs and implements ETL processes. Designs and implements industry standard dimensional models. Designs and implements Data Quality processing
Develops analytic processes for new and existing analytics taking into consideration business requirements, reporting compliance and IT Controls, and other corporate requirements. Ensures all processes developed are completed and quality tested prior to release
Is expert with Microsoft SQL Server tool sets TSQL, SSIS, SSRS, SSAS and can employ these tools and others in developing reporting solutions
Can profile data with in house toolsets. Using data profiles, document detailed specifications and develop rules
Performs other duties as assigned by management.
Can troubleshoot data issues.
Can develop data models
Dimensions: List the accountabilities that define the degree of scope, financial impact, revenue, span of control (staffing/direct reports), expense, budget and/or approval authority for the position.
Education and Experience: List the preferred education and/or experience necessary to successfully perform functions of the position. Include position related experience, specialized training, certification, competencies or any special licensing necessary.
Bachelor’s degree or equivalent work experience
3 to 5 years data reporting experience preferably in an insurance environment
Knowledge And Skills: List the preferred specialized knowledge, skills and/or scope of related experience required to successfully achieve the functions of the position.
Advanced knowledge of SQL, HTML and database management
Analytical skills
Good communications skills (verbal and written)
Critical thinking skills
Attention to detail
Time management skills