What are the responsibilities and job description for the Business Intelligence Developer, QuickSight position at A Society Group, Inc.?
The QuickSight Business Intelligence Developer is responsible for generating reports, dashboards, KPIs, and visualizations using Amazon Web Services (AWS). As a developer, you will be responsible for gathering, analyzing, and presenting data and information in the form of comprehensive dashboards. You will collaborate with various departments and stakeholders to identify reporting needs and produce accurate and concise reports leveraging BI tools and techniques.
ESSENTIAL JOB FUNCTIONS/RESPONSIBILITIES
• Data Collection and Analysis: Collect and analyze data from various sources, including the data warehouse, using SQL and DQL queries to identify trends, patterns, and insights relevant to the report's purpose.
• Planning: Collaborate with stakeholders to determine the objectives, scope, and key
metrics for the report. Understand the target audience and tailor the report accordingly.
• Development: Work on implementing proofs of concept using business intelligence and data visualization technologies and also develop/enhance new or existing dashboards.
• Data Visualization: Utilize appropriate data visualization techniques (graphs, charts,
tables, etc.) to present complex information in a visually appealing and understandable manner.
• Quality Assurance: Review and proofread reports for errors, consistency, and adherence to formatting guidelines. Ensure that the information presented is reliable and valid.
• Stakeholder Collaboration: Collaborate with cross-functional teams, department heads, and clients to understand their reporting requirements and address any questions or concerns.
• Research and Trends: Stay updated with industry trends, best practices, and emerging technologies related to reporting and analytical tools. Apply new knowledge and techniques to enhance reporting processes.
• Report Maintenance: Monitor and update existing reports to ensure accuracy,
relevance, and timeliness. Modify reports as required based on feedback and changing needs.
• Documentation: Maintain comprehensive documentation of report specifications,
methodologies, and data sources. Keep track of revisions, updates, and version control.
• Process Improvement: Continuously evaluate and improve reporting processes, methodologies, and tools to enhance efficiency and effectiveness. Explore opportunities to automate report generation using business intelligence and analytical tools.
We are looking for motivated candidates that show us:
• Hands-on approach, passionate about solving business problems through innovation and engineering practices.
• The ability to design, document and develop world-class highly scalable enterprise
applications leveraging the latest technologies and design patterns.
• Can work under pressure and be delivery focused and pragmatic.
• Excellent teamwork with collaborative, innovative intelligent problem solving.
• Strong attention to detail and ability to work independently.
SKILLS AND EXPERIENCE
• Bachelor's degree in a relevant field such as computer science, data science or similar is desirable. A higher degree is a plus.
• 4 years experience with a Data Visualization tool including Amazon QuickSight, Tableau, PowerBI, etc.
• 1 years experience with Amazon QuickSight is preferred.
• In-depth understanding of the data lifecycle with hands-on experience in its
implementation
• Proficiency in a range of Amazon Web Services (AWS), including Amazon Web Services (AWS) Lambda, Amazon Redshift etc.
• Deep experience in writing complex SQL scripts using Postgres SQL, Oracle, Amazon Web Services (AWS) Redshift or any other relational Databases. Hands on experience with Amazon Web Services (AWS) Redshift will be primary requisite.
• Employ strong SQL skills for analysis, validation, and verification of data.
• Demonstrated expertise in creating Amazon QuickSight reports, including a nuanced understanding of reporting intervals and backend calculations for all out-of-the-box reports.
• Proven ability to architect solutions and fulfill requests within specified frameworks in a timely manner.
• Strong communication skills with the ability to engage confidently with clients at various levels, gathering requirements, conducting demonstrations, and providing training.
• Detail-oriented with a commitment to delivering accurate and high-quality insights.
• Understanding to perform data transformation and analysis.
• Ability to create a dataset in Amazon Web Services (AWS) QuickSight and configure detailed dashboards.
• Document and maintain a comprehensive set of requirements, ensuring clarity and
alignment with project deliverables. Regularly update project documentation, including requirements, design decisions, and progress reports.
• Provide training sessions for the internal team and clients on using Amazon Web Services (AWS) QuickSight. Conduct knowledge transfer sessions with the team for ongoing support and maintenance.
• Conduct regular status meetings with the internal project team to discuss progress,
blockers, and adjustments to the project plan.
• Utilize JIRA for project tracking, creating and updating tasks, assigning responsibilities, and monitoring overall project progress.
• Participate in scrum activities.
• Familiarity with Java or python, GITLAB will be a plus.