Business Analyst, Database & Power BI Developer
PSI CRO AG
full-time
Posted on:
Location Type: Hybrid
Location: São Paulo • Brazil
Visit company websiteExplore more
About the role
- Collaborate with business stakeholders to understand and document business needs, goals, and challenges.
- Translate business requirements into clear technical specifications and development tasks.
- Facilitate meetings and discussions with stakeholders to gather requirements, clarify expectations, and collect feedback throughout the project lifecycle.
- Ensure alignment between business objectives and the technical solutions being implemented.
- Design data solutions that support business requirements, including database structures, views, and data models.
- Contribute to the creation and maintenance of project plans, ensuring technical development aligns with business priorities and timelines.
- Identify opportunities to improve data processes, reporting capabilities, and system efficiency.
- Develop and maintain database objects such as tables, views, stored procedures, and data transformations.
- Build and maintain Power BI reports and dashboards that provide actionable insights for business users.
- Write and optimize SQL queries to support reporting, data analysis, and system integrations.
- Ensure data models are efficient, scalable, and aligned with reporting requirements.
- Act as a bridge between business stakeholders and technical teams, ensuring requirements are clearly understood and implemented.
- Participate in Agile ceremonies such as sprint planning, daily standups, and sprint reviews.
- Work closely with development teams to clarify requirements, refine tasks, and ensure deliverables meet business needs.
- Support testing activities by validating that solutions meet business requirements and data accuracy standards.
- Assist in identifying both positive and negative test scenarios aligned with business processes.
- Provide business and technical context during testing to ensure real-world scenarios are properly evaluated.
- Help determine whether issues identified during testing represent defects or expected behavior based on defined business logic.
- Support User Acceptance Testing (UAT) by coordinating with stakeholders and incorporating feedback into solution improvements.
- Work closely with developers, QA teams, and business stakeholders to ensure solutions are delivered accurately and efficiently.
- Promote clear communication between technical and non-technical teams to ensure alignment on requirements, timelines, and deliverables.
- Contribute to continuous improvement of data processes, reporting capabilities, and team collaboration.
- Support deployment activities by coordinating with technical teams to ensure database and reporting changes are properly released.
- Validate that deployments function as expected and monitor post-release performance.
- Identify opportunities for improvement based on system performance, user feedback, and operational needs.
Requirements
- Minimum 3 years of experience in a database development role (e.g., SQL Server, PostgreSQL, Oracle)
- Ability to analyze complex business problems and document requirements, processes, and workflows.
- Strong proficiency in SQL, including complex queries, joins, subqueries, data transformations, and performance optimization.
- Experience designing and developing database objects and data models.
- Experience building dashboards, reports, and data models in Power BI that provide meaningful business insights.
- Ability to work with diverse stakeholders, understand their needs, and translate them into technical solutions.
- Familiarity with Agile methodologies and experience working within cross-functional development teams.
- Strong analytical and problem-solving capabilities
- Strong written and verbal communication skills to translate business requirements into technical specifications and explain technical concepts to business users.
- Ability to work independently and collaboratively within cross-functional teams.
- Highly detail-oriented with a commitment to data accuracy and reliability.
Benefits
- Flexible work arrangements
- Professional development
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdatabase developmentdata modelingPower BIdata transformationsperformance optimizationstored proceduresdatabase objectsreportingdata analysis
Soft Skills
analytical skillsproblem-solvingcommunication skillscollaborationattention to detailstakeholder managementrequirements gatheringtechnical specification writingfacilitationcontinuous improvement