Data Analyst II

4 days ago


St Louis, United States Compu-Vision Consulting Full time

Job Title: Data Analyst II

Duties:
1-year contract with possibility of conversion or extension - conversion salary of (USD)70,000-(USD)95,000 USD will be confirmed at time of FTE offer.
DETAILED data warehouse and SQL knowledge required.
Data warehouse is very complicated and must have extensive experience.
Some understanding of data warehouse development with QA experience would be preferred.
Experience using Cognos extracts required.
Prefer local applicants, but we are open to remote for the right candidate.
This is a 100% work-from-home position, with expectation of monthly in-person meetings (for local people).
Equipment will be provided.
We are seeking a detail-oriented Data Warehouse and Business Intelligence Quality/Data Analyst to ensure the quality and reliability of our student data warehouse systems. The ideal candidate will have a robust understanding of databases, ETL processes, and data validation techniques. This role involves performing data quality assessments, creating and executing test cases, and collaborating with the development team to optimize data integrity and performance.
Perform Quality Assurance: Develop and execute comprehensive test plans and test cases designed to detect issues in data warehousing systems.
ETL Testing: Validate ETL processes, ensuring that data is correctly extracted, transformed, and loaded into the data warehouse.
Report, dashboard and semantic layer testing in tools like Cognos and Tableau.
Data Validation: Conduct data quality checks to verify accuracy, consistency, and completeness of data.
Automation: Develop and maintain automated testing scripts for data validation and ETL processes.
Collaborate: Work closely with Data Engineers, Developers, Business Analysts, and other stakeholders to understand requirements and resolve any data quality issues.
Defect Tracking: Log, track, and report defects and work with development teams to ensure timely resolution.
Documentation: Maintain comprehensive documentation of test plans, test cases, and testing procedures.
Compliance: Ensure data warehouse processes comply with departmental standards.

Skill:
SQL and Data Warehouse coding experience a plus.
Above average Microsoft Word/Excel skills and an understanding of XML.
Understanding of star schema and data warehouse structures like tables, indexes, facts, dimensions and bridge tables.
Report Writing experience in Cognos is preferred.
Knowledge of Tableau/PowerBI is a plus but not required.
Evaluating and analyzing data related to business requirements.
Prior experience in a higher education technology environment is a PLUS.
Designing and executing the test scripts and test scenarios.
Coordinating with other team members during testing, validating, and evaluating new applications and functions.
Ability to extract data from a data warehouse and use comparative analysis to confirm data quality.
Demonstrated aptitude to quickly and effectively adapt to technologies outside of current experience.
Strong communication and collaboration skills, with the ability to work as part of a team and independently.
Engaged in continuous improvement of internal processes and procedures.
Ability to work with only minimal supervision.
Ability to work extra hours and recognize the need to do so.
Assist Data Team with defining and documenting Common Business Data Definitions
Possesses sound analytical problem-solving and documentation skills.
Communicates effectively with users.
Demonstrates ability to prioritize conflicting demands.
Executes assigned project tasks within established schedule.
Demonstrates enthusiasm and commitment toward the job and mission of the organization.
Must be self-starter and able to solve complex problems and analysis without supervision.

Education:
Bachelor's degree in a technical discipline such as Computer Science, plus 2 years relevant technology experience or equivalent combination of education & experience.
5 years relevant technology experience

Languages:
English( Speak, Read, Write )

Minimum Degree Required:
Bachelor's Degree

Postal Code: 63110
Start Date: 11/11/2024

