APN Consulting has an immediate need for a Direct client requirement for a BI developer to be based in Piscataway NJ. This is a FTE role with our client.
Job Summary
The overall purpose of this position is to design, develop, maintain, and support complex business intelligence applications and solutions. Analyzes business intelligence needs and requirements and provides analysis, designs, and reporting development in response. Tests reporting solutions for functionality and integrity; troubleshoots and resolves errors. Develops standard or custom reports, queries, or dashboards that access and consolidate information from a variety of data sources, and provide ongoing support for data users. Utilizes data mining techniques and develops data models to assist in the visualization and interpretation of data. The role typically reports to the Director of Data Engineering, manages no direct reports, and has high contact and interaction with customers and vendor partners. Works independently and collaboratively.
Responsibilities
- BI Solution Development: Design, develop, and deploy business intelligence solutions, including dashboards, reports, and data visualizations.
- Data Modeling: Develop and maintain data models that support the reporting and analysis needs of the business.
- ETL Processes: Design and implement efficient ETL (Extract, Transform, Load) processes to ensure data is accurately collected, processed, and stored.
- Database Management: Work with relational and non-relational databases to structure and optimize data storage and retrieval.
- Reporting: Create and manage reports using BI tools (e.g., Power BI, Tableau, QlikView, etc.) and ensure they meet business requirements.
- Data Analysis: Collaborate with stakeholders to understand their data needs and translate them into actionable insights.
- Performance Optimization: Monitor and improve the performance of BI tools and queries to ensure optimal data retrieval and processing times.
- Documentation: Maintain comprehensive documentation for all BI processes, including data sources, data models, and reporting structures.
- Collaboration: Work closely with data analysts, data engineers, and business stakeholders to ensure the accuracy and relevance of BI solutions.
- Training: Provide training and support to end-users to maximize the effective use of BI tools and resources.
Qualifications
Education
Bachelor's degree or equivalent experience Computer Science, Information Technology, Data Science, or a related field.
Required Skills
- Advanced Excel skills
- Experience in building visualizations and dashboards presenting data in a simplified manner
- Solid presentation, public speaking, and communication skills
- Proficiency with BI tools (e.g., Power BI, Tableau, QlikView)
- Strong knowledge of SQL and database management systems (e.g., SQL Server, Oracle, MySQL).
- Experience with ETL tools and processes
- Familiarity with data warehousing concepts and data modeling techniques
- Understanding of scripting languages (e.g., Python, R) is a plus