Business Intelligence and Analytical Developer

PCL Construction - Katy, TX

Full-time - Mid Level

Onsite - Katy, TX

Construction of Buildings

About the position

The Business Intelligence and Analytical Developer at PCL Construction plays a crucial role in bridging the gap between business needs and technology solutions. This position involves designing, developing, and maintaining production reports and dashboards, ensuring that business requirements are met through effective data management and visualization. The role requires collaboration with various teams to support self-service BI and analytics, while adhering to data governance and security policies.

Responsibilities

• Liaises with business, technology, and support teams to ensure business requirements are met
• Translates business needs to design, develop, and maintain production reports and dashboards
• Acquires data from a variety of structured and unstructured data sources
• Designs and develops business data models to support self-service BI and analytics
• Develops and maintains ETL/ELT processes
• Writes queries to retrieve data using Microsoft SQL or leveraging Microsoft Fabric
• Creates and maintains technical documentation
• Defines test plans and executes test cases to ensure BI content processes meet quality assurance standards
• Ensures BI content follows and meets PCL's data governance and security policies
• Manages the implementation, roll out, and direct support of production reports and dashboards
• Delivers presentations/training to the business on created production reports and dashboards

Requirements

• Bachelor's degree or diploma in computer science (or equivalent education)
• 3+ years of design and development experience in business intelligence, data management, and data modeling
• Extensive hands-on experience with data visualization tools such as Microsoft Power BI
• Extensive hands-on experience with ETL/ELT development
• Solid understanding of data modeling and relational database design (DAX Expression) and implementation techniques
• Experience in UI/UX development as it applies to dashboard and report design considered an asset
• Excellent problem-solving and data-analysis skills
• Strong with Microsoft office suite of tools - Microsoft Fabric and SQL Server/ T - SQL knowledge is preferred
• Experience in the complete software development lifecycle (SDLC) including requirements analysis, design, development, QA, maintenance, and CI/CD and version control tools considered an asset
• Effective communication and writing skills necessary to effectively lead technical discussions and information-gathering sessions

Nice-to-haves

• Experience in UI/UX development as it applies to dashboard and report design
• Experience in the complete software development lifecycle (SDLC) including requirements analysis, design, development, QA, maintenance, and CI/CD and version control tools

Benefits

• Retirement plan
• Employee share purchase offering
• Discretionary annual performance bonus
• Comprehensive benefits and wellness programs
• Career development programs