-
Senior SQL Developer
2 weeks ago
Wisconsin Foundation and Alumni Association Madison, United StatesOverview · 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 ...
-
Senior SQL Developer
2 weeks ago
Young Professional Network of the Greater Association of Realtors Madison, United StatesOverview · 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 ...
-
Complex SQL Query Developer
1 week ago
Randstad North America, Inc. Madison, United StatesWe 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 ...
-
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 ...
-
SQL Business Solutions Developer II
1 week ago
Centene Corporation Madison, United StatesYou 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 ...
-
Business Systems Analyst
1 week ago
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 ...
-
Data Management
2 days ago
Zenith Services Madison, United StatesWe 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 StatesJ**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 ...
-
Junior Software Developer
1 week ago
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 ...
-
Business Analyst/consultant Iii
4 days ago
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 ...
-
Data Scientist
1 week ago
Fujifilm Madison, United StatesOverview: · 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 ...
-
Application Architect-ii
2 weeks ago
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 ...
-
Omnichannel Marketing Analyst
4 days ago
Grand Leisure Madison, United StatesWe'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 ...
-
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 ...
-
Application Developer
2 weeks ago
Wisconsin Foundation and Alumni Association Madison, United StatesOverview: · **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 ...
-
Application Administrator
2 weeks ago
Gordon Flesch Company Madison, United StatesOffering 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 ...
-
BI Technical Lead
13 hours ago
Novalink Solutions LLC Madison, United StatesLead 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 StatesTraining 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 ...
-
Data Warehouse Developer
1 day ago
Glow Networks Madison, United StatesWe 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 ...
Power and sql developer - Madison, United States - Computer Consultants International
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.
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