Data Warehousing Developer

Utica National Insurance Group Albany , NY 12201

Posted 2 weeks ago

If you seek a truly outstanding employment experience, Utica National is the place for you. We are always looking for conscientious, customer-oriented people - whether you're a seasoned insurance professional or just starting out. We offer a supportive and friendly work environment that features a variety of career paths.

We offer challenging assignments, advancement opportunities, full benefits packages, competitive salaries, and a great work environment. We're big enough to offer the opportunities you need to be successful, but not so big that you'll get lost in the crowd.

Essential Function:

Responsible for analyzing, discovering, designing and developing Data solutions.

Duties and Responsibilities:

  • Design, test, implement and maintain highly scalable data management systems

  • Ensure systems meet business requirements and industry practices

  • Research opportunities for data acquisition and new uses for existing data

  • Integrate new data management technologies and software engineering tools into existing structures

  • Create custom software components (e.g. user defined functions, reusable components) and analytics applications

  • Employ a variety of languages and tools to integrate systems, improve data reliability, efficiency and quality

  • Collaborate with data architects, IT & BI team members on project goals


Bachelors degree in Computer System, Information System Technology or related field preferred

Continuing education in Big Data technologies preferred

Basic insurance knowledge or experience preferred


  • 2 + years of related work experience.

  • Should have sound SQL (PL/SQL or T-SQL) skills.

  • Experience with any ETL tool / SSIS is required, data modelling experience is preferred

  • Experience working with data tools like Toad / SQL Developer, SQL Server management studio

  • Knowledge on data storage, security, masking and governance

  • Experience on Microsoft Visual Studio, C#, JSON, HTML, XML is preferred

  • Exposure with any big data tools / technologies is desirable


We believe strongly that talented people are core to our success and are attracted to companies that provide competitive pay, comprehensive benefits packages, career advancement and challenging work opportunities. We offer a Comprehensive Benefits Plan for full time employees that include the following:

  • 401K plan

  • Medical coverage

  • Dental coverage

  • Flexible spending accounts

  • Vision care coverage

  • Paid Time-Off (PTO)

  • Paid Holidays

  • Paid Volunteer Day

  • Pay-for-Performance

  • Employee and Dependent life insurance

  • Disability insurance

  • Accidental death & dismemberment insurance

  • Discounts on automobile and homeowner's insurance

  • Tuition reimbursement

  • Employee Assistance Program (EAP)

  • Credit Union membership

  • Employees' Club


We offer both full and part time employment with the goal of providing work life balance to our talented workforce.

This is an exempt position. By applying for this position, you acknowledge that as an exempt employee, you should expect to find it necessary to work beyond your regular work schedule in order to fulfill the demands of the position. As such, in accepting our offer, you acknowledge and agree to fulfill this expectation.

As part of our hiring process, candidates must also pass a comprehensive background check and drug screen, additional screening for credit or MVR may be required for some positions.

Utica National is an Equal Opportunity Employer.

Apply now and find out what it's like to be a part of an amazing team, thrive in an exciting environment and work for a company you can be proud of. Once you complete your application, you can monitor your status in the hiring process by logging into your profile. A representative from our Talent Management Group will be in touch if you are moving forward. Candidates must meet company requirements on our online assessment test.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Datastage Developer

Best Analyticsllc.Com

Posted 2 days ago

