Business Intelligence Analyst

Business Intelligence AnalystThe 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 surpass the expectations of the end-users. The Business Intelligence (BI) Analyst will 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. The BI Analyst exercises independent judgment and discretionary decision-making related to managing multiple and more complex reporting projects but also collaborates with a larger team working in an agile process. The BI Analyst 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 recommendations to achieve those. Customer experience must be central to how the BI Analyst approaches their work.We are seeking a team member that is excited about data and helping their customers solve business problems with high-quality data solutions. Candidates with a demonstrated track record of strong collaboration with both IT and non-IT customers, easily adapting to varying business domains, creating structure out of ambiguity, and delivering technically will be given preference in the hiring process.Job Responsibilities:Assists in the intake process of new data program initiatives and projects, including defining business goals, desired outcomes, user stories, and requirementsDelivers data products, including dashboards and other analytics products, that are audience-specificCreates automated data pipelines to assist in data extraction, transformation, and storage for report creation, analytics, and self-serviceConducts 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-usersConducts regular audits of work to ensure accuracy. Participates in the testing phases of development before User Acceptance TestingProvides production support for all data products provided by EDSParticipates 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 teamMentors others on the team and in the business on how to leverage specific data and technology to enhance the work of the countyUtilizes project management knowledge and skills for assigned departmental projects, establishing timelines, tasks, follow-up items, and communication to ensure all tasks and activities are completed within the project needsParticipates in other departmental and organizational activities/initiatives tied to data, analytics, and technologyDetermines appropriate analysis techniques and methods to provide data products that address the business's strategic goals and questionsIdentifies new opportunities and insights in the data to make recommendations to the businessClearly presents data initiative results to all levels of the business in a consumable fashion that is audience-specificMinimum Requirements:Current resident of the State of WisconsinAssociate's degree or above in Statistics, Mathematics, Economics, Computer Science/MIS, or Engineering; or related field or experience.At least one to three (1-3) years of experience in:Enterprise Data Warehousing (EDW)Speaking to technical people in this industry and understanding what a Data Warehousing application is supposed to look and function likeUnderstanding how the Star Schema works, what a fact table and data dimension are, and how they relateBusiness Intelligence Analyst role and delivering data processes and products that drive organizational decision-makingProficient in SQL language.Preferred Skills and Experience:Significant experience in addressing untidy dataTranslating ambiguous business needs to technical requirementsPrevious experience in Azure Data Lake Storage gen2 and Azure DatabricksProficiency in Python, including PysparkExperience developing ETL or ELT solutionsLeveraging descriptive statistics to gain an initial understanding of a new data setConducting diagnostic analysis to help understand the 'why' behind data trends and resultsUtilizing BI tools such as Power BI or Tableau to visualize data and communicate a storyUtilizing other tools such as Microsoft SQL Server Management and Visual StudioProven track record of efficiently learning and implementing new technologies on the jobUnderstanding how business intelligence reporting solutions fit within an enterprise data model and within data architectureProven analytical, critical thinking, and problem-solving abilitiesProficient in spreadsheet, reporting, and database tools (e.g., Excel, Access, other Microsoft Office applications)Proficient understanding of database structures, relational databases, and conceptsExcellent listening and time management skillsSuccessfully communicating complex, technical items to non-technical people in an easy-to-consume fashionProven aptitude and interest in working with complex situations/problems, systems, and processesAbility to work independently and within teamsFlexibility to meet organizational and departmental demandsWorking in an Agile development process using Jira to track sprintsPrevious experience in predictive analytics, machine learning modeling, and statistical analysisNote: This ORIGINAL APPLICATION is open to qualified residents of the State of Wisconsin at the time of application. Candidates need to submit a full account of their training and experience (i.e., by submitting an up-to-date resume or by fully completing the application) during the application process and may also be asked to take additional written or performance tests as part of the selection process.Applicants must possess minimum qualifications at time of filing application.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, 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 View phone number on click.appcast.io.