Business Intelligence Analyst I (Remote)

Interested in joining Milwaukee County? Milwaukee County is searching for authentic people who are out to change the game and bring their whole selves to work every day.
Milwaukee County oversees operations from our Airport, Behavioral Health, Child Support Enforcement, Combined Court Operations, Sheriffs Department, House of Corrections, Human Services, Parks, Public Safety, Public Works, Fleet Operations, Transportation, and at the Zoo. Our departments are also dedicated to our Seniors in the Department on Aging, those with Disabilities, and Veterans Affairs. Our employees also remain committed to serve the cultural, human, recreational and social needs of the entire community.
Milwaukee County offers a wide variety of interesting jobs for people who want to make a difference in our community. Milwaukee County provides a competitive benefit package and is an Equal Opportunity Employer. If disability related accommodations are needed, please contact 414-278-3936.
Come and join our team and discover our diverse and versatile community of independent spirits and unique talents, we are redefining the way you think about Milwaukee County!
Business Intelligence Analyst I (Remote)
IMSD
Salary Pay Range: $79,955.20 - $95,222.40
Closing Date: 05/02/2023 @ 11.59 pm or upon receiving 50 applications
Job Summary - The Enterprise Data Services (EDS) team is seeking a highly curious and growth-oriented individual who is passionate about delivering data products that drive organizational strategic decision-making and surpassing expectations of the end-users. While the Business Intelligence (BI) Analyst I may occasionally work on all phases of the analytics lifecycle, including data collection, profiling, manipulation, storage, and validation as well as data analysis, measure development, report creation, data visualization, and production support, this role has a heavy emphasis on EDS DevOps, data engineering, and creation of data pipelines in Azure. The BI Analyst I exercises independent judgment and discretionary decision-making related to managing multiple and more complex reporting projects but also collaborates with a larger team working an agile process. The BI Analyst I will participate in delivering data products and may present to various levels of management and staff and may also be included in action plan development. While performing the day-to-day tasks successfully in this role is critical, the BI Analyst must be outcome-based and keep the overarching project goals and vision at the forefront, and both make and execute on recommendations to achieve those.
Job Responsibilities:

• Creates automated data pipelines to assist in data extraction, transformation, and storage for report creation, analytics, and self-service
• Conducts data profiling of source data, including descriptive statistics, to identify data quality issues and other opportunities to gain a better understanding of the data to deliver quality data products to the end-users
• Conducts regular audits of work to ensure accuracy. Participates in the testing phases of development prior to User Acceptance Testing
• Provides production support for all data products provided by EDS
• Participates in continuous improvement processes to advance the maturity of the EDS team and larger organization, including proactively identifying and learning about new technologies or opportunities to improve the work of the team
• Mentors others on the team and in the business on how to leverage specific data and technology to enhance the work of the county
• Utilizes project management knowledge and skills for assigned departmental project; establishing timelines, tasks, follow up items and communication to ensure all tasks activities are completed within the project needs
• Participates in other departmental and organizational activities/initiatives tied to data, analytics, and technology
• Assists in the intake process of new data program initiatives and projects, including defining business goals, desired outcomes, user stories, and requirements
• Determines appropriate analysis techniques and methods to provide data products that address the business strategic goals and questions
• Identifies new opportunities and insights in the data to make recommendations to the business
• Delivers data products, including dashboards and other analytics products, that are audience specific
• Clearly presents data initiative results to all levels of the business in a consumable fashion that is audience specific

Minimum Requirements:

• Current resident of the State of Wisconsin.
• A valid state of Wisconsin driver's license at time of hire and maintained throughout employment.
• Associate's degree or above in Statistics, Mathematics, Economics, Computer Science/MIS, Engineering
• At least one (1) or more years of experience in:

1. Enterprise Data Warehousing (EDW)
2. Speaking to technical people in this industry and understand what a Data Warehousing application is supposed to look and function like
3. Understanding how the Star Schema works, what a fact table and data dimension is and how they relate
4. Business Intelligence Analyst role and delivering data processes and products that drive organizational decision-making

Proficient in SQL language.

Additional/Preferred Skills:

• Proven track record of developing ETL solutions, including the use of Microsoft SSIS
• Leveraging descriptive statistics to gain an initial understanding of a new data set
• Conducting diagnostic analyses to help understand the 'why' behind data trends and results
• Utilizing BI tool such as Power BI or Tableau to visualize data and communicate a story
• Utilizing other tools such as Microsoft SQL Server Management and Visual Studio
• Proven track record of efficiently learning and implementing new technologies on the job
• Understanding how Business Intelligence reporting solutions fit within an enterprise data model and within data architecture
• Proven analytical, critical thinking and problem-solving abilities
• Proficient in spreadsheet, reporting, and database tools (e.g., Excel, Access, other Microsoft Office applications)
• Proficient understanding of data base structures, relational databases, and concepts
• Excellent listening and time management skills
• Successfully communicating complex, technical items to non-technical people in an easy-to-consume fashion
• Proven aptitude and interest in working with complex situations/problems, systems, and processes
• Ability to work independently and within teams
• Flexibility to meet organizational and departmental demands
• Previous experience in Azure Data Lake Storage gen2, Azure Databricks, Synapse Analytics, Spark, and Python
• Working an Agile development process using Jira to track sprints
• Previous experience in predictive analytics

Note: This Original Examination is open to current residents of the State of Wisconsin. The selection process will be job related and will consist of one or more of the following: education and experience evaluation; written, oral, or performance tests, or other assessment methods.
Milwaukee County is committed to fostering an equitable working environment, free from discrimination and harassment, on the basis of any characteristic protected by law. We prohibit any form of discrimination, harassment based on race, color, religion, sex, gender, gender identity or expression, sexual orientation, pregnancy, pregnancy related condition, national origin, age, disability, FMLA status, sexual orientation, military status, marital status, or any other category or status that is now or in the future protected by federal, state, and local law. We maintain a drug-free workplace and perform pre-employment substance abuse testing, background checks and pre-employment physicals subject to job requirements. If special accommodations are needed, please contact 414-278-3936.
Effective October 1, 2021, Milwaukee County will require all employees to have completed COVID-19 vaccinations and provide proof of vaccination or have submitted a completed medical or religious exemption and accommodation request. All persons offered a position will be required to provide proof of completed COVID-19 vaccination at time of hire or have submitted a completed medical or religious exemption and accommodation request and been approved for an accommodation prior to hire.
Other details

• Job Family 15 - Other
• Job Function 2 Professionals
• Pay Type Salary

Apply Now