Jobs
>
Madison

    Power and sql developer - Madison, United States - Computer Consultants International

    Default job background
    Description

    JOB REQUIREMENTS:


    This position is responsible for providing technical expertise and services regarding Power BI report maintenance, creation, and SQL query development for the Department, including providing detailed testing for work of others on the team.

    Reports would include but not be limited to data collected through enterprise applications such as the WISEid, WISEdata, the Wisconsin State Assessment System, and data reported in WISEdash.

    The position may also be responsible for fulfilling other state and federal data reporting requirements.

    The person in this position is responsible for peer testing of the work of their teammates including other ETL developers and dashboard developers.

    Objectives, priorities, and deadlines are established in consultation with the user, director and division leadership and discussed biweekly during Agile/Scrum sprint retrospective and planning sessions.


    Example tasks:
    Create new Power BI reports for internal or external use.

    Amend existing Power BI reports, including SQL queries, visuals or DAX.

    Fulfill adhoc data requests from external or internal requesters.

    Peer testing of ETL tables, data views, Power BI reports, SQL queries, test scripts, etc.

    Provide recommendations and solutions for the creation of new reporting solutions.

    Support and troubleshoot scheduled Power BI Service report updates.

    Gather and analyze end user requirements for new or existing reports.


    Complete functional & technical specifications to load data from disparate source systems into Power BI in instances where the data does not belong in the data warehouse.


    Knowledge about the scrum methodologies and agile practices Work with MS SQL Server 2019+ and Oracle databases Create operational processes including test cases & user documentation Using TFS (Visual Studio/Azure Dev Ops) and Sharepoint for source code control, project related document sharing and team collaboration.

    Create Change Management tickets as required. Willingness to learn new technologies that will assist the team. Other duties as assigned relating to the data warehouse project.


    OTHER EXPERIENCE AND QUALIFICATIONS:

    MANDATORY REQUIREMENTS:
    Expert knowledge and use of SQL

    Expert knowledge and experience creating Power BI reports (data modelling, data visualization, DAX)

    Experience in data preparation and data warehousing projects


    NICE TO HAVE:
    Experience with K-12 education data sector

    Knowledge and use of Microsoft SSIS or similar Microsoft BI stack tools (SSRS, SSAS)

    Familiarity with scripting and programming

    Experience or knowledge of working on an Agile/Scrum team (able to work well in a team, but also highly self-motivated and solid communication skills)


    APPLICATION INSTRUCTIONS:

    E-Mail a Rsum:
    #J-18808-Ljbffr

  • Wisconsin Foundation and Alumni Association

    Senior SQL Developer

    2 weeks ago


    Wisconsin Foundation and Alumni Association Madison, United States

    Overview · The Wisconsin Foundation and Alumni Association (WFAA)*, the private fundraising and alumni relations organization for UW-Madison, is recruiting for a SQL Developer / Database Administrator (DBA). In this role, you will be responsible for database and data warehouse d ...

  • Young Professional Network of the Greater Association of Realtors

    Senior SQL Developer

    2 weeks ago


    Young Professional Network of the Greater Association of Realtors Madison, United States

    Overview · The Wisconsin Foundation and Alumni Association (WFAA)*, the private fundraising and alumni relations organization for UW-Madison, is recruiting for a SQL Developer / Database Administrator (DBA). In this role, you will be responsible for database and data warehouse d ...


  • Randstad North America, Inc. Madison, United States

    We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Business/ Systems Analyst to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data- SQL, Developer, Systems Analy ...

  • Springs Window Fashions

    SQL Developer/BA

    1 day ago


    Springs Window Fashions Middleton, United States

    · SQL Developer/Business Analyst · Springs Window Fashions has been part of the window treatments industry since 1939. Headquartered in Middleton WI, we have over 8,000 associates and 14 locations in North America. Our products are available in nearly every major retailer, in th ...


  • Centene Corporation Madison, United States

    You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, youll have access to competitive benefits including a fresh perspective on workplace flexi ...


  • Apptrics LLC Madison, United States

    **Job title **:Business Systems Analyst · **Location**: Madison Wisconsin · **Duration**:12+ Months · **Top Required Skills & Years of Experience**: · - Serve as a liaison between the business and technical staff to design and implement efficient data integration processes. Crea ...

  • Zenith Services

    Data Management

    2 days ago


    Zenith Services Madison, United States

    We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position ...


  • Glow Networks Madison, United States

    J**Desired Experience**: · - Serving as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation - 5 years. · - Developing complex SQL - 5 years · - Gathering req ...


  • BEM Systems, Inc. Madison, United States

    **Job Overview**: **CANDIDATES MUST RESIDE IN NJ TO BE CONSIDERED** · **Responsibilities**: · - Troubleshooting, debugging, and supporting our core products. · - Design new modules/screens as per requirements. · - Support acceptance and production test plans and testing. · - Data ...


  • Zenith Services Madison, United States

    **Position Summary** · Under the general supervision of the Applications Development and Management (ADM) Director and Assistant Director, this position is responsible for performing the work of IT Business Analyst This position is responsible for building relationships with stat ...

  • Fujifilm

    Data Scientist

    1 week ago


    Fujifilm Madison, United States

    Overview: · FUJIFILM Cellular Dynamics is a leading developer and supplier of human cells used in drug discovery, toxicity testing, stem cell banking, and cell therapy development. We partner with innovators from around the world to combine biologically relevant human cells with ...


  • Certec Consulting Madison, United States

    **Application Architect-II - 1744** · **Location: · - Madison, WI** · **100% remote ( contractor may travel to office 1-2 times per quarter)** · **Rate: · - $ 55/hr on W2 - $55/hr on 1099** · **Easy Submission Procedure DO NOT EMAIL**: · **Step 1 DOWNLOAD** · **Step 2 **COMPLETE ...


  • Grand Leisure Madison, United States

    We're looking for an ambitious, energetic **Omnichannel Marketing Analyst** to join our rapidly growing team at Grand Leisure, an industry-leading supplier of outdoor patio furniture, accessories, and solar lighting in the North American mass retail market. With U.S. headquarters ...

  • Zenith Services

    Data Management

    1 week ago


    Zenith Services Madison, United States

    **Responsibilities**: · - Draft quality assurance policies and procedures. · - Design, develop, and execute testing plans · - Perform analysis for adherence to agency policies · - Implement and monitor test scripts to assess functionality, reliability, performance, and quality of ...

  • Wisconsin Foundation and Alumni Association

    Application Developer

    2 weeks ago


    Wisconsin Foundation and Alumni Association Madison, United States

    Overview: · **Who is WFAA?** · The Wisconsin Foundation and Alumni Association is a private, nonprofit corporation that encourages individuals and organizations to make gifts to the university and to connect with the UW. In 2014, the UW Foundation merged with the Wisconsin Alumni ...


  • Gordon Flesch Company Madison, United States

    Offering an opportunity to be part of a high-performance team, enjoy exceptional benefits, and a supportive work-life balance, the Gordon Flesch Company is an employer of choice throughout WI, IL, IN, IA and OH. The Gordon Flesch Company strives to recognize and appreciate our as ...


  • Madison Metropolitan School District Madison, United States

    **Doyle - Dashboard & Report Developer - 1.0 FTE (40 hpw)** · **Technical Services** · **Doyle Administration Building** · $ Hourly Wage · **Position Summary**: · **Responsibilities**: · - Coordinate with the Data Warehouse/Dashboard Supervisor to migrate dashboard and warehouse ...

  • Novalink Solutions  LLC

    BI Technical Lead

    13 hours ago


    Novalink Solutions LLC Madison, United States

    Lead and participate in all aspects of the software development lifecycle · Ability to translate business requirements into technical solutions · Design, administer, maintain and process complex data reporting systems · Advanced coding practices, writing, maintaining, and tuning ...


  • Velocity Enterprises Madison, United States

    Training as an IT specialist for system integration (m/f/d) in Madison · IT specialists for system integration develop and program software for their own company or for clients. For example, they expand in-house programs or develop new solutions tailored to the company's needs or ...


  • Glow Networks Madison, United States

    We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position ...