BI Developer

Job#: 2046407

Job Description:

• 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: Implement proofs of concept using business intelligence and data visualization technologies and 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.

• A 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.
• The ability to work under pressure and be delivery-focused and pragmatic.
• Excellent teamwork with collaborative, innovative, and intelligent problem-solving skills.
• Strong attention to detail and the ability to work independently.

• 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 of experience with data visualization tools, including Amazon QuickSight, Tableau, PowerBI, etc.
• 1+ years of 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 AWS Lambda, Amazon Redshift, etc.
• Deep experience in writing complex SQL scripts using PostgreSQL, Oracle, AWS Redshift, or other relational databases. Hands-on experience with AWS Redshift is a primary requisite.
• 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 of data transformation and analysis.
• Ability to create datasets in 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 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, and GitLab is a plus.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.