A Data Analyst develops computer programs to analyze large customer information databases for companies and organizations. Analyzes data to identify patterns and provide information relevant to a particular business, industry or field; analysis may be used for marketing, or to detect fraud in financial transactions, or for research. Develops computer programs to protect confidential customer information.
Job Overview We are seeking a dynamic and detail-oriented Data Analytics Consultant to join our innovative team. In this role, you will leverage your expertise in data analysis, visualization, and business intelligence tools to turn complex data sets into actionable insights. Your energetic approach will drive strategic decision-making across various departments, empowering the organization to achieve its goals. You will collaborate closely with stakeholders to understand their needs, develop tailored dashboards and reports, and optimize data workflows throughout the software development lifecycle. This paid position offers an exciting opportunity to work on diverse projects that challenge your technical proficiency and analytical skills while contributing to impactful business solutions. Responsibilities Analyze large datasets using advanced data analytics tools such as R, Python, SQL, and Excel to identify trends, patterns, and opportunities for improvement. Design and develop interactive dashboards and reports utilizing Tableau, Power BI, Looker, and other reporting tools to visualize key performance indicators (KPIs). Collaborate with business stakeholders to gather requirements through detailed analysis and translate them into effective data models and visualizations. Manage ETL (Extract, Transform, Load) processes to ensure accurate data integration from multiple sources including SQL databases, Oracle, Talend, and Linked data environments. Conduct database design and query management activities using Microsoft SQL Server, Oracle, and SQL scripting to support reporting needs. Participate in the entire software development lifecycle analysis (SDLC), ensuring best practices in project management and agile methodologies are followed. Develop and maintain documentation for dashboards, data models, workflows, and technical specifications using tools like Visio. Skills Proficiency in data visualization platforms such as Tableau, Power BI, and Looker for dashboard development and reporting. Strong knowledge of SQL databases including query management, database design, and data modeling techniques. Experience with ETL tools like Talend or scripting languages such as Bash (Unix shell) for data pipeline automation. Programming skills in R and Python for statistical analysis and predictive modeling. Familiarity with business intelligence concepts including requirements analysis, business analysis, and analytics best practices. Understanding of the software development lifecycle (SDLC) combined with experience in Agile project environments. Ability to perform Excel data analysis effectively using VBA macros for automation purposes. Knowledge of linked data principles for integrating diverse datasets across platforms. Technical proficiency in database management systems such as Microsoft SQL Server and Oracle. Strong analysis skills complemented by excellent communication abilities to translate technical insights into business strategies. Join us as a Data Analytics Consultant where your expertise will fuel smarter decisions through innovative data solutions!
Pay:
$114,541.92 - $137,942.97 per year
Benefits:
401(k) Cash balance pension plan Childcare Disability insurance Health insurance Work from home