BI Developer III

Mouser•Mansfield, TX

22d•Onsite

About The Position

This role is responsible for designing, developing, and analyzing complex data queries to identify data quality issues and present findings in an understandable format. The BI Developer III will create impactful dashboards, provide support to business users, and design and deliver reports based on business requirements. This position also involves troubleshooting BI production processing, deriving business insights from large datasets, performing granular data analysis, and communicating findings to management and stakeholders. Additionally, the role includes developing test requirements, creating ad-hoc queries, understanding user needs, analyzing reporting alternatives, and collaborating with application architects on data model design.

Requirements

4+ years of experience as a BI Developer or relevant experience
4+ years SQL experience required. For internal candidates, experience can be a combination of internal and external experience.
4+ years of experience in report design in at least one reporting tool such as Tableau, MicroStrategy, SSRS, Cognos, Qlikview, etc.
Expert knowledge in traditional relational database concepts and design
Efficient in Python (concentration in data science packages)
Expert in SQL (DDL & DML)
Data design and optimization
Advanced query, join operation, and aggregate
Ability to troubleshoot technical issues
Firm knowledge of Machine Learning and statistics
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 software
Bachelor’s degree in Data, Computer Science, or related field
Experience in report design in at least one reporting tool such as Tableau, MicroStrategy, SSRS, Cognos, Qlikview, etc.
Machine learning knowledge a plus
Python scripting a plus
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 preparation
Minimum 2 years of experience as a BI Developer or relevant experience
2+ years SQL experience required. For internal candidates, experience can be a combination of internal and external experience.
2+ years 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
Tableau Desktop Professional Certification a plus
Alteryx Designer Core Certification
Strong knowledge in traditional relational database concepts and design
Fluent in SQL
Data design and optimization
Advanced query, join operation, and aggregate
Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents)
Tableau Desktop Professional and Server Associate Certification a plus
Alteryx Designer Advanced Certification

Nice To Haves

Tableau Desktop Associate Certification a plus
Machine learning knowledge a plus
Python scripting a plus
MongoDB & Spark experience desired
JSON, XML, HTML data structure experience preferred
Server and application administration experience a plus
Tableau Desktop Professional Certification a plus
Alteryx Designer Core Certification
Tableau Desktop Professional and Server Associate Certification a plus
Alteryx Designer Advanced Certification

Responsibilities

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 sets
Create data models for new projects
Resolve data and application production issues
Optimize legacy data workflows and reports
Create machine learning predictive and prescriptive models (supervised and unsupervised)
Utilize cutting-edge data science techniques to build, train and optimize various predictive models based on technical specifications
Support production systems and monitor performance