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