BI Developer II

Company: Mouser Electronics Inc.
Location: Mansfield
Posted on: June 19, 2022

Job Description:

The Business Intelligence (BI) Developer serves as the primary report development resource and has responsibility for logging and tracking requests, gathering requirements, designing, developing/coding, executing, and distributing Mouser reports and related data and processes. The BI Developer will work with the Business Intelligence Lead, IS Management and Business Management (including Executives) to identify priority, accuracy and requirements of assignments. The BI Developer is responsible for the delivery of analytic solutions that enable the business to make smarter decisions and will work with the team on multiple projects to build data-driven highly effective software solutions for the business.ACCOUNTABILITIES & ESSENTIAL FUNCTIONS---Design, develop, and analyze the results of complex data queries necessary to identify data quality issues and present results in an easy-to-understand format to end users---Develop impactful dashboards that drive actionable insights---Provide support to business users by answering BI related questions and provide guidance and ad-hoc data as required in a timely manner---Design, implement and deliver reports based on business requirements---Troubleshoot and support all BI related production processing---Derive business insights and oversee the building of data products from large data sets and communicate relevant findings and risks associated to management and stake holders---Perform complex analysis of data at a very granular level and present relevant findings in business terms to business partners---Develop test requirements, implement and test reports, track results and records and escalate issues---Create ad-hoc queries and modify existing query requests---Work with business users to understand reporting and data needs and translate those needs into detailed requirements---Analyze possible reporting alternatives in relationship to business need, costs, effectiveness, and information availability requirements---Work closely with application architects to design a data model to support application development---Create efficient and accurate data setsSKILLS & CERTIFICATIONS---Tableau Desktop Associate Certification a plus---Knowledge of best practices for dashboard design---Advanced Excel skills---Proficient and knowledgeable in design, development and delivery of BI solutions---Understanding of relational and unstructured database management concepts---SQL data querying and manipulation---Proficient with writing/creating reports, business correspondence, and presentations---Excellent verbal and non-verbal communication and able to communicate with people at all levels---PC experience in a Microsoft Windows environment, proficient with internet e-mail, Microsoft Word, Excel, Power Point, Outlook, and other softwareJOB LEVELSBI Developer II---Engage with end-users to identify opportunities where data can enable them to make data-driven decisions---Automate manual data tasks through workflows and ETL packages---Follow guidance from senior team members to plan, deploy, and maintain critical business applications---Data engineering and manipulation of large data sets---Administrate application and server environments---Perform system monitoring and technical support---Troubleshoot and support all BI related production processing---Analyze data quality and make recommendations for data preparationRequirements---2years of relevant experience---Minimum 2 years of experience as a BI Developer---2yearsSQLexperience required.For internal candidates, experience can be a combination of internal and external experience.---2years of experience in report design in at least one reporting tool such as Tableau, MicroStrategy, SSRS, Cognos, Qlikview, etc.---MongoDB & Spark experience desired---JSON, XML, HTML data structure experience preferred---Server and application administration experience a plus---External Candidates must have at least 3 years of experience in BI---Internal Candidates must be a Mouser Level 1 BI Developer with 2 years in BI---Tableau Desktop Professional Certification a plus---Alteryx Designer Core Certification---Strong knowledge in traditional relational database concepts and design---Fluent in SQLoData design and optimizationoAdvanced query, join operation, and aggregate---Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents)This is a summary of the primary accountabilities and requirements for this position.The company reserves the right to modify or amend accountabilities and requirements at anytime at its sole discretion based on business needs. Any part of this job description is subject to possible modification to reasonably accommodate individuals with disabilities.Category:IT/ISEqual Opportunity Employer, including disability and veterans.#LI-PS1

Keywords: Mouser Electronics Inc., Mansfield , BI Developer II, IT / Software / Systems , Mansfield, Texas