Job Description
A Business Analyst is sought to collaborate with stakeholders, gather requirements, and analyze large datasets using PostgreSQL and advanced SQL. The role involves working with data engineers and BI teams, supporting data quality, and developing dashboards with Tableau, Power BI, or Excel. Key responsibilities include maintaining data dictionaries, participating in UAT, and demonstrating strong analytical and communication skills. Proficiency in data modeling and relational databases is essential.
Good To Have:
- Experience or strong working knowledge of Snowflake, PostgreSQL, SQL, and Tableau.
- Experience with scripting languages such as Python or R.
- Familiarity with ETL processes and data warehousing.
- Exposure to Agile/Scrum development methodologies.
- Experience working in cloud environments (e.g., AWS RDS for PostgreSQL).
Must Have:
- Collaborate with stakeholders to gather, understand, and document business requirements.
- Analyze large datasets stored in PostgreSQL and derive actionable business insights.
- Write advanced SQL queries for data extraction, transformation, and reporting.
- Work closely with data engineers, developers, and BI teams to deliver solutions.
- Support data quality checks, validations, and conduct root cause analysis of data issues.
- Develop and maintain dashboards and reports using Tableau, Power BI, or Excel.
- Assist in developing data dictionaries and maintaining business glossaries.
- Participate in User Acceptance Testing (UAT), troubleshooting, and validation of features.
- Demonstrate proficiency in PostgreSQL, including complex SQL query writing and database structures.
- Apply strong analytical and problem-solving skills, with close attention to detail.
- Understand data modeling concepts and work effectively with relational databases.
- Communicate effectively with technical and non-technical stakeholders.
Primary Skills
- AWS Elastic Beanstalk, AWS Lambda, Amazon CloudFront, Amazon API Gateway, AWS Step Function
Job requirements
- Location: Novi, MI – Open to remote work with occasional travel to Novi as required by the client
Job Responsibilities:
- Collaborate with stakeholders to gather, understand, and document business requirements.
- Analyze large datasets stored in PostgreSQL and derive actionable business insights.
- Write advanced SQL queries for data extraction, transformation, and reporting.
- Work closely with data engineers, developers, and BI teams to deliver solutions aligned with business objectives.
- Support data quality checks, validations, and conduct root cause analysis of data-related issues.
- Develop and maintain dashboards and reports using tools like Tableau, Power BI, or Excel.
- Assist in developing data dictionaries and maintaining business glossaries.
- Participate in User Acceptance Testing (UAT), troubleshooting, and validation of database-related features and reports.
- Demonstrate proficiency in PostgreSQL, including complex SQL query writing and a solid understanding of database structures.
- Apply strong analytical and problem-solving skills, with close attention to detail.
- Understand data modeling concepts and work effectively with relational databases.
- Communicate effectively with technical and non-technical stakeholders.
Preferred Qualifications:
- Experience or strong working knowledge of Snowflake, PostgreSQL, SQL, and Tableau.
- Experience with scripting languages such as Python or R is a plus.
- Familiarity with ETL processes and data warehousing.
- Exposure to Agile/Scrum development methodologies.
- Experience working in cloud environments (e.g., AWS RDS for PostgreSQL) is an added advantage.
Know more about:
DAI: https://www.brillio.com/services-data-analytics/
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
#LI-SR1
Set alerts for more jobs like Business Analyst
Set alerts for new jobs by Brillio
Set alerts for new Business Analysis jobs in United States
Set alerts for new jobs in United States
Set alerts for Business Analysis (Remote) jobs