Hours Per Week: 40.00
Hours Per Day: 8.00
Days Per Week: 5.00


  • Data Analyst II

    4 days ago


    St Louis, United States HonorVet Technologies Full time

    Job Title: Data Analyst II Location: St. Louis, MO Duration: 12 months w/ possible extensions thereafterJob Description:Role Summary/Purpose: DETAILED data warehouse and SQL knowledge required. Data warehouse is very complicated and must have extensive experience. Some understanding of data warehouse development with QA experience would be preferred....

  • Data Analyst

    4 days ago


    St Louis, United States Apex Systems Full time

    Data Analyst opportunity in the Saint Louis area. Looking for people that are strong with SQL (querying, creating stored procedures, troubleshooting data, etc). Ideally have worked within a database or data warehouse. Role is M-F day shift, hybrid based (3 days onsite and 2 days remote), and long term contracting position, with potential for full time...

  • Financial Analyst II

    4 months ago


    St. Louis, United States Adaptive Solutions Group Full time

    Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City and St. Louis areas.We are currently looking for an Financial Analyst II to join our team.Responsibilities...

  • Data Quality Analyst

    2 weeks ago


    St Louis, United States Safety National Full time

    Stop searching. Start growing. It's time to build a meaningful career where you can grow, your ideas can thrive, and you are recognized and valued. Join a team committed to your excellence, and apply to Safety National today! This opportunity is in the Business Intelligence & Planning Department. Role Description In the role of Data Quality Analyst, you will...


  • St Louis, United States Safety National Full time

    Description Stop searching. Start growing. It's time to build a meaningful career where you can grow, your ideas can thrive, and you are recognized and valued. Join a team committed to your excellence, and apply to Safety National today! This opportunity is in the Business Intelligence & Planning Department. Role Description In the role of Data Quality...

  • Cyber Data Analyst

    1 day ago


    St Louis, United States Abile Group, Inc. Full time

    Overview: Abile Group has an exciting and challenging opportunity for a Cyber Data Analyst on a contract providing Network and Cybersecurity services supporting an Intelligence Community customer. All the personnel on the team will work together to support transport and cybersecurity information technology (IT) services on multiple networks and security...

  • Data Analyst

    3 weeks ago


    St. Louis, United States Hubbell Incorporated Full time

    Job OverviewAs a Data Analyst Intern you will be using databases to turn data into information, information into insight and insight into business decisions.The Hubbell Summer Internship Program is a 10 to 12-week program providing students the opportunity to gain corporate experience, learn about all aspects of our business, and prepare students with the...

  • Data Analyst

    3 weeks ago


    St. Louis, United States Hubbell Incorporated Full time

    Job OverviewAs a Data Analyst Intern you will be using databases to turn data into information, information into insight and insight into business decisions.The Hubbell Summer Internship Program is a 10 to 12-week program providing students the opportunity to gain corporate experience, learn about all aspects of our business, and prepare students with the...

  • Sales Data Analyst

    3 weeks ago


    St Louis Park, United States nVent Full time

    We’re looking for people who put their innovation to work to advance our success – and their own. Join an organization that ensures a more secure world through connecting and protecting our customers with inventive electrical solutions. WHAT YOU WILL EXPERIENCE IN THIS POSITION: The Sales Operations Analyst is responsible for the collection, analysis and...

  • Data Analyst

    2 days ago


    St Peters, United States Envision Full time

    Data Analyst All potential applicants are encouraged to scroll through and read the complete job description before applying. Position Overview: We are looking for a detail-oriented Data Analyst with expertise in data quality and business intelligence to support our data systems. The ideal candidate will have a strong understanding of databases, ETL...


  • St Louis, Missouri, United States Lange Company Full time

    Job OverviewLange Companies is a dynamic organization driven by integrity, dedication, and ambition to deliver business intelligence solutions that drive results.We are seeking a highly skilled Business Intelligence Data Analyst Lead to join our team in St. Louis, MO.


  • St Louis, United States Ledgent Technology Full time

    National Mortgage Lender is seeking a Mortgage Business Support Analyst for a contract to hire role in St, Louis, MO!$25-27/hr W2Responsibilities:The Mortgage Business Support Analyst II provides support in managing a broad variety of departmental operations including special projects, strategic planning process and initiatives, and conducting data...


  • St Louis, Missouri, United States Masego Full time

    Job DescriptionMasego, a Service-Disabled Veteran-Owned Small Business, is seeking an experienced Senior TS/SCI-cleared Data Analyst to join their team in St. Louis, MO.As a key member of the team, this Data Analyst will lead the design and application of methods to identify, collect, process, and analyze large volumes of data to build and enhance products,...


  • St Louis, Missouri, United States National Archives and Records Administration Full time

    Job Summary">We are seeking an experienced Management Analyst to join our team at the National Archives and Records Administration. This is a challenging role that requires strong analytical skills, business acumen, and excellent communication abilities.">About the Role">The successful candidate will conduct management studies, audits, analyses, reporting,...


  • st. louis, United States Apex Systems Full time

    Data Analyst opportunity in the Saint Louis area. Looking for people that are strong with SQL (querying, creating stored procedures, troubleshooting data, etc). Ideally have worked within a database or data warehouse. Role is M-F day shift, hybrid based (3 days onsite and 2 days remote), and long term contracting position, with potential for full time...


  • St Louis, Missouri, United States Masego Inc Full time

    About the RoleWe are seeking a Senior-level TS/SCI-cleared Data Scientist to join our team at Masego Inc. This position will involve leading the design and application of methods to identify, collect, process, and analyze large volumes of data to build and enhance products, processes, and systems. The ideal candidate will have about 10 years of relevant...

  • Data Analyst

    1 week ago


    St Louis, Missouri, United States Lifelancer Full time

    Job Overview: We are seeking a highly skilled Data Analyst to join our team as a Clinical Transformation Specialist.Company Overview: Lifelancer is a leading talent-hiring platform in Life Sciences, Pharma, and IT. Our platform connects professionals with opportunities in pharma, biotech, health sciences, healthtech, and IT domains.Salary: The estimated...

  • Data Systems Analyst

    4 weeks ago


    St. Louis, United States Envision LLC Full time

    Systems AnalystOverview:We are seeking a Systems Analyst to join our team supporting the Customer Configuration Management (CCM) program. The role involves Level 2 support for production issues related to customer authorization and transaction clearing. This position will work closely with internal teams to resolve escalations, troubleshoot technical issues,...

  • Sr. BI Data Analyst

    1 month ago


    St. Louis, United States Nestl Purina North America Full time

    We re a leader in the pet care industry, which means we re not only ahead in volume, profit and market share, but our associates dare to Stand Taller. We innovate new products, impart new agilities into existing processes, constantly advance pet nutrition, and always pay it forward in the form of service for our communities and families. Are you up for the...


  • St Louis, Missouri, United States Masego Full time

    About the RoleWe are seeking an experienced Senior Geospatial Data Analyst to join our team at Masego, Inc. As a key member of our GEOINT services division, you will play a vital role in providing expert-level geospatial support services to government and contractor teams.Job SummaryThis is a journeyman-level TS/SCI-cleared position that requires a strong...