ETL with SSIS job vacancy in Farmington, Connecticut Spar Information Systems

Vacancy expired!

Role Summary:-Designs and develops complex and large scale data structures and pipelines to organize, collect and standardize data to generate insights and addresses reporting needs.-Writes complex ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.- Collaborates with BI Data Scientists to transform data and integrate algorithms and models into automated processes.-Develop frameworks, standards & reference material for architecture and associated products.-Designs data marts and data models to support Data Science and other internal customers.-Behaves as mentor to junior team members to provide technical advice.-Applies knowledge of Aetna systems and products to consult and advise on additional efforts across multiple domains spanning broader enterprise.-Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.-Experiments with available tools and advises on new tools in order to determine optimal solution given the requirements dictated by the model/use case.

Required Qualifications-Advanced knowledge in MSSQL Server and/or DB2, SSIS, Microsoft .Net Framework, ASP, C#, Visual Studio, SAS, & SQL or similar.- Hands on Experience in SSRS, Crystal Reports , SAS or other report builder tools.- Strong programming skills in Python, Java or any of the popular scripting languages to build robust data pipelines and dynamic systems-Advanced knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.- Knowledge on Cloud architecture and Cloud Db setup on Google Cloud Platform, AWS or Azure.-Experience building and implementing data transformation and processing solutions.-Prior Database modeling experience preferred.- Strong collaboration and communication skills within and across teams. - Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources.- Ability to understand and build complex systems and solve challenging analytical problems.-Multiple years of progressively complex related experience.

Preferred Qualifications- Experience with data visualization tools preferred.- Working knowledge of Star Rating methodology and Data preferred.

Vacancy expired!

ID	#19827951
State	Connecticut
City	Farmington
Job type	Contract
Salary	USD Depends on Experience Depends on Experience
Source	Spar Information Systems
Showed	2021-09-18
Date	2021-09-17
Deadline	2021-11-15
Category	Architect/engineer/CAD
Create resume

Job Details

ETL with SSIS