Talent.com
Data Warehouse Analyst III

Data Warehouse Analyst III

MARS Solutions GroupWI, United States
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

MARS Solutions Group is looking for an experienced Data Warehouse located in Madison, WI. Our client is a government agency looking for high-quality talent to make a difference. They are known to respect a traditional work week and often extend contracts for added job security and stability.

Note : Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense. Position is nearly 100% remote, with 1-2 in person meetings in Madison, WI per year.

Top Required Skills & Years of Experience : 3-5 years of experience in the below

  • Prior experience in data warehousing or dashboarding projects (3-5 years)
  • Ability to create test plans and perform application, reporting and system regression tests
  • Ability to estimate phases of work and contribute to project planning, including experience writing user stories with clearly defined acceptance criteria.
  • Experience using relational databases (writing queries, etc.) using SQL Server

Nice to Have Skills :

  • Ability to synthesize requirements and work with developers to create options / recommendation papers for decisions to be made by any stakeholder level.
  • Strong written and verbal communication skills, including meeting facilitation skills.
  • Knowledge of data warehousing and reporting in the education sector (K-12 / P20W).

    • Data Warehouse Business Analyst Description :

  • The client is seeking two Business Analysts who will serve as members of the Data Warehouse and Decision Support (DWDS) section. The DWDS team is responsible for the statewide longitudinal data warehouse (SLDS), development, system testing, analysis, maintenance, and integration of data in the SLDS, WISEdash, and other reporting systems (Microsoft Fabric / Power BI). These systems require extensive K-12 sector knowledge and experience in integrating complex data and developing dashboards and reports to convey that information to clients' staff, school districts, and the general public. This person will be a member of a team practicing the Agile / Scrum development methodology.
  • This person will work on the transition of reporting and software features into technical requirements, such as epics, features, and stories, following Agile / Scrum-based software development, as well as determine release plans and project scope. This position will work with and serve as a liaison between management and business units within the client's department, external stakeholders, product owners, developers, and the scrum master and product owner to identify and analyze opportunities for improving reporting processes and business systems.
  • This position will be responsible for conducting research, analyzing and documenting system requirements and business rules, and creating user stories. This position will also be responsible for creating functional requirements and specifications, preparing process flow diagrams, and assisting with quality assurance.
  • Under the general supervision of the DWDS section manager, this person will work closely with others to accomplish project objectives or function independently to accomplish daily work requirements as a member of the DWDS team. Objectives, priorities and deadlines are established in consultation with the department program area leaders, project managers, and DWDS and IT managers.

    • Required Skills :

  • Prior experience in data warehousing or reporting projects (3-5 years)
  • Strong written and verbal communication skills, including meeting facilitation skills.
  • Ability to work in a team environment as well as independently
  • Possess a fundamental understanding of end-to-end customer dashboard use integration and dependencies
  • Experience preparing business requirements and functional specifications
  • Experience writing user stories with clearly defined acceptance criteria
  • Ability to estimate phases of work and contribute to project planning.
  • Ability to create test plans and perform application, reporting, and system regression tests
  • Ability to synthesize requirements and work with developers to create options / recommendation papers for decisions to be made by any stakeholder level.

    • Required Technical Skills :

  • Ability to work with both business / program area owners and translate their needs to developers.
  • Experience using Azure DevOps or similar tools to manage user stories and sprint backlogs.
  • Experience using relational databases (writing queries, etc.) using SQL Server
  • Knowledge of Microsoft Fabric and Power BI reporting solutions.

    • Preferred Experience :

  • Minimum 2-5 years' experience using Agile / Scrum Development Methodology
  • Experience working with education software or reporting systems at the school, district, or state levels.
  • Knowledge of data warehousing and reporting in the education sector (K-12 / P20W).
  • Experience using Asana to track and report on project milestones.
    • serp_jobs.job_alerts.create_a_job

    Data Warehouse Analyst • WI, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Applications Analyst

    Applications Analyst

    J. F. Ahern Co.Fond du lac, WI, United States
    serp_jobs.job_card.full_time
    Looking for a company that values your skills, respects your contributions, and gives you the tools to thrive?.With more than 145 years as a family-owned business, we've built a reputation as one o...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Professional Engineer

    Professional Engineer

    Walters BuildingsAllenton, WI, US
    serp_jobs.job_card.full_time
    Walters Buildings, the premier family-owned post fame builder in the Midwest, is hiring a.Under the general direction of Engineering Manager, responsible for design, calculations, and code review f...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Crop Data Specialist

    Crop Data Specialist

    IIANWaupun, WI, US
    serp_jobs.job_card.full_time
    We proudly serve the Midwest agricultural community with our unique integration of insurance and technology.Our team is excited to be growing again!. Work closely with our team of agents regarding m...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Test Technician II

    Test Technician II

    Axelon Services CorporationOshkosh, WI, US
    serp_jobs.job_card.full_time
    Heavy duty (diesel) or automotive technician background experience.Degree not required but preferred.If not local, a second phone screen. The role involves supporting senior technicians and engineer...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.new
    Business Analyst – Data Warehousing / Analytics

    Business Analyst – Data Warehousing / Analytics

    Akaasa TechnologiesWI, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Business Analyst Data Warehousing / Analytics 101 E.Wilson Street, 6th Floor, Madison, WI 53703 (Remote position but still need someone who live in that area)< / p&...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    IT Systems Analyst

    IT Systems Analyst

    Dodge CountyJuneau, WI, United States
    serp_jobs.job_card.full_time
    Position Open Until Filled - Application Review Date : .Please submit Resume and Cover Letter with application.We are looking for a motivated individual who can align technical solutions with Dodge C...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Process Engineer

    Process Engineer

    E.K. MachineFall River, WI, United States
    serp_jobs.job_card.full_time
    Are you looking for your next career opportunity? Due to a recent promotion, we are seeking a Process Engineer to plan, direct and coordinate the manufacturing processes in our Fall River, WI manuf...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Principal Data Scientist

    Principal Data Scientist

    Delta DefenseWest Bend, Wisconsin, US
    serp_jobs.job_card.full_time
    As a Principal Data Scientist at {EMPLOYER-DESC}, you will lead innovative projects and develop complex, data-driven solutions for improving service performance and delivery.This pivotal role encom...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Test Products from Home – $25-$45 / hr + Freebies

    Test Products from Home – $25-$45 / hr + Freebies

    OCPAMarkesan, Wisconsin, us
    serp_jobs.job_card.part_time +1
    Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies. We guarantee 15-25 hours per week with an hourly pay of bet...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Lead Quality Technician

    Lead Quality Technician

    ABR Employment ServicesMayville, Wisconsin, US
    serp_jobs.job_card.full_time
    ABR Employment Services is working with a component manufacturer of wire harnesses, cable assemblies, and electromechanical assemblies in Mayville, WI to fill a Lead Quality Technician position.Thi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Assembly - ISAS

    Assembly - ISAS

    CumminsOshkosh, WI, US
    serp_jobs.job_card.full_time
    Manufacturing for our Cummins Inc.Operates machines and production equipment in accordance with quality and productivity requirements safely in a manufacturing environment with limited guidance.In ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Cost Engineer

    Cost Engineer

    Pentangle Tech Services | P5 GroupFond du Lac, WI, US
    serp_jobs.job_card.full_time
    Job Description & Skill Requirement.Provide guidance to Designers / Design Engineers for proposed new or modified designs to achieve required function at minimum cost. Apply design for assembly (D...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Professional Engineer (Allenton)

    Professional Engineer (Allenton)

    Walters BuildingsAllenton, WI, US
    serp_jobs.job_card.part_time
    Walters Buildings, the premier family-owned post fame builder in the Midwest, is hiring a.Under the general direction of Engineering Manager, responsible for design, calculations, and code review f...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Process Engineer

    Process Engineer

    American Packaging CorporationColumbus, WI, United States
    serp_jobs.job_card.full_time
    At American Packaging Corporation (APC), you'll find the packaging career you've been looking for.With competitive salaries, excellent benefits, 401(k) plans and tuition reimbursement programs, we ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Optimization Engineer

    Optimization Engineer

    AgropurWinnebago County, WI, United States
    serp_jobs.job_card.full_time
    Job Type : Regular Invest in you, Join Agropur.We dairy you! How Agropur invests in YOU : Competitive and comprehensive compensation and benefits package focusing on your physical, financial, and emo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Side Hustle Developer

    Remote Side Hustle Developer

    Finance BuzzLomira, Wisconsin, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    AI Agent Evaluation Analyst

    AI Agent Evaluation Analyst

    MindriftWI, US
    serp_jobs.filters.remote
    serp_jobs.job_card.part_time +1
    serp_jobs.filters_job_card.quick_apply
    This opportunity is only for candidates currently residing in the specified country.Your location may affect eligibility and rates. Please submit your resume in English and indicate your level of En...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Freelance GenAI Developer - Prompt Engineering & Data Workflows

    Freelance GenAI Developer - Prompt Engineering & Data Workflows

    MindriftWI, US
    serp_jobs.filters.remote
    serp_jobs.job_card.part_time
    serp_jobs.filters_job_card.quick_apply
    This opportunity is only for candidates currently residing in the specified country.Your location may affect eligibility and rates. Mindrift is looking for passionate freelance contributors to join ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days