Data Warehouse Developer

Data Warehouse Developer

Richfield, MN, 55423

8 + Months – Long Term

5-10 years experience – OLAP/DSS/Data mining, designing and developing enterprise-wide repositories utilizing SQL-based data base products including DB2, SQL Server, Oracle, Sybase and other decision support systems/expert systems. Defines requirements and tools to interface all legacy data.

Define usage of queries/reporting tools to support, analyze large volumes of information within corporate data warehouse.

Experience with ETL tools(preferably Informatica, power center, Developer, power exchange), Relational databases(Oracle, SQL Server etc).

Experience with HDFS, hive and big data tools(spark, scala, sqoop etc preferable). Any scripting and cloud experience is a plus.

Quick learner and ability to handle multiple project independently/with minimal guidance

AS400 System Admin

Job Title:        AS400 System Admin
Location:        St. Petersburg, FL
Duration:       12+ Months

Job Description:
Experience working in AS400 administration in TCP/IP networked environment required.
Must have in-depth knowledge of AS400 hardware and software.
Proficient in AS400 LPARs, HMC, OS/400 (IBM i v7.x), IBM BRMS, CL and iSeries Navigator. Experience of Aldon LMI and Halcyon Messenger or similar software is a plus.
Hands-on knowledge of Microsoft Windows environments, including Windows 10, Windows CE/Mobile and Client Access for Windows.

Quantitative Analytics Specialist

RESPONSIBILITIES:

  • Design, develop, and deploy AI/ML models using state of the art techniques available in the open stack (Python/PySpark/PyTorch) and/or vendor solutions
  • Partner with LOB leads to frame the problem, explore various ML/DL model architectures and methodologies, generate required artifacts related to model development life cycle (MDLC), author the model development document, and deliver AI models that meet business needs
  • Adhere to corporate model risk policy and ensure compliance with model risk management
  • Working with other data science teams to identify, gather, retain, and publicize modeling artifacts required for approved and repeatable processes
  • Work with AI technology and production teams to operationalize models
  • Work effectively in an agile project management methodologies for data science
  • Knowledge sharing with members of the team and across the organization on topics including machine learning algorithms, hyper-parameter tuning/search, and traversing across multiple big data platforms
  • Contribute to the CoE data science team’s group effort to stay current with the cutting edge NLP/ML/DL algorithms, methodologies in the open source community and vendor solutions.

Required Qualifications

  • 4+ years of experience in an advanced scientific or mathematical field
  • A master’s degree or higher in a quantitative field such as mathematics, statistics, engineering, physics, economics, or computer science
  • 4+ years of statistical modeling experience
  • 3+ years of Python experience
  • 2 + years of experience using quantitative machine learning techniques

Desired Qualifications

  • 2+ years of Hadoop experience
  • 1+ years of Natural Language Processing (NLP) experience

Other Desired Qualifications

  • Hands on familiarity with machine learning and statistical modeling techniques applying machine learning techniques such as neural networks, random forest, GBM and SVM, Probabilistic Graphical Models, Deep Learning architectures, using open-source languages like Python, PySpark and/or PyTorch.
  • Experience with model monitoring and performance tracking
  • Hands on experience with deep learning toolkits such as Tensorflow, Keras, PyTorch, Dynet
  • Hands on experience writing data processing and data pipeline for model development including gathering and building datasets to collect intents, joining and aggregating source datasets, cleaning messy data, designing feedback loop on data needs
  • Experience building intent recognition and classification models. Experience with phrase level identification. Experience with language models such as BERT, ELMO, CRF
  • Experience with active learning and reinforcement learning
  • Experience with AI model transparency and explainability studies
  • Strong acumen in diagnosing and resolving data issues
  • Exceptional analytical, critical thinking, quantitative reasoning skills, and problem-solving skills. 

Analytic Consultant

