Please see the below job req for a 6 month right to hire role in Durham, NC. If you are available, please respond with your word resume and the best time to contact you at lisatoth@f1solutions.com. Thanks!
Lisa Toth
Recruiting Dept.
F1 Solutions
704-819-1265
http://www.f1solutions.com
F1 HealthIT is a division of F1 Solutions, Inc
http://www.f1healthit.com
We’re looking for a driven, enthusiastic self-starter who has strong attention to detail and excels in building out data warehouse structures in a SQL Server environment. The right candidate will have a strong track record of building and supporting star schemas and cubes in SQL Server and building all of the processes that populate these structures with data from diverse source systems.
Responsibilities: Working closely with both the business and IT teams to design, build and support corporate data warehouses and processes that will be utilized in business reporting, analytics as wells as in support of Self-Service Web functionality and a large customer base.
Required
- 3-10 years of SQL Server Experience building and supporting Data Warehouse structures
- Experience building automated Extract Transform and Load (ETL) systems to process incoming data sources
- Experience building ETL processes to reconcile and standardize data and eliminate redundant data
- Build experience with Dimensional structures (OLAP, etc.) to support the delivery of data to reporting tools
- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
- All phases of the modeling process - research design, data extraction and cleaning, model building and validation.
- Develop and performance tune database solutions and integrate them into the . Net based web application
- Proficiency with writing stored procedures, triggers, and database jobs and the ability to provide database development assistance and code for software engineers
- Support end user reporting tools such as Microsoft Power Pivot, Power View, etc.
- SQL Server Integration Services experience (SSIS) to load and transform flat files, Exel, and Access from various sources into a database staging environment
- Experience building SSIS tasks to perform bulk inserts, execute packages, execut processes, FTPs, Send mails etc.
- Experience working with XML
- Strong SQL Coding experience including unions, correlated sub-queries etc. to extract and transform data.
- SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), OLAP cubes, Dimensions, Partitions, KPI’s and aggregation
- DBA experience including performance monitoring and tuning, daily process monitoring, and security administration, backups and recoveries.
- Microsoft BI Stack including Power Query, Power Pivot and Power View.
- Fast learner filled with curiosity
- B.S. Degree in Information Technology or equivalent
Preferred Qualifications
- M.S. Degree in Technology related field
- Experience with Insurance Applications
- Experience connecting MS Reporting to a Web applications in a self-service portal
- Strong communication and relationship building skills
- Experience working on a global team
- Microsoft C#.Net used to create SSIS modules using SSIS Script Component objects
- Experience backing up and recovering databases