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:

1. Data Analysis: Write and optimize SQL queries to extract and manipulate data from relational databases, ensuring data accuracy and integrity.
2. Data Cleansing and Transformation: Identify and resolve data quality issues, perform data cleaning, and transform raw data into usable formats for analysis.
3. Data Modeling: Develop and maintain data models, including data tables, relationships, and data dictionaries, to facilitate efficient data analysis.
4. Data Interpretation: Analyze and interpret complex data sets to identify trends, patterns, and insights, and provide actionable recommendations to stakeholders.
5. Reporting and Visualization: Create meaningful reports, dashboards, and visualizations to effectively communicate data analysis results to non-technical stakeholders.
6. Collaborative Approach: Work closely with cross-functional teams, including business stakeholders, data engineers, and data scientists, to understand data requirements and deliver valuable insights.
7. Performance Monitoring: Monitor and optimize SQL queries and database performance to ensure efficient data retrieval and processing.
8. 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).

• 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).