Hybrid Business Analyst/Database & Power BI Developer

PSI CRO

8d•Hybrid

About The Position

We are looking for a talented and detail-oriented Hybrid Database / Power BI Developer (BA/DEV) to join the Process Improvement team. This role combines responsibilities from the Business Analyst and Developer disciplines. The individual translates business needs into technical solutions and designs and develops the underlying data structures and reporting assets. The BA/DEV ensures that business requirements are understood and implemented through data models, database solutions, and Power BI reporting that deliver meaningful insights and value to stakeholders. The role involves collaborating with stakeholders to gather and document requirements, designing database and data-model solutions, developing database objects and Power BI reports, and supporting the product development lifecycle. The BA/DEV works with business and technical teams through Agile development, testing and User Acceptance Testing, release and deployment, and continuous improvement activities.

Requirements

At least 3 years of experience in a database development role, such as SQL Server, PostgreSQL, or 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 Power BI dashboards, reports, and data models 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, including the ability to translate business requirements into technical specifications and explain technical concepts to business users.
Ability to work independently and collaboratively within cross-functional teams.
High attention to detail and commitment to data accuracy and reliability.

Responsibilities

Collaborate with business stakeholders to understand and document business needs, goals, and challenges.
Translate business requirements into clear technical specifications and development tasks.
Facilitate stakeholder meetings and discussions to gather requirements, clarify expectations, and collect feedback throughout the project lifecycle.
Ensure technical solutions align with business objectives.
Design data solutions that support business requirements, including database structures, views, and data models.
Contribute to creating and maintaining project plans, aligning technical development 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 for reporting, data analysis, and system integrations.
Ensure data models are efficient, scalable, and aligned with reporting requirements.
Bridge business stakeholders and technical teams so requirements are clearly understood and implemented.
Participate in Agile ceremonies, including sprint planning, daily standups, and sprint reviews.
Work with development teams to clarify requirements, refine tasks, and ensure deliverables meet business needs.
Support testing by validating that solutions meet business requirements and data accuracy standards.
Help identify positive and negative test scenarios aligned with business processes.
Provide business and technical context during testing and help determine whether issues are defects or expected behavior based on defined business logic.
Support User Acceptance Testing by coordinating with stakeholders and incorporating feedback into solution improvements.
Collaborate with developers, QA teams, and business stakeholders to deliver solutions accurately and efficiently.
Promote clear communication across technical and non-technical teams regarding requirements, timelines, and deliverables.
Contribute to continuous improvement of data processes, reporting capabilities, and team collaboration.
Coordinate with technical teams on deployment of database and reporting changes.
Validate deployments and monitor post-release performance.
Identify opportunities for improvement based on system performance, user feedback, and operational needs.