VIEW JOBS 4/1/2020 9:29:16 PM 2020-06-30T21:29 <p><strong><strong>Functional Title: </strong></strong>Data Quality Developer (IBM QualityStage)</p> <p><strong><strong>Target Start Date: </strong></strong> 2/18/2020<br /> <strong><strong>Expected Assignment Duration: </strong></strong>Long term</p> <p> </p> <p><strong><strong>Position Description:</strong></strong></p> <p>Participate in the discovery and analysis phase.<br /> <br /> During the discovery phase carry out data analysis and create detail inventory the sources systems, underlying data elements, analyze and list out he known DQ Issues – both already resolved and yet to be resolved,<br /> <br /> Complete analysis, documentation, data pipelining, staging, remediation, cleansing, quality assurance, and publication of all in scope data<br /> <br /> Collaborate with the Data Migration team for actual data migration, data validation and system acceptance. Provide consulting support for data extract, stage, transform, and integrate the core data that is in- scope for delivery and access with the new solution.<br />  </p> <p> </p> <p><strong><strong>Mandatory Qualifications: </strong></strong></p> <p>The Data Quality Developer should have 84 or more months of experience, in this role, with a combination of the experience described in the job function/description below.<br /> <br /> • Hands on experience in delivering Data Quality projects of similar scale.  At least 2 projects. (in DMV DQ&SI There are 130 data stores involving over 200M master records, 2 Billion overall records that will need to be analyzed, prepared, and migrated).<br /> <br /> • Extensive experience in detail data analysis, data profiling, Data Quality assessment, DQ Remediation.<br /> <br /> • Hands on experience in IBM InfoSphere® QualityStage® , 2 years or more and IBM InfoSphere® DataStage® at least 2 years<br /> <br /> • Knowledge of whole IBM Information Server suite (Information Analyzer, Governance Catalog, DataStage, QualityStage etc.)<br /> • Ability to guide and advise clients in Data Management and Governance approaches, strategies, and best practices<br /> • The qualified candidate will be required to partner with key stakeholders to provide Data Quality assessment services.<br /> • Able to provide solutions for implementing and using the Information Server suite to attain customers data governance goals.<br /> • Experience with data quality considerations, lineage etc.<br /> • Experience in customizing the templates for effective inventory management of DQ issues, related remediation, communication and acceptance.<br /> • At least 2 years of experience delivering Data Quality projects within an Enterprise organization<br /> • At least 2 years of experience with IBM Information Governance Catalog<br /> • At least 3-5 years of experience with IBM Information Analyzer in writing rules, configuration and profiling data<br /> o Experience analyzing data sets or data results (e.g. profiling results, results reporting) to draw inferences and identify adherence, or lack thereof, to business requirements<br /> o Create projects, add data sources, write, configure and execute rules/rule sets within Information Analyzer<br /> o Develop data profiling solutions, run analysis jobs and view results, and create and manage data quality controls using Information Analyzer<br /> o Demonstrate knowledge of Information Analyzer administrative tasks such as managing logs, schedules, active sessions and security roles etc.<br /> o Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis<br /> o Articulate data findings in a manner that is understandable to a business team. Also, they will need to work with the business team to confirm or modify requirements and rules based on the findings<br /> o Identify opportunities in processes, system capabilities and delivery methodologies for continuous improvement as applicable<br /> • At least 2 years of experience with IBM InfoSphere QualityStage<br /> o Experience in developing Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators<br /> • At least 5 years of experience with IBM InfoSphere DataStage<br /> o Experience in handling pipeline and partition parallelism for improving performance<br /> o Production problem solving experience using Peek, Row Generator and Column Generator Stages<br /> o Experience in handling job sequences and job schedules to automate the ETL processes.<br /> o Experience in handling feeds using multiple data sources such as z/OS DB2, MS SQL Server, Complex Flat Files, Delimited Files and XML files<br /> o Experience in performance tuning and methodologies in DataStage<br /> <br /> Basic Skills Required<br /> • Experience with MS Office products (MS Office,<br /> • Visio and Project experience<br /> • Scripting - DOS/PowerShell/Unix Shell Scripting<br /> • Experience with data quality tools<br /> • Ability to write data rules using pseudo code</p> <p> </p> <p><strong><strong>Desired Qualifications: </strong></strong></p> <p>Qualifications<br /> • Expert level experience in Data Quality Design and Development, best practices and processes<br /> • Experience with Other ETL/ELT technologies (Informatica, Pentaho, SSIS, Etc.)<br /> • Experience in Data integration, data architecture and, project life cycle Phases, best practices and processes<br /> • Strong data modeling (Relational Databases & Data Warehouse) and related technology skills (SQL etc.)<br /> • Experience working with other DQ tools.<br /> • Good understanding of Data Governance, MDM.<br /> • Exposure to the latest technologies and frameworks in DQ.<br /> • Experience with data lakes<br /> • Strong written and verbal communication skills<br /> • Experienced presenter<br /> • Agile project management experience required<br /> • Successful applicants will have strong interpersonal skills<br /> <br /> Preferred Skills and Education<br /> • IBM z/OS MVS COBOL, JCL, ISPF<br /> • Ability to conduct analysis on the data using database querying, excel, and other methods<br /> • Windows Server 2016<br /> • ETL experience using SQL Server 2008, 2012, 2014, & 2016 as source or destination<br /> • InfoSphere Information Server 11.7.1 or newer<br /> • InfoSphere Information Server Microservices Architecture<br /> • Master’s degree in Computer Science or related field.<br /> • Background in data analytics<br /> • Certifications in Data Modeling</p> Best Analyticsllc.Com Albany NY

Data Warehousing Developer

Utica National Insurance Group