Responsibilities:

  • Lead and/or support development of hierarchical categorization taxonomies using NLP unsupervised/supervised methodologies including enrichment of unstructured data to derive themes and trends, with specific focus on early identification of emerging themes.
  • Develop non-model and model development to generate actionable insights and uncover patterns (structured or unstructured) from multiple sources, while working in partnership with teams across Conduct Management.
  • Perform text analysis and advanced analytics including using Natural Language Processing, Machine Learning techniques and programming languages to derive relevant analysis and metrics, including building proof of concepts to determine value of implementing in future projects.
  • Collaborate with team to develop data driven analytics capabilities to identify anomalies, outliers, emerging trends and conduct risks across the Enterprise. Primary areas of focus include Internal Fraud, Sales Practice, Ethics, and allegations
  • Collaborate with team to design complex projects/analyses generally spanning multiple products/business lines/functional areas/data sources including analytical application of industry-leading experimental techniques or exploratory data analytics to support teams across Conduct Management.
  • Partner with other Conduct Management and LOB stakeholders to develop, and enhance analytical capabilities related to Conduct Management’s first line of defense
  • Offer strategic recommendations to senior stakeholders and leadership based on thought-provoking and sound analytics including communicating technical and business details to ensure understanding.

Required Qualifications

  • 6+ years of experience in one or a combination of the following: reporting, analytics, or modeling; or a Masters degree or higher in a quantitative field such as applied math, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis and 4+ years of experience in one or a combination of the following: reporting, analytics, or modeling
  • 2+ years of Python experience
  • 2+ years of Natural Language Processing (NLP) experience
  • 2+ years of statistical modeling experience

Desired Qualifications

  • Extensive knowledge and understanding of research and analysis
  • Strong analytical skills with high attention to detail and accuracy
  • Excellent verbal, written, and interpersonal communication skills
  • Experience with design, implementation and governance with Artificial Intelligence, Natural Language Processing or Machine Learning Architecture
  • Knowledge and understanding of analytical methods used in: statistics or predictive modeling methods (regression modeling, clustering, pattern recognition, graphics)
  • 2+ years of Tableau experience

Other Desired Qualifications

  • Model governance experience including writing model development documentation
  • Developing models to identify/detect emerging themes
  • Preprocessing (tokenization, part-of-speech tagging, parsing, stemming)
  • Semantic analysis (named entity recognition, sentiment analysis)
  • Modeling and word embeddings/representations (RNN / ConvNets, TF-IDF, LDA, Word2Vec)
  • Working with data science analytic tools (Watson Studio, Watson Discovery, IBM SPSS Modeler, Data Robot)
  • Experience with Tableau for data visualization
  • Expert ability to create compelling presentations in Power Point for executive level audiences
  • Experience in fraud, BSA/AML, investigations of financial crimes transactions or policy violations, risk management or compliance
  • Analytical and detail oriented with the ability to prioritize, execute and deliver projects on time
  • Strong desire and ability to independently solve problems and self-prioritize multiple tasks

Job Expectations

  • Ability to travel up to 10% of the time

Data Modeler/Architect

Position:  Data Modeler/Architect

Location:  Glastonbury, CT

Job Type:  Contract

Job Description

7+ years in IT with 5+ years in depth experience in relational design (E-R)/star schema/dimensional modeling/no-sql modeling,

• Must have 3-4 years of hands on experience on ERWin or hackolade

• Experience with modeling the overall data architecture, e.g., Data Integration/ETL process,

• ODS, Data Marts design

• Prepare process models in accordance with the guidelines/conventions of designated process modeling methodology, includes creation and maintenance of process descriptions and glossary of terms.

• Facilitate the exposure of process data from functional experts and the user community

• Provide mapping between existing processes and proposed replacement processes.

• Design and normalize the logical data model

• Develop and maintain the physical data model

• Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.

• Prepare fully refined data models in accordance with the guidelines/conventions of Integration DEFinition (IDEF) or equivalent methodology.

• Develop and manage data models and associated metadata for the enterprise.

• Experience on Orable & Microstragy will be added advantage • Experience on Data modelling, Data Warehousing, Data mapping, Business Collaboration, Reverse Engineering, AWS/Snowflake/MicroStrategy, Agile Methodologies

Business Systems Analyst

Title: Business System Analyst
Job Location: Glastonbury, CT
Duration-Long Term Contract

