Data Warehouse Analyst

3 weeks ago

West Des Moines, United States CareerBuilder Full time

JOB SUMMARY
The Data Warehouse Analyst will analyze and assist with the development of ETL Environments and Systems and provide production support for Data Warehouse and the ODS across all business units. This role uniquely has a close working relationship with our back of house departments including but not limited to: Risk Management, Finance, Accounting, Marketing, and IT. This role will be heavily involved in implementing new solutions as the business requires, while also driving to improve existing processes and improve overall data veracity and data velocity. As such, this role requires analytical skills, problem solving and knowledge of business system functionality that can be applied to data, with a focus on financial systems.
RESPONSIBILITIES
Assists with the development lifecycle, including identifying and implementing solutions, providing support for Business Analytics, Finance, Accounting, Risk, IT, and Marketing Teams.
Assists with the Maintenance and enhancements to the existing operational data store used to support the companys primary lines of business.
Assists with involvement in designing and implementing new data source integrations as demand from the business dictates. Including from a variety of source systems with varying connection criteria and requirements.
Work with Management and Team leadership to identify key inefficiencies in our global data environment and work with primary stakeholders to improve data availability and quality where business needs dictate.
Work with Manager of ETL and Office Technology to provide support and guidance to Accounting and Finance with their GL processes.
Work with team leadership to further support backend data logistics, compliance, legal, and ethical requirements pursuant to the companys goals and objectives. Such as: Loan-Tapes, Fraud/Risk Reporting, ACH automations, payment tracking, and other initiatives as they become relevant.
Create, test, and deploy additional data integrity processes. When issues arise, troubleshoot and correct data and load errors on a regular basis.
Support system maintenance, security upgrades and disaster recovery efforts
All other tasks and duties as assigned related to the position.
QUALIFICATIONS
Completed Associates Degree, Bachelors Degree or equivalent from an accredited university or a combination of post-secondary education and work experience
A minimum of 2 years experience with ETL and data warehousing at a finance company or bank
A minimum of 1 years worth of MSSQL, SSIS, and SQL development and/or implementation required
Experience with Accounting and Finance is a strong plus.
Experience with Dynamics 365 Business Central is a strong plus.
A working knowledge of Python is required.
Effective individual contributor and team player
Proficient with Microsoft Office Suite
KNOWLEDGE AND SKILLS
Demonstrated ability to build relationships, work collaboratively, and resolve problems with people at all levels across the organization, across lines of business and with third party vendors
Solid knowledge of practices, procedures, and principles in software development and able to interpret, analyze and document complex concepts and apply these in innovative ways
Ability to build and help manage processes for all stages of the development lifecycle, and instill controls to maintain an effective UAT and production environments
Strong understanding of business processes for loan originations and servicing
Judgment and problem-solving skills sufficient to analyze information to formulate recommendations to problems
Proficient in self-planning skills to schedule, organize and manage multiple activities of varying complexity according to established plans and adjusting work schedules according to changing priorities and time constraints
Ability to work ethically without constant supervision, and a need to have a strong sense of responsibility.
Well-developed analytical skills with strong attention to detail
Excellent Interpersonal, negotiation and mediation skills
Good judgment skills and ability to make sound decisions
Ability to perform in a fast-paced office environment
Flexibility and ability to work overtime
Previous experience in Salesforce a plus
Proficiency with the concepts related to: Data Management, Data Pipelines, Change Tracking, Operation Data Stores, and Azure Platforms
A Working Knowledge of Stored Procedures and SQL Data types

