BI Developer III

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 sets

SKILLS & 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 software

BI Developer I

• 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

BI 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 preparation

Requirements

• 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)

BI Developer III

• 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

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.


• Tableau Desktop Professional and Server Associate Certification a plus


• Alteryx Designer Advanced Certification


• 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