Dofactory.com
Dofactory.com

Data Analyst

Company
PCG INTERNATIONAL INC
Job Type
Fulltime
Level
Mid level
Skills

Job Description

Description:

Here at PCG we are problem solvers first and technologists second. What drives us is a desire to understand the fundamental issue and resolve that, not the symptoms. At our core we are a collection of people who excel at understanding data and coaxing from it the best solution to the problem. PCG is seeking a (SQL) Data Analyst who will be to analyze and interpret data using SQL queries and other analytical tools. You will work closely with cross-functional teams to gather requirements, extract relevant data from databases, and provide insights to support data-driven decision-making within the organization. Your role will involve working with large datasets, performing data cleansing and transformation, and creating reports and visualizations to communicate findings effectively.

Key Responsibilities:

  • Data Analysis: Write and optimize SQL queries to extract and manipulate data from relational databases, ensuring data accuracy and integrity.
  • Data Cleansing and Transformation: Identify and resolve data quality issues, perform data cleaning, and transform raw data into usable formats for analysis.
  • Data Modeling: Develop and maintain data models, including data tables, relationships, and data dictionaries, to facilitate efficient data analysis.
  • Data Interpretation: Analyze and interpret complex data sets to identify trends, patterns, and insights, and provide actionable recommendations to stakeholders.
  • Reporting and Visualization: Create meaningful reports, dashboards, and visualizations to effectively communicate data analysis results to non-technical stakeholders.
  • Collaborative Approach: Work closely with cross-functional teams, including business stakeholders, data engineers, and data scientists, to understand data requirements and deliver valuable insights.
  • Performance Monitoring: Monitor and optimize SQL queries and database performance to ensure efficient data retrieval and processing.
  • Data Governance: Adhere to data governance policies and ensure compliance with data protection regulations, maintaining data privacy and security.

Qualifications and Skills:

  • Bachelor's degree in a relevant field such as Computer Science, Statistics, Mathematics, or a related discipline.
  • Proven experience working as a SQL Data Analyst or similar role, with a strong understanding of SQL and relational databases.
  • Proficiency in SQL programming, including complex query writing, data manipulation, and optimization techniques.
  • Familiarity with data visualization tools such as Tableau, Power BI, or similar tools to create meaningful reports and dashboards.
  • Strong analytical and problem-solving skills, with the ability to analyze large datasets, identify trends, and derive actionable insights.
  • Knowledge of data modeling concepts and best practices for designing and maintaining data structures.
  • Excellent communication skills, with the ability to translate complex data analysis results into clear and concise reports for non-technical stakeholders.
  • Attention to detail and a strong commitment to data accuracy and integrity.
  • Ability to work collaboratively in a team environment and manage multiple priorities effectively.

Preferred (not mandatory) Skills:

  • Experience with scripting languages such as Python or R for data manipulation and analysis.
  • Familiarity with data warehousing concepts and techniques.
  • Knowledge of statistical analysis and data mining techniques.
  • Understanding of cloud-based database technologies (e.g., AWS Redshift, Google BigQuery, or Azure SQL Database).
Requirements:
  • Bachelor's degree in a relevant field such as Computer Science, Statistics, Mathematics, or a related discipline.
  • Proven experience working as a SQL Data Analyst or similar role, with a strong understanding of SQL and relational databases.
  • Proficiency in SQL programming, including complex query writing, data manipulation, and optimization techniques.
  • Familiarity with data visualization tools such as Tableau, Power BI, or similar tools to create meaningful reports and dashboards.
  • Strong analytical and problem-solving skills, with the ability to analyze large datasets, identify trends, and derive actionable insights.
  • Knowledge of data modeling concepts and best practices for designing and maintaining data structures.
  • Excellent communication skills, with the ability to translate complex data analysis results into clear and concise reports for non-technical stakeholders.
  • Attention to detail and a strong commitment to data accuracy and integrity.
  • Ability to work collaboratively in a team environment and manage multiple priorities effectively.

Preferred (not mandatory) Skills:

  • Experience with scripting languages such as Python or R for data manipulation and analysis.
  • Familiarity with data warehousing concepts and techniques.
  • Knowledge of statistical analysis and data mining techniques.
  • Understanding of cloud-based database technologies (e.g., AWS Redshift, Google BigQuery, or Azure SQL Database).
 
Ref #
2761406
Posted
17 days ago
  •  
Last updated 16 days ago


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.