#J-18808-Ljbffr

  • Remote Business Systems Analyst

    7 days ago

    Des Moines, United States Cerebra Consulting Inc Full time

    Job DescriptionJob DescriptionBusiness Systems Analyst (Data Healthcare)REMOTEExperience Needed:5+ years as a Business Analyst, eliciting requirements, writing user stories, working with stakeholders.5+ years of data analysis or equivalent work experience Specifically, successful candidates are going to need to have strong experience joining tables and...

  • Business Systems Analyst

    5 days ago

    Des Moines, United States Compunnel Full time

    Description: Experience Needed: 5+ years as a Business Analyst, eliciting requirements, writing user stories, working with stakeholders. 5+ years of data analysis or equivalent work experience Specifically, successful candidates are going to need to have strong experience joining tables and writing queries, as well as having a keen eye for identifying...

  • Data Analyst

    1 week ago

    Des Moines, United States Diverse Lynx Full time

    Job Qualifications: Over 8 years of proven track record in business system data analysis and progressive responsibilities Proficient in working with financial accounting, Annuity insurance data, and Pension Risk Transfer (PRT) data Strong command of SQL Awareness of Github, AWS Cloud Fundamentals, AWS S3, AWS Athena is preferred Proficiency in business...

  • Data Management Analyst

    5 days ago

    West Des Moines, United States Motion Recruitment Full time

    Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Data Management Analyst in West Des Moines, IA (Hybrid). Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package! Our client has been around...

  • Defined Benefit Data Management Analyst

    4 days ago

    Des Moines, United States The Principal Financial Group Full time

    Do you have strong Defined Benefit knowledge? Strong attention to detail? Do you like to solve problems? If so, check out this great opportunity to join our Defined Benefit Data Management team. As a Defined Benefit Data Management Analyst, you will Management, Analyst, Data, Skills

  • Lead Data Analyst

    1 week ago

    Des Moines, United States Mindlance Full time

    Job Description:Project Description:• Business to Business survey is part of voice of the customer initiative, we already integrated almost close 20 systems with third party vendor to send customer invitation and persist customer feedback about product and service that we provide. I am expecting candidate to bring extensive data analysis skill. Required...

  • Lead Data Analyst

    1 week ago

    Des Moines, United States Mindlance Full time

    Job Description:Project Description:• Business to Business survey is part of voice of the customer initiative, we already integrated almost close 20 systems with third party vendor to send customer invitation and persist customer feedback about product and service that we provide. I am expecting candidate to bring extensive data analysis skill. Required...

  • Data Management Analyst

    6 days ago

    Des Moines, Iowa, United States Motion Recruitment Full time

    Outstanding long-term contract opportunity A well-known Financial Services Company is looking for a Data Management Analyst in West Des Moines, IA (Hybrid).Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package Our client has been around for...

  • Business Quality Analyst

    3 weeks ago

    Des Moines, United States TEKRRA1 Full time

    Job DescriptionJob DescriptionIowa Department of Management/Division of IT is seeking a local Business Analyst/Quality Analyst to support Iowa Workforce Development Unemployment Division with high profile modernization efforts.Complete Description:The client has requested local resources for this position. This position requires the contractor to be onsite 2...

  • IA-DOM-HHS-DBA4-IBHRS Data Analyst

    1 week ago

    Des Moines, United States HexaQuEST Global, Inc. Full time

    Job Description: The HHS Division of Behavioral Health is seeking a Data Analyst This position is for a Data Analyst for the Iowa Behavioral Health Reporting System (IBHRS) within the Bureau of Services, Planning and Performance in the Office of Data Analytics and Reporting. This position will be responsible for data quality of the Iowa Behavioral Health...

  • Business Quality Analyst

    3 weeks ago

    Des Moines, Iowa, United States TEKRRA1 Full time

    Iowa Department of Management/Division of IT is seeking a local Business Analyst/Quality Analyst to support Iowa Workforce Development Unemployment Division with high profile modernization efforts. Complete Description: The client has requested local resources for this position. This position requires the contractor to be onsite 2 days/week. The client,...

  • VP Data

    3 weeks ago

    West Palm Beach, United States Global Data Network Full time

    The Head of Analytics will be a key leader within the organization, responsible for driving data-driven decision-making and strategic initiatives. This individual will play a crucial role in shaping the analytics strategy, building a high-performing analytics team, and leveraging data insights to fuel growth and innovation in the InsureTech space. Key...

  • VP Data

    8 hours ago

    West Palm Beach, United States Global Data Network Full time

    The Head of Analytics will be a key leader within the organization, responsible for driving data-driven decision-making and strategic initiatives. This individual will play a crucial role in shaping the analytics strategy, building a high-performing analytics team, and leveraging data insights to fuel growth and innovation in the InsureTech space. Key...

  • VP Data

    4 weeks ago

    West Palm Beach, United States Global Data Network Full time

    The Head of Analytics will be a key leader within the organization, responsible for driving data-driven decision-making and strategic initiatives. This individual will play a crucial role in shaping the analytics strategy, building a high-performing analytics team, and leveraging data insights to fuel growth and innovation in the InsureTech space. Key...

  • Senior Data Architect

    4 weeks ago

    Des Moines, United States JSM Consulting Full time

    Extensive background in data governance policies and standards - Required 10Years Experience with data dictionaries data catalogs and/or other metadata management solutions - Required 10Years Experience designing/architecting business intelligence/reporting platforms - Required 10Years Experience integrating data from multiple systems built using...

  • Senior Data Architect

    4 weeks ago

    Des Moines, Iowa, United States JSM Consulting Full time

    Extensive background in data governance policies and standards Required 10Years Experience with data dictionaries data catalogs and/or other metadata management solutionsRequired 10Years Experience designing/architecting business intelligence/reporting platformsRequired 10Years Experience integrating data from multiple systems built using heterogeneous...

  • Data Analyst

    7 days ago

    West Conshohocken, United States Allspire Health Partners LLC Full time

    **Data Analyst** **Position Overview**: The Data Analyst reports to the Finance & Operations Department and supports AllSpire Health Partners (“AHP”), AllSpire Health GPO (“AHGPO”), their clinical and value analysis committees, supply chain leadership and sourcing staff through a comprehensive understanding of supply chain and business analysis. The...

  • Data Analyst-CCBHC-Eyerly Ball

    4 weeks ago

    Des Moines, Iowa, United States UnityPoint Health Full time

    Overview: As a member of the Certified Community Behavioral Health Center team, the Data Analyst will be responsible for providing leadership data insights and provide information regarding key clinical, organizational, and financial metrics.   The Data Analyst will utilize knowledge of data acquisition, management, analysis, and interpretation to provide...

  • Immunization Data Analyst

    4 weeks ago

    Des Moines, United States JSM Consulting Full time

    Duties & Responsibilities Moderate to expert understanding of data systems data integrity and data validation - Required 8Years Proficient in Microsoft Excel with the ability to do advanced data manipulation - Required 8Years Experience with Coding in Python - Required 8Years Experience in developing data for analysis - Required 8Years Excellent...

  • Immunization Data Analyst

    4 weeks ago

    Des Moines, Iowa, United States JSM Consulting Full time

    Duties & Responsibilities Moderate to expert understanding of data systems data integrity and data validation Required 8Years Proficient in Microsoft Excel with the ability to do advanced data manipulationRequired 8Years Experience with Coding in PythonRequired 8Years Experience in developing data for analysisRequired 8Years Excellent Communications...