Job Description
Qualifications:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education and / or Experience:
•      Bachelor’s degree in Computer Science or Management Information Systems, or equivalent. 
•      10+ years of experience working in IT Business Intelligence and Data Integration development/support;
•      Very strong background in communications, process management, and overseeing JAD sessions;
•      Extensive experience in data warehouse requirements gathering and documenting;
•      Familiarity/experience reading requirements as documented in data models;
•      Familiarity/experience developing BI reports and/or dashboards;
•      Familiarity/experience with cloud data systems.
Knowledge and Skills:
Excellent data analysis and system analysis skills. Agile methodologies and insurance domain experience.,. Excellent written and oral communication skills.  Excellent iterative project management and team skills.

Job Purpose:
This role is responsible for leading data requirements for the new data warehouse. Responsible for conducting JAD sessions with business and IT resources and document functional and non-functional requirements. Responsible for documenting use cases, functional and non-functional requirements. Works directly with business/IT teams to capture and refine data and business requirements. Responsible for analyzing and reverse engineering systems as needed and drive requirement gathering process. Works collaboratively with technical and non-technical teams. Exceptional communication skills and prior experience with data warehouse requirement analysis is required. Experience with data mapping and data analysis is required. Insurance domain knowledge and experience with insurance data models preferred.

Data Quality Engineer

DATA Quality Engineer 
Location NY
 
•             3-5+ years hands on experience SQL and data testing
•             Hands on experience with writing SQL queries using joins, aggregate functions and stored procedures/ functions and general relational database access and query techniques with SQL Server 2012 or above, Oracle 11g
•             Excellent Communication and Client Interaction on daily basis for task progress and clarifications.
•             Flexible to work in different timings.
•             Rotational weekly support activity.

Data Stage Admin

Job Title: Data Stage Admin
Location: Chicago, IL
Duration: 12+ Months Contract

Job Description:
• BS/BA degree or equivalent experience
• Advanced knowledge of DataStage and related application, data and infrastructure architecture disciplines
• Understanding of architecture and design across all systems
• Working proficiency in developmental tool sets
• Ability to collaborate with high-performing teams and individuals throughout the firm to accomplish common goals
• 8 plus years’ experience as DataStage Admin and Hands on experience in:
• Installing and building new DataStage environment from Development to Production.
• Applying FixPacks
• Migration of servers from PSI and VSI
• Maintaining and monitoring the Linux DataStage servers.
• Provisioning of access to new users, controlling user access and licenses
• Platform designing, configuration and troubleshooting of VCS clusters
• Supporting of bug fixes and performance optimization.
• Understanding of deployment technologies
• Development experience for POCs will be a plus

DBA

Job Title: DA+DBA (Oracle with Nosql)
Location: Phoenix, AZ
Duration: Fulltime

Job description :

  Should have worked as an Oracle development dba for 10+ years.
·         Knowledge on Data Architecture (Data Modeling) is a must (ERStudio etc).
·         Should understand the concepts of database design.
·         Knowledge on Dataguard and should have worked on Oracle Golden Gate.
·         Hands on experience on Performance Tuning, OEM, Migrations/Upgradations.
·         SQL Developer experience (SP tuning, SP deployment etc)
·         Should know the CI/CD concepts on DB Deployment.
·         Knowledge on PostgreSQL is a plus.
·         Knowledge on Coucbase is a plus.
·         Knowledge on SQLServer is a plus.

AS400 Cobol Developer

Job Title:        AS400 Cobol Consultant /Developer
Location:        Cincinnati, OH 
Duration:       12+ Months

Job Description:
Exp…Level 5+ Years
• Good experience in AS400, SYNON, COBOL and basic knowledge of Java language.Good working experience on DB2 and SQL database
• Having experience of working in mission critical platform with BFSI background
• Excellent Technical, verbal & written communication skills.
• Good interpersonal skills & Analytical skills
• Good understanding about ITIL methodology and experience in support processes
• Must have strong interpersonal, planning, facilitation, negotiating, and organizational skills.
• Understanding and preferable experiences in DevOps