Bachelor's degree in Data, Computer Science, or related field
Minimum 2 years of experience as a BI Developer or relevant experience
2+ years of SQL experience required
2+ years of experience in report design using tools like Tableau, MicroStrategy, or Cognos
Experience with MongoDB & Spark is desired
Proficient in Python scripting
Knowledge of machine learning principles is a plus
Responsibilities
Design and analyze complex data queries to identify data quality issues
Develop impactful dashboards for actionable insights
Provide timely support and guidance on BI-related inquiries
Create and deliver reports based on business needs
Troubleshoot and support production processing for BI
Derive business insights from large data sets and communicate findings to stakeholders
Collaborate with users to translate reporting needs into detailed requirements
Benefits
Casual dress environment
Access to a state-of-the-art facility
Competitive pay and benefits package
Opportunities for professional growth and development
Supportive and experienced management team
Full Job Description
Job Description
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)
