Data Analyst - Reporting

Job Description Job Title: Data Analyst - Reporting Analyst Type of Engagement: 12-month contract (Not open to 3rd party C2C consultants. Visa sponsorship is not available) Work Location: Hybrid position located in Charlotte, NC (3days/week in office) Job Overview This position is responsible for designing, developing, and maintaining dynamic reports, dashboards, and data visualization solutions using business intelligence reporting tools. Includes developing complex SQL queries, scripts, and stored procedures to deliver data sets required for advance Business Intelligence reporting. Essential Job Responsibilities • Creates comprehensive reporting packages that provides visually appealing data insights and details across multiple channels that align with core business objectives. • Works directly with stakeholders to gather and translate reporting requirements into deliverables. • Illustrates data in meaningful, professional and easy to understand formats for various audiences. • Learns the business and key performance indicators to provide better analytic solutions across multiple channels. • Produces wireframes and mockups to demonstrate proposed solutions in a fast-pace environment. • Designs, develops, tests, documents and maintains database queries and reports. • Gathers data inputs from moderately complex data sources, both internally and externally. • Develops systematic reporting processes and procedures to ensure timely delivery of daily, weekly, monthly, annual and ad hoc reporting to management. • Maintains and enhances existing reports and dashboards. • Troubleshoots reporting and data integrity concerns to ensure completeness to meet business needs. • Combines various data sources into a comprehensive understanding of customer behaviors and feedback for channel and service improvement opportunities. • Communicates requirements to Data Architects and ETL teams for extracting data from various data sources, creating new data warehouses and data marts. Required Skills & Experience • Bachelor’s degree from a four-year college or university or 7 years of related experience in lieu of a degree • 3 years of related experience in information technology, sales & marketing, e-commerce, customer services, project management, or process improvement Big Points If You Have • BS/BA degree in Computer Information Systems, Computer Science, Business Administration or equivalent. • 3 to 5+ years of related experience in a Data Scientist, Reporting Developer or Analyst role. • Must be prepared to demonstrate a professional portfolio, either online or printed. • Accomplished at designing and creating data visualization reporting solutions and dynamic dashboards using business intelligence and reporting tools such as Microsoft Power BI, Report Builder, SSRS, PowerPivot, SAS, Tableau and / or equivalent reporting tools. • Demonstrated ability to package information in a clear, concise and in a visually appealing manner. • Proficient in developing complex SQL queries, scripts, and stored procedures from Relational Databases in a SQL/Oracle Server environment. • Experience communicating requirements to Data Architects and ETL teams for extracting data from various data sources, creating new data warehouses and data marts. • Must be capable of transitioning departmental reporting environment to Power BI. • Desire and passion to learn new data visualization techniques, new competencies and skills independently to recommend and implement new reporting methods and procedures. • Must be creative, responsive and adaptive in a dynamic environment. • Excellent analytical and problem solving capabilities with special attention to accuracy and detail. • Self-starter with a proven ability to take ownership of job responsibilities and ensure successful completion of all projects and requests. • Ability to effectively prioritize and multi-task in high volume workload situations. • Experience in various programming languages SQL, DAX, R, Visual Basic and / or equivalent programming language a required. • Familiarity with processes of SSIS, ETL and OLAP. Job Requisition # 39529 A reasonable estimate of the pay range for this role is $43.59 - $48.59 per hour. The disclosed pay range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The compensation decisions are dependent on the facts and circumstances of each case, such as skills and experience levels. Meet APC APC is a professional staffing and services organization focused on engaging people and positively impacting lives. As “Professionals serving Professionals”®, we take pride in providing our employees and contractors with the highest level of customer service and support. APC is committed to creating a diverse work environment and is proud to be an Equal Opportunity Employer. All qualified candidates will receive consideration without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status.